Job Description

Job role : Data Engineer (Snowflake & Power BI)

Duration : 6 month CTH

Location : onsite in Oakbrook, IL

Client is a leading distributor of automotive parts, which means data engineering efforts directly support inventory management, supply chain optimization, sales analytics, and customer insights.

Must-Haves (Technical & Functional):

Snowflake Expertise

• Hands-on experience with Snowflake data modeling (star/snowflake schemas)
• Performance tuning: clustering, partitioning, query optimization
• Security and governance: access controls, data integrity
• Familiarity with Snowpipe, Streams, Tasks is a plus

ETL/ELT Development

• Proven experience building scalable pipelines using tools like dbt, Talend, Informatica, or Airflow
• Strong SQL skills for data transformation and analysis

Power BI Integration

• Experience connecting Snowflake to Power BI
• Building optimized datasets, dataflows, and semantic models
• Proficiency in DAX and Power BI performance tuning

Cloud & Scripting

• Experience with at least one major cloud platform (AWS, Azure, GCP)
• Python scripting for automation and data manipulation

Collaboration & Communication

• Ability to translate business needs into technical solutions
• Experience working with analysts and BI developers to support reporting and dashboarding

Job Description:

We are seeking a highly skilled Data Engineer with deep expertise in Snowflake and strong experience with Power BI to join our growing data team at client, a leading automotive parts company. In this role, you will be primarily responsible for architecting, developing, and optimizing our Snowflake data warehouse environment, while also enabling advanced analytics and reporting through seamless integration with Power BI to support our automotive parts business.

Responsibilities:

• Design, develop, and maintain scalable ETL/ELT pipelines to ingest, transform, and load data from diverse sources into Snowflake.
• Architect and implement efficient data models in Snowflake, including the creation and maintenance of fact and dimension tables (star/snowflake schema) to support business intelligence and analytics needs specific to the automotive parts industry.
• Optimize Snowflake performance through clustering, partitioning, query tuning, and cost management strategies.
• Ensure data quality, integrity, and security within the Snowflake environment, including the implementation of access controls and data governance best practices.
• Collaborate with business analysts and Power BI developers to understand reporting requirements and ensure Snowflake data models are optimized for Power BI dashboards and self-service analytics.
• Develop and maintain Power BI datasets, dataflows, and semantic models that leverage Snowflake as the primary data source.
• Automate data workflows, implement monitoring, and troubleshoot data pipeline and warehouse issues to ensure high reliability and scalability.
• Document Snowflake data models, ETL processes, and integration best practices with Power BI.
• Stay current with Snowflake and Power BI feature releases, and proactively recommend improvements to our data architecture and analytics capabilities.

Requirements:

• Bachelor's degree in Computer Science, Engineering, or a related field (or equivalent experience).
• 2+ years of experience as a Data Engineer or in a similar role, with a strong focus on data warehousing.
• Proven, hands-on experience with Snowflake, including data modeling, performance optimization, security, and administration.
• Advanced proficiency in SQL and experience with ETL/ELT tools (e.g., dbt, Talend, Informatica, Apache Airflow).
• Experience integrating Snowflake with Power BI, including building efficient datasets, dataflows, and DAX calculations.
• Experience with cloud platforms (AWS, Azure, or GCP).
• Familiarity with scripting languages (Python preferred).
• Strong problem-solving skills and attention to detail.
• Excellent communication and collaboration skills, especially in translating business requirements into technical solutions.

Preferred:

• Experience with Snowflake features such as Snowpipe, Streams, Tasks, and Data Sharing.
• Experience with Power BI administration, governance, and best practices for large-scale deployments.
• Knowledge of CI/CD and DevOps practices for data engineering and BI.
• Experience with other data warehouse technologies (e.g., Redshift, BigQuery).
• Experience in the automotive parts or related industry is a plus.

Job Tags

Similar Jobs