Overview
On Site
Depends on Experience
Contract - Independent
Contract - W2
Skills
Data Engineering
Snowflake
Power BI
SQL
Job Details
Data Engineer (Snowflake & Power BI)
Location: Oak Brook, IL
Duration: 6 Months Contract to Hire
Description:
Snowflake Expertise
Experience with at least one major cloud platform (AWS, Azure, Google Cloud Platform)
Python scripting for automation and data manipulation
Collaboration & Communication
Location: Oak Brook, IL
Duration: 6 Months Contract to Hire
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 the 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.
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
- Proven experience building scalable pipelines using tools like dbt, Talend, Informatica, or Airflow
- Strong SQL skills for data transformation and analysis
- Experience connecting Snowflake to Power BI
- Building optimized datasets, dataflows, and semantic models
- Proficiency in DAX and Power BI performance tuning
Experience with at least one major cloud platform (AWS, Azure, Google Cloud Platform)
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
- 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.
- 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 Google Cloud Platform).
- 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.
- 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.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.