Senior Power BI Developer

Brooksource; Houston (TX); On-site; USD 120,000 - 180,000; Full time

Job summary

Brooksource seeks a Senior Power BI Developer to partner with our Energy Trading and Risk Management team. You will translate complex commercial, operational, financial, and risk-management needs into trusted Power BI solutions, combining report-development expertise with business acumen and executive-level communication.

The role requires collaboration with database, data architecture, and business teams to deliver enterprise-grade analytics across trading, risk, finance, and operations.

Qualifications

• Bachelor’s degree or equivalent experience in information systems, CS, analytics, finance, economics, math or related field.
• Typically 10+ years of BI/analytics experience, including 4+ years Power BI development.
• Advanced Power BI skills: DAX, Power Query, semantic modeling, report design, drill-through, bookmarks, navigation, accessibility, performance optimization.
• Strong SQL skills; experience with SQL Server and/or Snowflake preferred.
• Ability to communicate with leadership and translate requirements into actionable solutions.
• Strong business acumen and analytical judgment connecting data to business outcomes.
• Proven ability to collaborate across technical and functional teams.
• Experience with data modeling, data quality validation, security concepts, and BI development standards.
• Ability to manage priorities, communicate risks, and deliver high-quality work in a dynamic environment.

Responsibilities

• Engage leadership and end users to understand objectives, define requirements, and establish measurable success criteria.
• Design, develop, test, deploy, and support enterprise-grade Power BI dashboards, reports, scorecards, and analytics applications.
• Create structured semantic models using star-schema principles and reusable measures.
• Develop efficient DAX measures and Power Query transformations focusing on accuracy and performance.
• Partner with database and data engineering teams to define source data requirements and improve data pipelines.
• Translate complex ETRM data into insights on positions, exposures, P&L, risk, and settlements.
• Lead workshops, design reviews, demonstrations, testing, and production-readiness activities.
• Present findings and tradeoffs to senior leadership and diverse audiences.
• Implement security and governance practices, including workspace standards and data lineage.
• Monitor adoption, data accuracy, and report performance; resolve defects.
• Establish development standards and contribute to peer reviews and release management.
• Identify opportunities to simplify reporting and automate analysis.

Skills

Power BI development

SQL & relational databases

Leadership & stakeholder communication

Data modeling & data quality

Prioritization & time management

Education

Bachelor’s degree in Information Systems or related field

Tools

SQL Server

Snowflake

Azure data services

Power BI deployment pipelines

Gateways

Dataflows

Job description

We are seeking a Senior Power BI Developer to partner with our Energy Trading and Risk Management team. This highly visible role will translate complex commercial, operational, financial, and risk-management needs into trusted, intuitive Power BI solutions. The successful candidate will combine strong report-development expertise with business acumen, executive-level communication, relationship-building skills, and the ability to collaborate closely with database, data architecture, and business teams.

What Success Looks Like

• Builds credibility with leaders and business partners by listening carefully, asking effective questions, and converting business needs into clear analytics requirements.
• Delivers accurate, performant, and visually effective Power BI reports that support timely decisions across trading, risk, operations, finance, and leadership teams.
• Develops a practical understanding of ETRM processes and data, then uses that knowledge to identify trends, risks, exceptions, and opportunities.
• Works as an effective bridge between business stakeholders and technical teams, including database developers, data engineers, architects, and governance partners.
• Promotes trusted metrics, reusable semantic models, consistent definitions, and responsible self-service analytics.

Core Responsibilities

