Principal Consultant

Environmental Resources Management, Inc.; Austin (TX); On-site; USD 120,000 - 160,000; Full time

Job summary

Environmental Resources Management, Inc. in Austin, TX seeks a Senior Power BI & Data Automation Developer to lead analytics, automation, and BI initiatives across environmental, infrastructure, and sustainability projects.

You will design scalable reporting platforms, integrate diverse data sources, and mentor colleagues while championing best practices in analytics, development, and automation. Bring strong expertise in Power BI, SQL, Python, and ETL pipelines.

Qualifications

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

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.

Skills

Power BI

SQL

Python

ETL/ELT

Power Apps

Power Automate

Data modeling

Data governance

Communication

Multi-tasking

Education

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

Tools

Azure Data Factory

Azure SQL

Dataverse

SharePoint

GIS/Esri

APIs

JSON

CI/CD

Notebooks

Data lakes

Job description

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