Cimarex

  • Data Architecture Specialist

    Job Location US-OK-Tulsa
    Category
    Information Technology
  • Position Summary:

    Incumbent is responsible for software development and related tasks that serve to maintain, optimize, and expand enterprise data architecture in order to empower business units with access to data for business planning and decision-making.

    Principal Duties & Responsibilities:

    The following represents the majority of the duties performed by the position, but is not meant to be at all-inclusive nor prevent other duties from being assigned when necessary:

    • Collaborate with IT Software Developers and Data Architects, as well as business unit Data Analysts, Engineering Techs, and Oil and Gas Engineers on transformational company data initiatives and process improvements, ensuring an optimal and consistent data delivery architecture throughout the company
    • Design and implement scalable Extract/Transform/Load (ETL) processes using SQL Server Integration Services (SSIS)
    • Develop and tune SQL code in multiple data platforms (SQL Server, Vertica, Oracle)
    • Manage code using Git code repository in Visual Studio Team Services (VSTS)
    • Develop and support enhancements to existing Cimarex Data Warehouse and Spotfire processes
    • Gather operational data requirements with team members and business stakeholders, assessing the validity and business-sense of data warehousing models for end-user consumption
    • Research, evaluate and test new software and technologies to meet growing data analysis needs
    • Assist power users across business units with creation of dashboards, data visualizations, and reports in Excel or Spotfire, to ensure maximum company value of our data architecture
    • Train and educate business users on existing and new data architecture solutions
    • Other tasks as assigned

    Skills & Experience:

    • 4-year degree in Management Information Systems, Computer Information Systems, Computer Science or related field highly preferred; Combination of education and experience may be considered in lieu of degree
    • Experience with relational databases (SQL) required
    • Knowledge of SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS) cubes
    • Experience in SQL Server Integration Services (SSIS) and other advanced business intelligence concepts related to data extraction, transformation, loading, scheduling, etc.
    • Familiarity with Kimball approach for data mart development, multi-dimensional database structures, e.g. Star Schemas preferred
    • Preferred experience with analytics and data visualization tools, such as Spotfire, Tableau, PowerBI
    • Some experience with R, Python, and/or Predictive Analytics a plus
    • Established proficiency with Microsoft Office Suite (Excel, Word, Power Point)
    • Strong interpersonal and problem solving skills with excellent verbal and written communications skills are required
    • Must be detail oriented with the ability to multi-task with attention to accuracy
    • Must be team player that possess the ability to adapt to a changing and fast paced work environment

    Cimarex Energy Co. is an equal opportunity employer. Applicants and employees are considered for positions and are evaluated without regard to mental or physical disability, race, color, religion, gender, national origin, age, genetic information, military or veteran status, sexual orientation, marital status or any other protected Federal, State/Province or Local status unrelated to the performance of the work involved. 

    Options:

    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed

    Need help finding the right job?

    We can recommend jobs specifically for you! Click here to get started.