Sr Business Intelligence Developer | Power BI (Remote)

Trace3 • Chicago, IL

5h • Remote

About The Position

The Senior Business Intelligence Developer (Power BI) is responsible for designing, developing, and supporting enterprise reporting and analytics solutions that enable data-driven decision-making across the organization. This role partners closely with business stakeholders to define reporting needs, build scalable Power BI dashboards and semantic models, and ensure consistency of KPI definitions, governance, and data integrity.
This role drives best practices across data modeling, visualization standards, performance optimization, and self-service enablement.

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.
• Advanced Power BI development (DAX, modeling, optimization)
• Strong business acumen and ability to translate stakeholder needs into measurable BI outcomes
• Documentation discipline (data definitions, metric catalogs, reporting standards)
• Excellent problem-solving and root cause analysis
• Ability to work in a fast-paced environment with shifting priorities
• Collaboration and mentorship mindset

Nice To Haves

• Experience with SQL and working directly with data sources (data warehouses, data lakes, transactional systems).
• Experience with Power BI governance practices (certified datasets, workspace strategy, deployment pipelines, versioning).
• Familiarity with enterprise platforms such as:
• NetSuite, Salesforce, ServiceNow, Monday.com, PSA platforms, or similar systems.
• Exposure to modern data platforms such as Azure, Snowflake, Databricks, Microsoft Fabric, or equivalent.
• Understanding of financial and operational KPIs (e.g., revenue, GP/GM, utilization, backlog, bookings).

Responsibilities

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

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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed