Sr. Data Engineer – Power Automate RPA

BuzzClan LLC • Dallas, TX

1d

About The Position

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 a secondary skill. The role develops workflow automation solutions, integrates enterprise applications, and supports data pipelines, Snowflake data warehousing, Python automation, and Power BI analytics for automotive and fleet management platforms. The position is a contract role located in Dallas, TX, with a virtual interview process.

Requirements

• At least 6 years of data engineering experience.
• At least 2 years of Snowflake experience.
• At least 3 years of Power BI/Power Automate experience.
• Strong, hands-on Power Automate RPA development and workflow automation experience.
• Programming experience in C# or Python is mandatory.
• Experience with Python, pandas, Airflow, dbt, Snowpark, Snowflake Streams/Tasks, Azure Data Factory, Synapse, Databricks, and ADLS Gen2.
• Experience with 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 Haves

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

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.

What This Job Offers

• Career Level: Senior