Data Engineer

Job Description This hands-on consulting role supports a fast-paced energy management team focused on data engineering, data pipelines, data warehousing, and ETRM systems. The ideal candidate will have expert-level experience with Microsoft SQL Server and SSIS, knowledge of energy trading processes, and strong skills in Python, data modeling, and data warehousing best practices.

Required Qualifications & Experience

•Expert-level experience with Microsoft SQL Server, including database design, query optimization, performance tuning, stored procedures, and ETL development using SQL Server Integration Services (SSIS).

•Strong experience developing and maintaining reporting solutions using SQL Server Reporting Services (SSRS) or comparable enterprise reporting platforms.

•Hands-on experience working with Oracle databases, including data extraction, integration, performance analysis, and SQL development.

•Proficiency in Python development, with a focus on data engineering, ETL processes, API integrations, automation, and data transformation workflows.

•Strong understanding of Python data analysis and processing libraries, including Pandas, NumPy, and related frameworks used for large-scale data manipulation and analytics.

•Experience designing, building, and supporting data pipelines that integrate data from multiple internal and external systems.

•Working knowledge of business intelligence and data visualization tools such as Power BI and/or Tableau, including dashboard development, reporting, and data storytelling.

•Familiarity with the Microsoft Power Platform, including Power Apps and Power Automate, to support workflow automation, business process improvement, and low-code application development.

•Knowledge of data warehousing concepts, dimensional modeling, and best practices for data governance, data quality, and metadata management.

•Experience working with time-series data, market data, pricing models, forecasting models, or financial and commodity trading datasets preferred.

•Ability to assess, cleanse, validate, and integrate large datasets from diverse sources

•Experience supporting Energy Trading and Risk Management (ETRM) platforms and an understanding of energy market operations, trading processes, scheduling, settlements, or risk management is highly desirable.

•Excellent verbal and written communication skills, with full professional proficiency in English and the ability to communicate complex technical concepts to both technical and non-technical stakeholders.

•Strong analytical, troubleshooting, and problem-solving skills with the ability to identify root causes and implement sustainable solutions.

•Ability to work effectively in an agile environment, adapt to changing business requirements, and support multiple initiatives simultaneously.

•Experience creating, maintaining, and improving technical documentation, data dictionaries, process documentation, and operational procedures.

Education and Minimum Experience

•Bachelor’s degree in Computer Science, Engineering, MIS or related discipline/experience