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 esti...