Kimball International is looking for a Sr Data Engineer to transform transactional data into multi-dimensional Semantic modeling to provide business insights, integrate sales, finance, and supply chain data, and explore new technology platforms.
Requirements
- Extremely proficient in SQL – Databases, tables, views, Store Procedures, UDFs, CTEs, Linked servers, etc.
- Extremely proficient in DAX language both to query and to develop new measures / columns
- Sound understanding of BI semantic layer, data engineering, and database concepts
- Expertise in data warehouse tools / databases / modern BI solutions
- Ability to architect, develop and deploy enterprise grade data models using platforms like SSAS, and Power BI
- Ability to architect, and develop data engineering solutions to feed semantic models and to support operational reporting using tools like SQL, Power BI, Snowflake, etc.
- Leverage cloud technologies, including Azure Data Lake Storage, One Lake, and MS FABRIC, to build scalable and reliable data solutions
Responsibilities
- Design, develop, document, and implement data-driven solutions using enterprise-supported analytical platforms and tool sets
- Create or enhance enterprise grade analytical data products (semantic data models) using advanced techniques in D&A platforms (SSAS and Power Bi cloud)
- Develop or modify data warehouses and data marts in SQL and MS Fabric using best practices of data engineering
- Collaborate with business users and reporting analysts to develop and execute test plans
- Take ownership of existing data warehouse databases, data marts, and analytical models
- Monitor processes of data collection, storage, and analysis
- Monitor the ETL jobs for their failures / load time and continuously optimize them
Other
- Partner with multiple business functional leaders in the Sales, Finance, and Supply chain areas, understand their business challenges and co-create analytical solutions
- Work in a team environment
- Being able to lead the project, or be a team member in a project
- Excellent written and verbal communication across all organizational levels, including customers and suppliers
- Proven ability to develop scalable, high-performing data pipelines that support AI, ML, and BI applications.
