Lead Consultant, Data Engineer + Power Automate

American IT Systems • Dallas, TX

1d • Hybrid

About The Position

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

Requirements

• 6+ years data engineering
• 2+ years Snowflake
• 3+ years Power BI/Automate
• Python automation delivery
• Snowflake (Snowpark, Streams, Tasks)
• Python (pandas, Airflow, dbt)
• Azure Data Factory/Synapse
• Power BI Premium
• Power Automate
• Databricks
• ADLS Gen2
• Service Bus Topics/Queues
• PostgreSQL
• real-time streaming (Kafka/Event Hubs equivalent)
• DAX
• Power Query
• Fabric
• Power Automate RPA/API connectors
• paginated reports
• Bachelor's/Master's in Computer Science, Data Engineering, Statistics, or related field

Nice To Haves

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

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.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior