Sr. Data Engineer – Power Automate RPA

Job Title: Sr. Data Engineer – Power Automate RPA, Snowflake, Power BI & Python (4618)

Location: Dallas, TX

Contract

Interview Process: Virtual

Job Summary

We are seeking a Senior Data Engineer with strong hands-on experience in Power Automate RPA development as the primary skill and Data Engineering as the secondary skill. The candidate will develop workflow automation solutions, integrate enterprise applications, and support data pipelines, Snowflake data warehousing, Python automation, and Power BI analytics for automotive and fleet management platforms.

Responsibilities

Design, develop, test, and maintain Power Automate RPA workflows for business process automation.; Build and troubleshoot automated workflows using Power Platform capabilities, API connectors, Teams, SharePoint, Azure Service Bus, and vendor APIs.; Develop Python automation scripts for data quality validation, API orchestration, and custom ETL processes.; Design and maintain data pipelines across Azure Data Factory, Synapse, Databricks, Snowflake, and ADLS.; Develop Snowflake data models, star schemas, materialized views, Streams, Tasks, and Snowpark Python UDFs.; Build Power BI semantic models, DAX measures, Power Query transformations, paginated reports, and row-level security, with Power BI Premium and Fabric integration.; Implement data quality frameworks and monitoring using Snowflake Streams and Azure Purview.; Support integrations involving ADLS Gen2, PostgreSQL, Service Bus Topics/Queues, Kafka, Azure Event Hubs, or equivalent streaming technologies.

Requirements

6+ years of data engineering experience.; 2+ years of Snowflake experience.; 3+ years of Power BI/Power Automate experience.; Strong, hands-on Power Automate RPA development and workflow automation experience.; Mandatory programming experience in C# or Python .; Experience with Python, pandas, Airflow, dbt, Snowpark, Snowflake Streams/Tasks, Azure Data Factory, Synapse, Databricks, and ADLS Gen2.; Power BI Premium, DAX, Power Query, Fabric, paginated reports, and Power Automate API connectors.; Experience with enterprise application integrations, data quality, ETL, and monitoring.; Bachelor's or Master's degree in Computer Science, Data Engineering, Statistics, or a related field.

Nice to have

Snowflake SnowPro Core/Advanced or Azure Data Engineer Associate (DP-203) certification.; Experience with scikit-learn, dbt transformations, and Azure DevSecOps.