Senior Business Intelligence Developer Job at Trace3 (Chicago)

Senior Business Intelligence Developer

Trace3

Location:
United States , Chicago

Category:
IT - Software Development

Contract Type:
Not provided

Salary:

110000.00 - 125000.00 USD / Year

Save Job

Apply Position

Job Description:

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.

Job Responsibility:

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
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 have:

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)

What we offer:

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

Additional Information:

Job Posted:
February 14, 2026

Employment Type:

Fulltime

Work Type:

Remote work

Trace3 - All Job Offers

Job Link Share: