Data & Analytics Tech Lead

Your Job

Join the IT Data & Analytics: Packaging & Cellulose Delivery Team supporting the Corrugated business. As a Tech Lead, you will design, build, optimize, and support enterprise-scale BI and analytics solutions across Microsoft BI platforms and cloud data ecosystems. You will act as a technical lead, influence the analytics roadmap, and deliver high-quality, scalable solutions that enable data-driven decision making.

What You Will Do

• Provide technical leadership, mentor BI developers/data engineers, and partner with business stakeholders to translate requirements into solutions.
• Design and develop SSAS multidimensional and tabular semantic models (OLAP cubes, Tabular models).
• Create and optimize MDX and DAX expressions for complex analytics.
• Build and maintain enterprise semantic layers for consistent reporting.
• Apply dimensional modeling (star/snowflake), define grain, surrogate key strategies, and SCD approaches.
• Design, implement, and maintain ETL/ELT pipelines using SSIS and cloud-native ETL tools.
• Integrate data from enterprise apps, data lakes, external sources, and APIs while ensuring data quality and auditability.
• Design and optimize cloud data solutions (preferred AWS: S3, Redshift, Glue, Lambda, Step Functions, Athena, DynamoDB).
• Develop and optimize Power BI semantic models, datasets, and reports; apply RLS and performance best practices.
• Tune performance across SSAS, Power BI, and Redshift (partitioning, indexing, aggregations, refresh strategies).

Who You Are (Basic Qualifications)

• Proven experience designing and delivering enterprise BI/analytics solutions.
• Handson experience with Microsoft BI stack: SSIS, SSAS (multidimensional and/or tabular), and Power BI.
• Advanced TSQL skills and experience optimizing queries.
• Strong understanding of data warehouse design, dimensional modeling, and star schemas.
• Experience building ETL pipelines with SSIS and/or cloud ETL tools.
• Working knowledge of cloud data platforms, preferably AWS (S3, Redshift, Glue, Lambda, Athena).
• Experience with data lakes, enterprise data stores, and external data source integration.
• Strong analytical thinking and independent problem-solving skills.

What Will Put You Ahead

• Prior technical lead experience for BI or data platform initiatives.
• Deep hands-on experience with AWS orchestration and automation (Glue, Step Functions, Lambda, DynamoDB, Redshift).
• Experience integrating on-premises and cloud data platforms.
• Familiarity with CI/CD, version control, and automated deployments for BI solutions.
• Domain exposure to manufacturing, supply chain, packaging, or logistics analytics.

At Koch companies, we are entrepreneurs. This means we openly challenge the status quo, find new ways to create value and get rewarded for our individual contributions. Any compensation range provided for a role is an estimate determined by available market data. The actual amount may be higher or lower than the range provided considering each candidate's knowledge, skills, abilities, and geographic location. If you have questions, please speak to your recruiter about the flexibility and detail of our compensation philosophy.

Hiring Philosophy

All Koch companies value diversity of thought, perspectives, aptitudes, experiences, and backgrounds. We are Military Ready and Second Chance employers. Learn more about our hiring philosophy here.

Who We Are

At Koch, employees are empowered to do what they do best to make life better. Learn how our business philosophy helps employees unleash their potential while creating value for themselves and the company.

Our Benefits

Our goal is for each employee, and their families, to live fulfilling and healthy lives. We provide essential resources and support to build and maintain physical, financial, and emotional strength - focusing on overall wellbeing so you can focus on what matters most. Our benefits plan includes - medical, dental, vision, flexible spending and health savings accounts, life insurance, ADD, disability, retirement, paid vacation/time off, educational assistance, and may also include infertility assistance, paid parental leave and adoption assistance. Specific eligibility criteria is set by the applicable Summary Plan Description, policy or guideline and benefits may vary by geographic region. If you have questions on what benefits apply to you, please speak to your recruiter.

Additionally, everyone has individual work and personal needs. We seek to enable the best work environment that helps you and the business work together to produce superior results.

Equal Opportunities

Equal Opportunity Employer, including disability and protected veteran status. Except where prohibited by state law, some offers of employment are conditioned upon successfully passing a drug test. This employer uses E-Verify. Please click here for additional information. (For Illinois E-Verify information click here, aqui, or tu).

#LI-BMW