Principal Consultant

ERM; Austin (TX); Sur place; USD 120 000 - 150 000; Plein temps

Résumé du poste

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.

Responsabilités

• 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.

Connaissances

Power BI

SQL

Python

ETL/ELT

Power Apps

Power Automate

Data modeling

DAX

Power Query

Data governance

Formation

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

Outils

Microsoft Fabric

Azure Data Factory

Azure SQL

Dataverse

Data lakes

Notebooks

CI/CD practices

Description du poste

Senior Power BI & Data Automation Developer

Build the Data Solutions That Drive Smarter Decisions

Are you a senior technology professional who enjoys transforming complex data into powerful business insights? At ERM, you'll have the opportunity to lead the development of innovative analytics, automation, and business intelligence solutions that support some of the world's most impactful environmental, infrastructure, and sustainability projects. If you thrive at the intersection of data engineering, analytics, and problem-solving, this is your chance to make a measurable impact while shaping the future of data-driven decision making.

Why This Role Matters?

Data is at the core of how organizations make informed decisions, improve operational efficiency, and deliver value to clients. As a Senior Power BI & Data Automation Developer, you will play a critical role in designing scalable reporting platforms, automating business processes, and creating high-quality data products that empower teams across ERM and our client organizations.

What Your Impact Is:

• Develop enterprise-grade business intelligence solutions that transform complex datasets into actionable insights.
• Drive automation initiatives that reduce manual effort and improve operational efficiency.
• Design scalable data architectures that support reporting, analytics, and decision-making at scale.
• Integrate diverse data sources, including SQL databases, APIs, SharePoint, and geospatial platforms, into unified solutions.
• Enhance data quality, governance, and system reliability across critical business applications.
• Serve as a technical leader, mentoring colleagues and championing best practices in analytics, development, and automation.

What You'll Bring:

Required

• Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, GIS, Geography, or a related discipline, or equivalent professional experience.
• 5+ years of experience delivering business intelligence, data engineering, analytics, or automation solutions.
• Advanced expertise in Power BI, including data modeling, DAX, Power Query, report development, and performance optimization.
• Strong SQL experience, including complex query development, database design, troubleshooting, and performance tuning.
• Proficiency in Python for data transformation, automation, systems integration, and analytics.
• Hands-on experience developing and supporting ETL/ELT pipelines and automated data workflows.
• Experience building solutions using Power Apps and Power Automate.
• Understanding of relational databases, data quality controls, and data governance principles.
• Strong communication skills and the ability to collaborate effectively with both technical and non-technical stakeholders.
• Proven ability to manage multiple priorities and deliver high-quality solutions in a fast-paced environment.

Preferred

• Microsoft certifications in Power BI, Fabric, Azure, Power Platform, or Data Engineering.
• Experience with Microsoft Fabric, Azure Data Factory, Azure SQL, Dataverse, data lakes, notebooks, and CI/CD practices.
• Expertise in dimensional modeling, semantic-layer design, and enterprise BI governance.
• Experience integrating Power BI with GIS platforms, spatial services, or Esri technologies.
• Background supporting environmental, engineering, infrastructure, energy, utilities, or consulting projects.
• Experience with APIs, JSON, authentication frameworks, and system integrations.
• Demonstrated experience mentoring developers, conducting code reviews, or leading technical initiatives.
• Knowledge of data security, privacy, metadata management, and production support environments.

Key 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 and optimize relational and dimensional data models that enable scalable, high-performing analytics.
• Develop, review, and troubleshoot SQL queries, stored procedures, views, and reporting structures.
• Create and maintain Python-based solutions for 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.

Who We Are:

As the largest global pure play sustainability consultancy, we partner with the world's leading organizations, creating innovative solutions to sustainability challenges and unlocking commercial opportunities that meet the needs of today while preserving opportunity for future generations.

At ERM we know that creating a diverse, equitable and inclusive work environment is an essential part of making our company a great place to build a career. We also see our diversity as a strength that helps us create better solutions for our clients. Our diverse team of world-class experts supports clients across the breadth of their organizations to operationalize sustainability, underpinned by our deep technical expertise in addressing their environmental, health, safety, risk and social issues. We call this capability our "boots to boardroom" approach for its comprehensive service model that allows ERM to develop strategic and technical solutions that advance objectives on the ground or at the executive level.

ERM is proud to be an Equal Employment Opportunity employer. We do not discriminate based upon race, religion, color, national origin, gender, sexual orientation, gender identity, age, status as a protected veteran, status as an individual with a disability, or other applicable legally protected characteristics.

Thank you for your interest in ERM