Senior BI Engineer
Job in
Chicago, Cook County, Illinois, 60290, USA
Listed on 2026-09-05
Listing for:
Jobtailor
Full Time
position Listed on 2026-09-05
Job specializations:
-
IT/Tech
Data Engineering, Data Warehousing, Business Intelligence
Job Description & How to Apply Below
- 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
- 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, Big Query, 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 – Micro Strategy, 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)
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
- SQL
- Python
- ETL
- ELT
- Data Warehousing
- Dimensional Modeling
- Data Mart Concepts
- AI Tools
- Data Transformation
- Pipeline Automation
- Business Acumen
- Stakeholder Engagement
- Cross-Functional Collaboration
- Data Analytics
- Reporting Solutions
- Data Solutions
- Technical Initiatives
- Orchestration Tools
- Snowflake
- Databricks
- Big Query
- AWS Redshift
- Micro Strategy
- Tableau
- Looker
- PowerBI
- Claude
- AWS Bedrock
Position Requirements
10+ Years
work experience
To View & Apply for jobs on this site that accept applications from your location or country, tap the button below to make a Search.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
Search for further Jobs Here:
×