• Engage leadership teams, subject-matter experts, and end users to understand objectives, define requirements, clarify priorities, and establish measurable success criteria.
• Design, develop, test, deploy, and support enterprise-grade Power BI dashboards, reports, scorecards, and analytical applications.
• Create well-structured semantic models using appropriate star-schema principles, relationships, calculation groups where applicable, and reusable business measures.
• Develop efficient DAX measures and Power Query transformations, with a focus on accuracy, maintainability, usability, and performance.
• Partner with the database and data engineering teams to define source-data requirements, validate data quality, optimize queries, troubleshoot issues, and improve data pipelines.
• Translate complex ETRM data into clear insights related to positions, exposures, volumes, pricing, profit and loss, risk, settlements, contracts, and operational performance, as applicable to the business.
• Lead requirements workshops, design reviews, stakeholder demonstrations, user-acceptance testing, training, and production-readiness activities.
• Present analytical findings, recommendations, and solution tradeoffs clearly to senior leadership and both technical and nontechnical audiences.
• Implement security and governance practices, including workspace standards, deployment processes, data classification, row-level security, documentation, lineage, and controlled access.
• Monitor adoption, refresh reliability, data accuracy, and report performance; proactively resolve defects and improve existing solutions.
• Establish development standards and contribute to peer reviews, version control, release management, reusable components, and team knowledge sharing.
• Identify opportunities to simplify reporting, retire redundant content, automate manual analysis, and increase confidence in business decisions.

Required Qualifications

• Bachelor’s degree in Information Systems, Computer Science, Data Analytics, Finance, Economics, Mathematics, Statistics, or a related field, or equivalent relevant experience.
• Typically 10+ years of business intelligence or analytics experience, including at least 4 years of hands‑on Power BI development.
• Advanced Power BI skills, including DAX, Power Query, semantic modeling, report design, drill-through, bookmarks, tooltips, navigation, accessibility, and performance optimization.
• Strong SQL skills and experience working with relational databases and large, complex datasets; experience with SQL Server and/or Snowflake is preferred.
• Demonstrated ability to communicate with leadership, facilitate requirements discussions, and convert ambiguous business questions into actionable solutions.
• Strong business acumen and analytical judgment, with the ability to understand how data, processes, controls, and performance measures connect to business outcomes.
• Proven ability to build productive relationships with business partners and collaborate across technical and functional teams.
• Experience with data modeling, data quality validation, security concepts, release management, and business intelligence development standards.
• Ability to independently manage priorities, communicate risks, document decisions, and deliver high-quality work in a dynamic environment.

Preferred Qualifications

• Experience supporting energy trading, commodity trading, risk management, or an ETRM/CTRM platform.
• Knowledge of trading and risk concepts such as positions, mark-to-market, realized and unrealized P&L, exposure, limits, pricing, settlements, scheduling, and trade lifecycle data.
• Experience with Microsoft Fabric, Azure data services, Power BI deployment pipelines, gateways, incremental refresh, dataflows, and enterprise workspace administration.
• Experience with Snowflake, dimensional modeling, data warehousing, master data, metadata management, and data governance.
• Familiarity with Agile or Scrum delivery, Azure DevOps or similar work-management tools, and source‑control practices.
• Microsoft Power BI Certifications.

Disclaimer:

Brooksource, Medasource, and Calculated Hire are part of the Eight Eleven Group family of companies and operate under Eight Eleven Group, LLC. All employees receive the same benefits, policies, and terms of employment.

EEO:

We are committed to creating an inclusive environment for all employees and applicants. We do not discriminate on the basis of race, color, religion, creed, sex, sexual orientation, gender identity or expression, national origin, ancestry, age, disability, genetic information, marital status, military or veteran status, citizenship, pregnancy (including childbirth, lactation, and related conditions), or any other protected status in accordance with applicable federal, state, and local laws.

Brooksource offers competitive medical, dental, vision, Health Savings Account, Dependent Care FSA, and supplemental coverage with plans that can fit each employee’s needs. We offer a 401k plan that includes a company match and is fully vested after you become eligible, paid time off, sick time, and paid company holidays. We also offer an Employee Assistance Program (EAP) that provides services like virtual counseling, financial services, legal services, life coaching, etc.

Pay Disclaimer:

The pay range for this job level is a general guideline only and not a guarantee of compensation or salary. Additional factors considered in extending an offer include (but are not limited to) responsibilities of the job, education, experience, knowledge, skills, and abilities, as well as internal equity, alignment with market data, applicable bargaining agreement (if any), or other law.