Data Engineer

WARWICK INVESTMENT GROUP LLC • Oklahoma City, OK

20d • Onsite

About The Position

The mission of the Data Analytics Engineer at Warwick Energy is to bridge the gap between data engineering and business intelligence (BI) teams seamlessly. In this role, you will convert raw data into well-structured, accessible datasets and design scalable data models that enable meaningful analytics and reporting. A critical part of this role involves applying data engineering principles to build and maintain trusted, high-quality data objects within the data warehouse. By ensuring the accuracy, consistency, and reliability of these data assets, you will create a strong foundation for scalable analytics and BI solutions. Your work will enable the organization to leverage a single source of truth for decision-making, fostering confidence in data-driven insights. As a detail-oriented professional, you will ensure high levels of accuracy and thoroughness in data preparation and documentation. Your problem-solving skills will be essential as you apply analytical thinking to tackle complex challenges in data workflows and in shaping the data. Collaboration is key in this role, as you will communicate effectively across teams and foster a cooperative working environment. An eagerness for continuous improvement will drive you to learn and implement efficient data solutions and creating robust data products that power BI applications, we encourage you to join our team.

Requirements

• At least 5 years of hands-on experience in various aspects of the oil and gas industry, understanding its unique data challenges.
• Proficient in writing complex SQL queries and designing data models that integrate diverse datasets.
• Experience with CTEs, advanced formulas, and windowing functions for sophisticated data transformations.
• Capable of producing clear and detailed documentation for data models, workflows, ELT processes, and analytics solutions to support team collaboration.
• Deep knowledge of data modeling concepts and best practices, including creating semantic layers for BI tools.
• At least 5 years of experience in building data models for BI tools like Power BI and Spotfire, understanding data ingestion and transformation for optimal data display.
• Proven ability to work effectively with functional business teams, data engineering teams, and analytics teams to align data solutions with business needs.
• Proven ability to design and implement scalable workflows and optimize data queries for performance and efficiency.
• Familiar with using version control systems like Git and Azure DevOps to manage and track changes in data models and scripts.

Nice To Haves

• Proficient in using Snowflake and Microsoft Fabric for data warehousing and management.
• Knowledgeable about cloud platforms like Snowflake, Azure, AWS, and GCP for data storage, processing, and analytics.
• Competent in using Python for data manipulation, analysis, and automation tasks.
• Well-versed in data governance principles and compliance requirements, ensuring data quality and security.

Responsibilities

• Bridge data engineering and BI teams to convert raw data into structured, actionable datasets.
• Design scalable data models and semantic layers to optimize BI tool analysis.
• Collaborate with data engineers to design and maintain robust data models for BI projects.
• Develop and maintain version-controlled analytics workflows using tools like DBT.
• Ensure analytical outputs meet business objectives and are accessible to all users.
• Create clear documentation for data models, workflows, and analytics solutions for both technical and non-technical stakeholders.
• Work with cross-functional teams to support data-driven decision-making and promote best practices in data analytics.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed