Senior Power BI & Data Automation Lead

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

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.