Senior Power BI & Data Automation Architect

ERM; Austin (TX); On-site; USD 120,000 - 150,000; Full time

Job summary

ERM seeks a Senior Power BI & Data Automation Developer to lead enterprise BI, analytics, and automation initiatives across environmental and infrastructure projects. You will design scalable reporting platforms, automate data workflows, and deliver high-quality data products for clients and internal teams.

You will mentor colleagues, partner with GIS and IT teams, and drive best practices in data governance, model design, and performance optimization within a fast-paced consultancy.

Qualifications

• Bachelor's degree in a relevant field or equivalent professional experience.
• 5+ years delivering BI, data engineering, analytics, or automation solutions.
• Advanced expertise in Power BI: data modeling, DAX, Power Query, reports, performance optimization.
• Strong SQL: complex queries, design, troubleshooting, tuning.
• Proficiency in Python for data transformation and automation.
• Experience with ETL/ELT pipelines and automated workflows.
• Experience building Power Apps and Power Automate solutions.
• Understanding of data quality, governance, and relational databases.
• Strong communication and cross-functional collaboration.

Responsibilities

• Design, develop, and maintain Power BI dashboards, reports, applications, and reusable data products.
• Own end-to-end BI development from data ingestion and modeling through dashboard delivery and ongoing support.
• Build relational and dimensional data models for scalable analytics.
• Develop, review, and optimize SQL queries, stored procedures, views, and reporting structures.
• Create Python-based data processing, integration, validation, and automation.
• Design and support ETL/ELT pipelines, automated refresh processes, and data integration workflows.
• Develop Power Apps and Power Automate solutions that streamline business processes and improve productivity.
• Integrate information from enterprise systems, databases, APIs, SharePoint, flat files, and geospatial platforms.
• Perform data validation, quality assurance, reconciliation, and troubleshooting activities.
• Document system architectures, business rules, technical designs, and support procedures.
• Collaborate with project managers, scientists, GIS specialists, and client stakeholders to translate business needs into technical solutions.
• Mentor team members, promote development standards, and contribute to a culture of continuous improvement and innovation.

Skills

Power BI

SQL

Python

ETL/ELT

Power Apps

Power Automate

Data modeling

DAX

Power Query

Data governance

Education

Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, GIS, Geography, or related field

Tools

Microsoft Fabric

Azure Data Factory

Azure SQL

Dataverse

Data lakes

Notebooks

CI/CD practices

Job description

ERM seeks a Senior Power BI & Data Automation Developer to lead enterprise BI, analytics, and automation initiatives across environmental and infrastructure projects. You will design scalable reporting platforms, automate data workflows, and deliver high-quality data products for clients and internal teams.

You will mentor colleagues, partner with GIS and IT teams, and drive best practices in data governance, model design, and performance optimization within a fast-paced consultancy.