Senior BI Engineer

Jobtailor; Chicago (IL); On-site; USD 120,000 - 160,000; Full time

Job summary

Jobtailor is seeking a data/BI professional to partner with cross-functional teams to deliver actionable reporting solutions. You will design and implement ETL/ELT pipelines, architect data warehouses, and enhance data marts using Snowflake with Airflow orchestration.

You will build dashboards in MicroStrategy/Tableau/Looker/PowerBI and explore AI use cases across units. The role demands expert SQL, Python, and experience with modern cloud data warehouses, along with strong business acumen and

Qualifications

• Eligible to work in the United States; visa sponsorship or sponsorship takeover is not available.
• Expert-level SQL and database skills.
• Strong experience with relational databases and cloud data warehouses (Snowflake, Databricks, BigQuery, or AWS Redshift).
• Strong grasp of data warehousing and data mart concepts, including dimensional modeling (star schema, slowly changing dimensions, etc.).
• 4+ years designing and implementing ETL/ELT pipelines.
• Hands-on experience with Astronomer (Apache Airflow) or similar orchestration tools.
• 4+ years working with enterprise BI and visualization tools – MicroStrategy, Tableau, Looker, PowerBI, or equivalent.
• Experience leveraging AI tools in day-to-day work, including coding assistants, agents, and identifying new use cases.
• Strong business acumen and ability to translate business needs into technical data solutions.
• Proven experience working directly with senior management and cross-functional stakeholders.
• Proficiency in Python for data transformation, pipeline automation, and analytics (nice to have).

Responsibilities

• Partner with stakeholders across PnLs, Marketing, Operations, Accounting, and Finance to understand data needs and deliver actionable reporting solutions
• Lead technical initiatives end-to-end from solution architecture through execution
• Design, implement, and maintain complex, multi-layered SQL and Python processes for reporting and analytics
• Architect and enhance ETL/ELT pipelines using Astronomer Airflow and other modern orchestration tools
• Lead projects from scoping and design through delivery and ongoing support
• Build, optimize, and support data marts and data warehouse solutions using Snowflake
• Develop and maintain dashboards and reports in Strategy (MSTR) and/or comparable BI tools
• Identify and implement AI use cases across business units using Enova’s AI technology stack, including Claude, AWS Bedrock, and Gemini
• Advise on best practices, innovative designs, and emerging BI technologies

Skills

SQL

Python

ETL/ELT

Data Warehousing

Snowflake

Astronomer Airflow

BI Tools

AI Tools

Data Transformation

Pipeline Automation

Tools

Snowflake

Databricks

BigQuery

AWS Redshift

MicroStrategy

Tableau

Looker

PowerBI

Claude

AWS Bedrock

Astronomer Airflow

Job description

• Partner with stakeholders across PnLs, Marketing, Operations, Accounting, and Finance to understand data needs and deliver actionable reporting solutions
• Lead technical initiatives end-to-end from solution architecture through execution
• Design, implement, and maintain complex, multi-layered SQL and Python processes for reporting and analytics
• Architect and enhance ETL/ELT pipelines using Astronomer Airflow and other modern orchestration tools
• Lead projects from scoping and design through delivery and ongoing support
• Build, optimize, and support data marts and data warehouse solutions using Snowflake
• Develop and maintain dashboards and reports in Strategy (MSTR) and/or comparable BI tools
• Identify and implement AI use cases across business units using Enova’s AI technology stack, including Claude, AWS Bedrock, and Gemini
• Advise on best practices, innovative designs, and emerging BI technologies

Requirements

• Eligible to work in the United States; visa sponsorship or sponsorship takeover is not available
• Expert-level SQL and database skills
• Strong experience with relational databases and cloud data warehouses (Snowflake, Databricks, BigQuery, or AWS Redshift)
• Strong grasp of data warehousing and data mart concepts, including dimensional modeling (star schema, slowly changing dimensions, etc.)
• 4+ years designing and implementing ETL/ELT pipelines
• Hands-on experience with Astronomer (Apache Airflow) or similar orchestration tools
• 4+ years working with enterprise BI and visualization tools – MicroStrategy, Tableau, Looker, PowerBI, or equivalent
• Experience leveraging AI tools in day-to-day work, including coding assistants, agents, and identifying new use cases
• Strong business acumen and ability to translate business needs into technical data solutions
• Proven experience working directly with senior management and cross-functional stakeholders
• Proficiency in Python for data transformation, pipeline automation, and analytics (nice to have)

Core Competencies

Demonstrates expertise in SQL and database management, with a strong focus on designing and implementing ETL/ELT pipelines and data warehousing solutions. Proficient in leveraging AI technologies and BI tools to deliver actionable insights and reporting solutions across business units.

Highest-signal resume keywords

• Expert-Level SQL
• ETL/ELT Pipeline Design
• Snowflake Data Warehouse
• Astronomer Airflow
• Business Intelligence Tools

ATS Optimization Keywords

Hard Skills

• SQL
• Python
• ETL
• ELT
• Data Warehousing
• Dimensional Modeling
• Data Mart Concepts
• AI Tools
• Data Transformation
• Pipeline Automation

Soft Skills

• Business Acumen
• Stakeholder Engagement
• Cross-Functional Collaboration

Industry Keywords

• Data Analytics
• Reporting Solutions
• Data Solutions
• Technical Initiatives
• Orchestration Tools

Tools & Technologies

• Snowflake
• Databricks
• BigQuery
• AWS Redshift
• MicroStrategy
• Tableau
• Looker
• PowerBI
• Claude
• AWS Bedrock