Business Intelligence Developer (Power BI)

This is a full-time, hybrid, office-based position. You will work on-site three days per week from our Morgantown, WV or Canonsburg, PA office.

What Youll Be Doing

• Design, develop, and maintain interactive dashboards, reports, scorecards, and self-service visualizations that support organizational objectives and decision-making
• Partner with business stakeholders to gather, analyze, and document reporting and analytics requirements, translating business needs into technical solutions
• Analyze and validate data models and ETL/ELT processes built by Data Engineers and Architects to ensure efficient integration
• Monitor and ensure data quality, integrity, and consistency through validation procedures, troubleshooting, and support for data governance standards, working with data stewards to correct issues
• Perform data analysis and trend identification to uncover opportunities, risks, and operational improvements
• Optimize the performance of databases, queries, reports, and dashboards, and maintain documentation for data sources, data models, and reporting processes
• Provide technical support and training to end users, promoting adoption of business intelligence tools and improving data literacy across the organization

Business Intelligence, Power BI, Business Intelligence, Reporting Dashboards, Data Modeling, Scorecarding, Analysis Skills, Requirements Management, Data Quality, Database Extract Transform and Load (ETL), * Bachelors degree in Information Technology, Computer Science, Management Information Systems, or a related field; 5 years of relevant experience will be accepted in lieu of a degree

• 3-5 years of experience developing and supporting business intelligence, reporting, analytics, or data warehousing solutions in a complex business environment
• Hands-on Power BI experience building visualizations directly from a data warehouse (not solely from Excel-based sources)
• Working knowledge of data warehousing concepts, ETL/ELT processes, and fact/dimension (dimensional) data modeling
• Proficiency in SQL, including the ability to query the database and make adjustments as needed
• Proven ability to gather and analyze requirements and translate business needs into effective reporting solutions
• Strong analytical and problem-solving skills, with the ability to troubleshoot data issues and a working knowledge of data governance, data quality, and information security principles
• Excellent communication skills and the ability to collaborate with technical teams, business stakeholders, and executives, working autonomously, adapting to change, and managing multiple priorities

Preferred

• Experience with data pipelines or data ingestion
• Experience with finance and accounting data and knowledge of financial reporting concepts
• Oil and gas industry experience