Senior Business Intelligence Developer – Power BI
Trace3
full-time
Posted on:
Location Type: Remote
Location: Illinois • United States
Visit company websiteExplore more
Salary
💰 $110,000 - $125,000 per year
Job Level
About the role
- Design and develop high-quality Power BI reports and dashboards that align to business goals and stakeholder needs.
- Translate business requirements into scalable BI solutions, including dashboards, scorecards, KPI tracking, and ad-hoc reporting.
- Create and maintain reusable Power BI assets (measure libraries, templates, report standards, certified datasets).
- Develop and maintain Power BI semantic models (datasets) using best practices (star schema, proper relationships, optimized DAX).
- Build and optimize DAX measures, calculations, and model performance to ensure fast, reliable reporting experiences.
- Partner with Data Engineering and IT teams to define data requirements and improve data quality and accessibility.
- Ensure consistency of KPI definitions, business logic, and metric interpretation across dashboards and stakeholders.
- Contribute to and support a structured approach to certified dashboards/datasets, KPI documentation, and reporting governance.
- Establish and maintain strong documentation, including metric definitions, refresh cadence, and data lineage.
- Implement and maintain Row-Level Security (RLS) and access control structures aligned to business and security requirements.
- Ensure dashboards follow data handling, privacy, and compliance requirements as defined by internal governance and security teams.
- Provide production support for BI solutions, including troubleshooting, incident resolution, and continuous enhancement.
- Monitor and improve performance, refresh reliability, and user experience.
- Identify opportunities to improve efficiency via automation, self-service enablement, and reduction of recurring manual reporting requests.
- Act as a trusted partner to business leaders, supporting prioritization, planning, and reporting roadmap discussions.
- Mentor junior BI developers/analysts and support standardization of development practices across the team.
- Contribute to process maturity, including intake/triage, requirements definition, and delivery best practices.
Requirements
- 5+ years of experience in Business Intelligence, reporting, analytics, or a related discipline.
- 3+ years of strong hands-on experience with Power BI, including:
- Data modeling and dataset design
- DAX development and optimization
- Power Query transformations
- Report performance tuning
- Experience gathering requirements and translating them into scalable reporting solutions.
- Strong understanding of relational data concepts and reporting design patterns (star schemas, facts/dimensions).
- Ability to work across technical and business stakeholders and communicate clearly at multiple levels.
Benefits
- Comprehensive medical, dental and vision plans for you and your dependents
- 401(k) Retirement Plan with Employer Match, 529 College Savings Plan, Health Savings Account, Life Insurance, and Long-Term Disability
- Competitive Compensation
- Training and development programs
- Major offices stocked with snacks and beverages
- Collaborative and cool culture
- Work-life balance and generous paid time off
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
Power BIDAXData modelingDataset designPower QueryReport performance tuningKPI trackingAd-hoc reportingRow-Level SecurityData quality
Soft Skills
CommunicationMentoringCollaborationProblem-solvingDocumentationStakeholder managementProcess improvementPlanningPrioritizationAnalytical thinking