Senior Power BI Developer

StarSevenSix, LTD.; Columbus (OH); On-site; USD 90,000 - 120,000; Full time

Job summary

StarSevenSix, LTD. is seeking an experienced Power BI Developer to design, develop, test, deploy, and support enterprise BI solutions.

The role requires expertise in Power BI, SQL, DAX, semantic and dimensional modeling, data visualization, security, administration, and embedded analytics. The ideal candidate will manage the full reporting lifecycle from data structures to semantic models and end-user experience, collaborating across stakeholders and IT teams while upholding quality and testing

Qualifications

• Professional experience developing enterprise Microsoft Power BI solutions.
• Strong SQL and DAX development and troubleshooting skills.
• Strong knowledge of Power BI semantic modeling and dimensional modeling.
• Experience embedding Power BI reports and dashboards into web applications, including iframe-based integration.
• Experience validating report results and performing developer-level testing.

Responsibilities

• Design, develop, and maintain Power BI semantic models, reports, and dashboards.
• Build semantic models against transactional databases, ODS, data warehouses, and Data Marts.
• Design intuitive report experiences with navigation, filtering, drill-through, tooltips, and bookmarks.
• Embed Power BI reports into web applications and collaborate with developers on integration.
• Test security, governance, deployments, and performance of BI solutions.

Skills

Power BI

SQL

DAX

Semantic modeling

Dimensional modeling

Data visualization

Troubleshooting

Communication

Collaboration

Web embedding

Tools

Power BI Service

Source Control

Release Management

Job description

Position Summary

We are seeking an experienced Power BI Developer to design, develop, test, deploy, and support enterprise business intelligence solutions. This role requires strong expertise in Power BI, SQL, DAX, semantic modeling, dimensional data modeling, data visualization, security, administration, and embedded analytics.

The ideal candidate understands the full reporting lifecycle, from underlying data structures through semantic models and ultimately the user experience. They can work with transactional, Operational Data Store (ODS), and dimensional Data Mart environments and understand how data architecture, relationships, cardinality, DAX, security, and visualization design affect the accuracy and usability of a Power BI solution.

This individual will work collaboratively with business stakeholders, data professionals, application developers, and other Power BI developers while taking ownership of the quality and testing of their work.

Key Responsibilities

Power BI Development & Semantic Modeling

• Design, develop, and maintain Power BI semantic models, reports, and dashboards.
• Build semantic models against transactional databases, Operational Data Stores (ODS), data warehouses, and Data Marts.
• Understand dimensional modeling concepts including facts, dimensions, grain, keys, star schemas, and relationships.
• Demonstrate a strong understanding of cardinality, relationship direction and filter propagation.
• Determine when source data structures should be simplified or reshaped to create effective analytical models.
• Design semantic models for accuracy, usability, maintainability, and performance.

SQL & DAX

• Able to write advanced SQL for analysis, validation, reconciliation, and troubleshooting.
• Can demonstrate proficiency with joins, CTEs, subqueries, aggregations, data types, NULL handling, and query performance.
• Develop maintainable DAX measures for KPIs, ratios, trends, time-based analysis, and complex business calculations.
• Understand DAX concepts including row context, filter context, context transition, CALCULATE, iterators, time intelligence, and relationship behavior.
• Troubleshoot results across the full data path, including source data, SQL, semantic model relationships, filters, and DAX calculations.

Data Visualization & User Experience

• Apply established data visualization and information-design principles to reports and dashboards.
• Be familiar with recognized visualization thought leaders and approaches, including Edward Tufte, Stephen Few, and Cole Nussbaumer Knaflic.
• Make effective use of visual selection, layout, color, hierarchy, labeling, and information density to communicate information clearly.
• Design intuitive report experiences using appropriate navigation, filtering, drill-through, tooltips, bookmarks, and other Power BI capabilities.
• Translate business requirements into clear and actionable visualizations while maintaining consistency, accessibility, and ease of use.

Embedded Power BI & Web Integration

