Senior BI Developer

Senior Bi Developer

Software Resources has an immediate, direct hire job opportunity for a Senior BI Developer with a major corporation in Denver, CO. Hybrid, 2 days per week on-site.

Candidates need a deep alignment in report design, cross-database semantic model concepts, Fabric-layer knowledge, and the technical and platform ownership aspects of the Senior BI Developer role.

The Senior BI Developer is responsible for designing, developing, and supporting enterprise analytics and reporting solutions within the Microsoft BI ecosystem, with a primary focus on Power BI. This role owns the full BI development lifecycle, including semantic modeling, Data Analysis Expressions (DAX) development, report and dashboard design, Power BI Service administration, and gateway support. The position partners closely with business stakeholders, data engineering, and IT teams to deliver scalable, governed, and high-performing reporting solutions. Experience with Microsoft Fabric is strongly preferred.

Primary Responsibilities

• Design, develop, and maintain enterprise-grade Power BI semantic models using Import, DirectQuery, Composite, and Direct Lake architectures, applying star-schema best practices to ensure scalability, reusability, and clear business semantics.
• Author, optimize, and troubleshoot complex DAX measures and calculation groups, including time intelligence, semi-additive measures, advanced filter context, and dynamic security patterns, using tools such as DAX Studio and Performance Analyzer.
• Build and maintain Power Query (M) transformations, parameterized datasets, reusable dataflows, and incremental refresh strategies to support large-scale reporting environments.
• Implement and manage row-level security (RLS), object-level security (OLS), workspace roles, app audiences, and dataset/report permissions in alignment with governance standards.
• Develop reusable semantic models, shared datasets, and reporting templates to improve consistency, reduce duplication, and support enterprise reporting standards.
• Source and integrate data from SQL Server, Azure SQL, Synapse, Microsoft Fabric, Dataverse, SharePoint, and REST APIs, collaborating closely with data engineering teams on upstream data models and pipeline design.
• Design and deliver intuitive, visually effective dashboards and reports that align with accessibility standards, corporate branding, and executive reporting needs.
• Develop paginated reports using Power BI Report Builder for operational, regulatory, and print-ready reporting requirements.

Power Bi Service & Gateway Administration

• Install, configure, maintain, and troubleshoot on-premises data gateways, including clustering, credential management, version upgrades, and connectivity support.
• Administer Power BI Service environments, including workspace management, deployment pipelines, scheduled refreshes, gateway configurations, alerts, and Premium/Fabric capacities.
• Troubleshoot and resolve refresh failures, gateway connectivity issues, dataset memory constraints, capacity throttling, timeout errors, and report rendering issues to ensure platform reliability and performance.
• Monitor platform health and capacity utilization, proactively tuning workloads and resolving issues before business impact occurs.
• Support tenant-level governance initiatives, including workspace standards, naming conventions, certified/promoted datasets, audit log reviews, and security best practices.
• Participate in on-call support rotations during critical reporting cycles, including month-end and quarter-end close periods.

Delivery, Collaboration & Continuous Improvement

• Serve as the primary BI partner for assigned business functions, developing a strong understanding of operational processes, KPIs, reporting cadences, and business priorities.
• Gather, analyze, and translate business requirements into semantic model designs, measure definitions, and reporting solutions that balance usability, governance, and performance.
• Manage and prioritize a BI development backlog across multiple stakeholders, projects, and competing business priorities.
• Utilize deployment pipelines and source control tools, including Git and Azure DevOps, to support structured development, testing, deployment, and rollback processes.
• Maintain documentation for semantic models, business logic, data lineage, report catalogs, refresh operations, and support procedures.
• Coordinate releases, production deployments, and planned maintenance activities with Change Management and business stakeholders.
• Support ongoing process improvement initiatives and perform other duties, responsibilities, and special projects as assigned.

Required Skills & Experience

• 5+ years of hands-on Power BI development experience, including ownership of enterprise semantic models, datasets, and reports supporting business stakeholders and operational reporting needs.
• Advanced expertise in DAX, including time intelligence, calculation groups, variables, advanced filter context manipulation, and performance tuning using tools such as DAX Studio and Performance Analyzer.
• Strong semantic modeling expertise, including star schema design, role-playing dimensions, many-to-many relationships, RLS/OLS implementation, and architecture considerations across Import, DirectQuery, Composite, and Direct Lake models.
• Strong Power Query (M) and SQL skills, including query folding, parameterization, incremental refresh configuration, data validation, profiling, and source query development against SQL Server, Azure SQL, or Synapse.
• Experience developing and supporting enterprise Power BI Service environments, including workspace governance, deployment pipelines, refresh management, capacity administration, sharing/permissions, and tenant-level settings.
• Hands-on experience installing, configuring, and troubleshooting on-premises data gateways, including clustering, credential management, connectivity issues, and version upgrades.
• Demonstrated ability to design clean, intuitive, and accessible dashboards and reports aligned with corporate branding and executive reporting standards.
• Strong troubleshooting and problem-solving skills related to report performance, refresh failures, gateway connectivity, dataset memory constraints, and capacity optimization.
• Excellent communication and stakeholder management skills, with the ability to translate business requirements into scalable reporting solutions and explain technical concepts in clear business terms.
• Experience with Microsoft Fabric (Lakehouse, Warehouse, Direct Lake, Dataflows Gen2, Pipelines), Tabular Editor 3, ALM Toolkit, Azure DevOps/Git, paginated reports, and Power BI certifications (PL-300, DP-600) preferred.

Software Resources, founded more than 3 decades ago, is a trusted staffing partner specializing in Technology (IT, Creative, & Marketing), Finance, & Accounting placements. We work with companies nationwide that need skilled professionals and connect them with candidates like you looking for the right opportunity. We are always looking for professionals at all experience levels and in various specialties to meet our clients' hiring needs. As a member of our team, you will have access to benefits including medical, dental, and vision coverage, a 401(k) with company match, short-term disability, life insurance with AD&D.