Position intent: Hire a data-focused generalist who can build and support modern analytics solutions using Microsoft Fabric, Power BI, SQL, dimensional modeling, data pipelines, and governed semantic models.
Recommended Work Emphasis
| | |
| | Reliable ingestion, transformation, modeling, pipelines, quality controls, and reusable curated data. |
| | Trusted semantic models, dashboards, operational reporting, and decision support. |
| | Well-defined requirements, metric definitions, validation, documentation, and user acceptance testing. |
Supporting Automation / Code | | Light Python, PowerShell, APIs, or Power Automate used to extend and automate analytics workflows. |
What This Role Is Not
- Not a full-stack software engineering position.
- Not primarily focused on mobile, web, or enterprise application development.
- Not limited to building report visuals without responsibility for the underlying data and business logic.
- Not a purely administrative Power BI role.
Core Responsibilities
| |
| Develop and support ingestion and transformation processes using Fabric pipelines, Dataflows Gen2, lakehouses, warehouses, notebooks, or other appropriate Fabric components. |
| Create and maintain dimensional models, curated analytical tables, relationships, conformed dimensions, and reusable business logic. |
| Build and support governed Power BI semantic models, including measures, relationships, refresh design, security, naming standards, and documentation. |
| Develop clear, useful, performant reports and dashboards that answer defined business questions and support operational and executive decision making. |
| Validate source-to-report results, identify data issues, document reconciliation logic, and implement repeatable data-quality checks. |
| Monitor refreshes and pipelines, troubleshoot failures, improve reliability, and document support procedures. |
| Work with stakeholders to define requirements, business rules, KPIs, acceptance criteria, and authoritative metric definitions. |
| Follow workspace, security, testing, change-control, release, lineage, and production-readiness standards. |
Documentation & Enablement | Create technical documentation, data dictionaries, solution notes, lineage descriptions, user guidance, and knowledge-transfer materials. |
Required Technical Skills
- Strong SQL/T-SQL skills, including joins, common table expressions, aggregations, window functions, data validation, and query troubleshooting.
- Python or PySpark for data preparation, validation, notebooks, or automation.
- Hands-on Power BI development experience, including Power Query, semantic models, interactive report design, publishing, and refresh support.
- Understanding of dimensional modeling, including fact tables, dimension tables, star schemas, grain, keys, and slowly changing dimensions.
- Understanding of ETL and ELT concepts, data ingestion, transformation, orchestration, dependencies, and error handling.
- Ability to reconcile data from source systems through transformation layers to published reports.
- Experience creating clear technical documentation and translating business definitions into governed analytical logic.
- Working knowledge of security concepts that affect analytics, including access management and row-level security.
- Basic Git or Azure DevOps source-control practices.
- Strong communication with technical and non-technical audiences.
Preferred Microsoft Fabric Experience
- Fabric workspaces, capacities, items, and deployment concepts.
- Lakehouse and Warehouse design and support.
- Data Factory pipelines and Dataflows Gen2.
- Fabric notebooks and Spark or Python for data engineering tasks.
- OneLake concepts, shortcuts, and medallion-style data organization.
- Direct Lake and Import semantic-model considerations.
- Monitoring Hub, refresh troubleshooting, lineage, and operational support.
- Deployment pipelines, source control, or structured development and release practices.
Preferred Power BI Experience
- Advanced calculation patterns.
- Power Query and reusable transformation logic.
- Semantic-model performance optimization and model simplification.
- Row-level security and testing across business entities or user groups.
- Workspace organization, Power BI apps, deployment, and access management.
- Report usability, accessibility, visual consistency, and performance optimization.
- Shared semantic models and thin-report development patterns.
Supporting Coding Skills
Not necessary, but nice to have. Will use these skills but I can teach them if not known already.
- PowerShell for administration or repeatable support tasks.
- Ability to work with REST APIs, JSON, authentication concepts, and configuration values.
- Ability to read, troubleshoot, and adapt existing code without needing to be a full-stack developer.
Business and Professional Skills
- Ability to translate a business problem into data requirements, model requirements, metrics, and reporting outcomes.
- Detail-oriented approach to data reconciliation, testing, and quality assurance.
- Ability to challenge unclear requirements and ask effective follow-up questions.
- Comfort managing several priorities across development, troubleshooting, stakeholder support, and documentation.
- Curiosity, adaptability, and willingness to learn as the Fabric environment and analytics program mature.
Experience Profile
| |
| Two or more years of relevant experience in data analytics, business intelligence, data engineering, data warehousing, or a closely related field; practical Power BI and SQL experience. |
| Demonstrated experience building complete analytics solutions from source data through transformation, modeling, semantic models, and Power BI delivery. |
| Hands-on Microsoft Fabric experience, enterprise Power BI support, dimensional modeling, pipeline troubleshooting, governance, security, and stakeholder-facing requirements work. |
