Lead Consultant, Data Engineer + Power Automate

Dallas, IA - USA

Monthly Salary: Not Disclosed

Posted on: 3 hours ago

Vacancies: 1 Vacancy

Job Summary

Looking for a versatile Senior Data Engineer to develop end-to-end data solutions for automotive and fleet management platforms. Youll deliver Azure pipelines Snowflake data warehousing Python automation Power BI analytics and Power Automate workflows for our client

Key Responsibilities

Design and implement hybrid data pipelines across Azure Data Factory Synapse Databricks Snowflake and ADLS
Build Python automation scripts for data quality validation API orchestration and custom ETL processes
Develop Snowflake data models (star schemas materialized views streams/tasks) with Snowpark Python UDFs for complex transformations.
Create enterprise Power BI semantic models DAX measures and paginated reports with Fabric integration and row-level security.
Implement Power Automate flows for workflow automation across Service Bus Teams SharePoint and vendor APIs.
Deploy Python-based data quality frameworks and monitoring solutions integrated with Snowflake streams and Azure Purview.

Required Qualifications

Category	Details
Experience	6 years data engineering; 2 years Snowflake; 3 years Power BI/Automate; Python automation delivery
Core Technical Skills	Snowflake (Snowpark Streams Tasks) Python (pandas Airflow dbt) Azure Data Factory/Synapse Power BI Premium Power Automate & Databricks
Data Platforms	ADLS Gen2 Service Bus Topics/Queues PostgreSQL; real-time streaming (Kafka/Event Hubs equivalent)
Visualization & Automation	DAX Power Query Fabric Power Automate RPA/API connectors paginated reports

Preferred Skills

Snowflake certifications (SnowPro Core/Advanced) Azure Data Engineer Associate (DP-203)
Python ML libraries (scikit-learn) dbt for transformations Azure DevSecOps

Education