Snowflake & dbt Analytics Engineer – Power BI Dashboards

Jobtailor; Downers Grove (IL); On-site; USD 120,000 - 180,000; Full time

Job summary

Jobtailor in Downers Grove, IL is seeking a senior data engineer/analytics engineer to design scalable data pipelines, develop enterprise data models, and automate reporting. You will work with Snowflake, dbt, Python, and Power BI to deliver executive dashboards and actionable insights.

The role requires 5+ years of hands-on experience, strong SQL optimization, experience with ERP/Billing/CRM data, and familiarity with generative AI tools.

Qualifications

• 5+ years of hands-on experience in data engineering, analytics engineering, or business intelligence development roles.
• Expert-level proficiency with Snowflake, including advanced SQL optimization.
• Expert-level proficiency with dbt, including model development, testing, and deployment.
• Hands-on experience building semantic layers and interactive dashboards in Power BI.
• Advanced programming skills in Python for data manipulation.
• Experience developing code to extract, transform, and load data from ERP, Billing, CRM, and core business applications.
• Direct experience using generative AI utilities such as Snowflake Cortex, Claude, and Codex.
• Ability to write, optimize, and maintain complex dbt models and SQL transformations directly within Snowflake.
• Excellent analytical, problem-solving, and communication skills.
• Must have a car
• Valid driver's license and proof of vehicle insurance required
• Legally authorized to work in the US without sponsorship
• Must demonstrate a "can-do" attitude
• Background check required as part of Sentinel's employment process

Responsibilities

• Design scalable data pipelines
• Develop enterprise data models
• Automate reporting processes
• Deliver executive dashboards providing meaningful business insights
• Solve complex data challenges from concept through delivery
• Use Snowflake, dbt, Python, Power BI, Snowflake Cortex, Claude, and OpenAI Codex to develop and optimize data solutions
• Write, optimize, and maintain complex dbt models and SQL transformations within Snowflake
• Extract, transform, and load data from ERP, Billing, CRM, and core business applications
• Drive strategic business decisions through modern data solutions

Skills

Snowflake Expertise

Dbt Model Development

Python Programming

Power BI Dashboard Development

Generative AI Utilities Experience

SQL Optimization

Tools

Snowflake

Dbt

Python

Power BI

Snowflake Cortex

Claude

OpenAI Codex

Job description

Jobtailor in Downers Grove, IL is seeking a senior data engineer/analytics engineer to design scalable data pipelines, develop enterprise data models, and automate reporting. You will work with Snowflake, dbt, Python, and Power BI to deliver executive dashboards and actionable insights.

The role requires 5+ years of hands-on experience, strong SQL optimization, experience with ERP/Billing/CRM data, and familiarity with generative AI tools.