

Ampstek
Power BI with Automation Consultant Only USC and GC
β - Featured Role | Apply direct with Data Freelance Hub
This role is for a Power BI with Automation Consultant on a contract basis, located remotely in Dallas. The position requires 3+ years of Power BI experience, proficiency in DAX and Power Query, and familiarity with automation tools like Power Automate.
π - Country
United States
π± - Currency
$ USD
-
π° - Day rate
Unknown
-
ποΈ - Date
October 17, 2025
π - Duration
Unknown
-
ποΈ - Location
Remote
-
π - Contract
Unknown
-
π - Security
Unknown
-
π - Location detailed
Dallas, TX
-
π§ - Skills detailed
#Azure Data Factory #Process Automation #Power Automate #Databases #Security #Monitoring #Data Modeling #Automation #Azure #Datasets #SQL (Structured Query Language) #Computer Science #VBA (Visual Basic for Applications) #Data Quality #Visualization #R #BI (Business Intelligence) #SharePoint #DAX #Python #Data Governance #ADF (Azure Data Factory) #Scripting #"ETL (Extract #Transform #Load)" #Microsoft Power BI
Role description
Title-:Power BI with Automation Consultant
Location: Dallas Remote
Job Type: Contract
JD-:
Key Responsibilities:
β’ Design, develop, and maintain interactive Power BI dashboards and reports.
β’ Integrate and transform data from multiple sources (SQL, Excel, SharePoint, APIs, etc.) into Power BI datasets.
β’ Develop automated data refresh, alerting, and reporting workflows using Power Automate, Azure Data Factory, or similar tools.
β’ Implement data quality checks, monitoring, and exception handling in automated pipelines.
β’ Collaborate with business stakeholders to understand reporting requirements and deliver analytical solutions.
β’ Optimize Power BI performance through data modeling and DAX calculations.
β’ Maintain data governance, access control, and security best practices in Power BI Service.
β’ Support process automation initiatives leveraging Power Apps, Power Automate, or RPA tools (UiPath, Automation Anywhere, etc.).
β’ Troubleshoot data and automation issues and ensure continuous delivery of accurate insights.
Required Skills and Qualifications:
β’ Bachelorβs degree in Computer Science, Information Systems, Data Analytics, or a related field.
β’ 3+ years of experience in developing Power BI dashboards and reports.
β’ Strong proficiency in DAX, Power Query (M language), and data modeling.
β’ Experience with Power Automate, Azure Data Factory, or other automation tools.
β’ Hands-on experience with SQL databases, data warehousing, and ETL processes.
β’ Familiarity with Python, R, or VBA scripting for automation tasks.
β’ Understanding of data visualization best practices and business intelligence concepts.
β’ Strong analytical, problem-solving, and communication skills.
Title-:Power BI with Automation Consultant
Location: Dallas Remote
Job Type: Contract
JD-:
Key Responsibilities:
β’ Design, develop, and maintain interactive Power BI dashboards and reports.
β’ Integrate and transform data from multiple sources (SQL, Excel, SharePoint, APIs, etc.) into Power BI datasets.
β’ Develop automated data refresh, alerting, and reporting workflows using Power Automate, Azure Data Factory, or similar tools.
β’ Implement data quality checks, monitoring, and exception handling in automated pipelines.
β’ Collaborate with business stakeholders to understand reporting requirements and deliver analytical solutions.
β’ Optimize Power BI performance through data modeling and DAX calculations.
β’ Maintain data governance, access control, and security best practices in Power BI Service.
β’ Support process automation initiatives leveraging Power Apps, Power Automate, or RPA tools (UiPath, Automation Anywhere, etc.).
β’ Troubleshoot data and automation issues and ensure continuous delivery of accurate insights.
Required Skills and Qualifications:
β’ Bachelorβs degree in Computer Science, Information Systems, Data Analytics, or a related field.
β’ 3+ years of experience in developing Power BI dashboards and reports.
β’ Strong proficiency in DAX, Power Query (M language), and data modeling.
β’ Experience with Power Automate, Azure Data Factory, or other automation tools.
β’ Hands-on experience with SQL databases, data warehousing, and ETL processes.
β’ Familiarity with Python, R, or VBA scripting for automation tasks.
β’ Understanding of data visualization best practices and business intelligence concepts.
β’ Strong analytical, problem-solving, and communication skills.