Haystack logo
Haystack Verified
Software, Developer Tools, Analytics

Data Engineer

Chicago, Illinois, United StatesHybridFull Time$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 energy transformation leader seeks a Sr. Data Engineer to build high-performance data pipelines and enterprise-scale analytics solutions. Leveraging Azure, Databricks, and Spark, you will drive intelligence for over 10 million customers. Responsibilities include designing, building, and optimizing ETL/ELT processes and data warehouses, architecting data pipelines, cleaning and transforming complex datasets, and collaborating on security policies. The role also involves leading automation efforts using scripting tools like PowerShell and Ansible. A minimum of 4-7 years of experience in Data Engineering, Data Warehouse design, and ETL development is required, along with hands-on Azure ecosystem mastery.

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