• Embed Power BI reports and dashboards into web applications, including iframe-based implementations.
• Collaborate with application developers to integrate Power BI content into a cohesive web application experience.
• Understand authentication, authorization, Power BI permissions, and semantic model security as they relate to embedded reporting.
• Design reports with the embedded experience in mind, including navigation, sizing, filtering, and usability.
• Troubleshoot embedded report issues involving authentication, permissions, rendering, filtering, and user access.

Security, Administration & Deployment

• Design and implement Row-Level Security (RLS), including appropriate static and dynamic security patterns.
• Test security using different roles and user scenarios to ensure users can access only authorized information.
• Understand Power BI Service capabilities including workspaces, apps, semantic models, refresh, gateways, permissions, workspace roles, and deployment processes.
• Troubleshoot refresh, gateway, access, and Power BI Service issues.
• Follow established governance, naming, documentation, deployment, and change-management practices.

Testing & Quality Assurance

• Take ownership of developer-level testing before solutions are delivered for user acceptance testing or production deployment.
• Validate Power BI results against authoritative source data using SQL and appropriate reconciliation techniques.
• Test DAX calculations, aggregations, relationships, cardinality, filters, slicers, interactions, drill-through, navigation, refresh behavior, RLS, and embedded functionality.
• Test expected results as well as edge cases, exceptions, NULL/blank handling, and negative security scenarios.
• Perform regression testing when changes are made to existing functionality.
• Document defects and verify corrections rather than relying solely on visual inspection of reports.

Collaboration & Communication

• Work effectively with business analysts, data engineers, data architects, database developers, application developers, QA professionals, and business stakeholders.
• Participate in design, semantic model, code, and report reviews.
• Communicate technical concepts clearly to both technical and non-technical audiences.
• Collaborate with team members on design decisions and be receptive to technical and business feedback.
• Question unclear requirements and business rules rather than making unsupported assumptions.
• Document important business logic, measures, model designs, security rules, and technical decisions.

Required Qualifications

• Professional experience developing enterprise Microsoft Power BI solutions.
• Strong SQL and DAX development and troubleshooting skills.
• Strong knowledge of Power BI semantic modeling and dimensional modeling.
• Experience working with transactional databases, ODS environments, data warehouses, and dimensional Data Marts.
• Strong understanding of cardinality, data grain, relationships, and filter propagation.
• Experience creating effective, user-friendly Power BI reports and dashboards.
• Strong knowledge of data visualization and information-design best practices.
• Experience embedding Power BI reports and dashboards into web applications, including iframe-based integration.
• Experience implementing and testing Row-Level Security (RLS).
• Working knowledge of Power BI Service administration, security, refresh, gateways, workspaces, and deployment.
• Experience validating report results against source data and performing developer-level testing.
• Strong analytical, troubleshooting, communication, and collaboration skills.

Preferred Qualifications

• Experience designing semantic models over star-schema Data Marts.
• Experience working across data architectures such as:

Transactional Source → ODS → Data Warehouse/Data Mart → Semantic Model → Power BI

• Experience optimizing DAX and semantic models for performance.
• Experience with embedded analytics and collaboration between BI and web development teams.
• Experience performing source-to-report reconciliation and data-quality validation.
• Familiarity with source control, release management, and structured BI development practices.
• Experience working in Agile or other collaborative software development environments.

S76 provides a wide variety of challenging opportunities, ensuring our associates work in highly sought-after environments and with the latest innovations in technology. We start our relationship with a conversation about your career goals, and work hard to match you with the perfect opportunity. The world of IT is continuously changing, so we know the importance of keeping your skills sharp. Our culture supports continued growth through sponsorship of events, trainings, certifications and other online or structured learning opportunities. We’ll help you stay ahead of the curve. In addition, we provide a comprehensive benefits package including medical, dental, optical, 401k, etc.

S76 is committed to providing career opportunity and growth to all associates without regard to race, color, religion, sex, national origin, age, marital or veteran status, medical condition or disability.