Haystack logo
Haystack Verified
Software, Developer Tools, Analytics

Senior Data Engineer

Chicago, Illinois, United StatesHybridFull TimeSenior$104,800–$144,100 /yrPosted 2 months ago

Is this role right for you?

Upload your resume and get a skill-by-skill breakdown — see exactly where you match, where you're close, and what to highlight. Not a mystery percentage.

Get a tailored resume highlighting what this role needs.

Role summary

A Fortune 200 leader in energy transformation is seeking a Senior Data Engineer to build high-performance data pipelines and enterprise-scale analytics solutions. This role involves designing, building, and optimizing ETL/ELT processes and data warehouses using Azure, Databricks, Spark, Azure Data Factory, and Synapse. You will clean, transform, and prepare complex datasets for advanced analytics, and collaborate with IT and business partners on security and data monitoring. The position also requires leading automation efforts using scripting tools like PowerShell or Ansible. A degree in Computer Science or a related field is preferred, along with strong communication skills.

Sr Data Engineer

We're working with a Fortune 200 leader in the energy transformation space on this exciting opportunity.

Help power a cleaner future by building high-performance data pipelines and enterprise-scale analytics solutions. You will leverage a cutting-edge stack including Azure, Databricks, and Spark to drive intelligence for over 10 million customers while leading the charge in modern utility analytics.

The Role

• Design, build, and optimize high-scale ETL/ELT processes and data warehouse solutions supporting diverse energy utility business units.

• Architect and implement robust data pipelines using Databricks, Azure Data Factory (ADF), Synapse, and Spark.

• Clean, preprocess, and transform complex datasets into readable formats for advanced analytics, utilizing optimization techniques for Parquet, SCD1/2, and GIS data.

• Collaborate with IT and business partners to define security policies, access controls, and data monitoring settings for mission-critical systems.

• Lead the automation of common operational tasks and reporting using PowerShell, Ansible, and other advanced scripting tools.

What You'll Need

• 4-7 years of professional experience in Data Engineering, Data Warehouse design, and ETL development.

• Hands-on mastery of the Azure ecosystem, including Databricks (Warehouse/Lakehouse), Azure Data Factory, Synapse, and Cosmos DB.

• Strong technical proficiency in Big Data technologies, specifically Spark, and experience with data integration tools like ODI, IDMC, or Oracle Golden Gate.

• Proven ability to automate workflows using PowerShell or Ansible and a deep understanding of the full SDLC and enterprise data standards.

• A degree in Computer Science or a related field, with the communication skills to disseminate complex technical information to non-technical stakeholders.

What's On Offer

• Competitive base salary ($104,800 - $144,100) plus a 15% target annual bonus.

• Comprehensive benefits package including medical, dental, vision, and a strong 401(k) match with annual company contributions.

• Flexible hybrid work environment and generous PTO including floating holidays and parental/bonding leave.

• Exceptional growth opportunities within a purpose-driven Fortune 200 organization committed to innovation and community impact.

Apply via Haystack today!

Ready to apply?
You'll be redirected to Haystack's application page.

Similar roles