Senior BI Engineer — AI-Driven Data & Analytics Lead

Jobtailor

Chicago (IL)

On-site

USD 120,000 - 160,000

Full time

36 hours ago

Be an early applicant

Get more replies from employers

Send a job-specific resume in minutes.

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