Microsoft Power BI Developer
Share
Job Location:
Monthly Salary:
Posted on:
10 hours ago
Vacancies:
1 Vacancy
Job Summary
Key Responsibilities
- Power BI Development: Develop Troubleshoot and maintain interactive Power BI dashboards reports and semantic data models that are user-friendly performant and reliable.
- Requirements & Stakeholder Engagement: Partner with business stakeholders to gather refine and prioritize requirements translate needs into BI solutions and iterate based on feedback.
- DAX Engineering: Create and optimize DAX measures calculated columns and calculation groups with a focus on performance and maintainability.
- Power Query (M) Transformations: Design robust Power Query data extraction and transformation workflows; standardize data shaping and apply query folding best practices.
- Data Source Integration: Connect and integrate multiple data sources (e.g. SQL Server PostgreSQL Excel CSV SharePoint APIs) ensuring efficient refresh and gateway configurations.
- Security & Governance: Implement data security including Row-Level Security (RLS) Object-Level Security (OLS) workspace governance user access management and endorsement/certification processes.
- Operations & Support: Monitor refreshes troubleshoot report/dashboard issues optimize dataset performance and manage incident triage with root-cause analysis.
- Documentation & Enablement: Document data models measures report logic lineage and data flows; develop user guides and conduct training sessions for self-serve analytics.
SQL and Database Responsibilities
- Advanced SQL: Write optimize review & Troubleshoot complex SQL (joins window functions CTEs aggregations) for reporting and data preparation.
- PostgreSQL Preferred: Leverage PostgreSQL features (e.g. explain plans indexing materialized views) for performance and stability.
- Data Architecture Awareness: Understand database structures normalization/denormalization and how model design impacts BI performance.
- Pipelines & Modeling: Collaborate on data pipelines and contribute to star/snowflake dimensional models for analytics.
ETL Pipeline Responsibilities
- Pipeline Development: Build and maintain SnapLogic pipelines for data ingestion and transformation from diverse sources to target stores (e.g. data lake warehouse).
- Quality & Reliability: Implement error handling logging testing and debugging practices; promote reusable snaps and parameterization.
- Cloud Storage: Work with Amazon S3 or similar cloud object storage for staged and curated datasets.
- Operationalization: Schedule monitor and optimize pipeline performance and costs.
General Data Responsibilities
- Data Warehousing Concepts: Apply dimensional modeling fact/dimension design SCDs conformed dimensions and partitioning principles.
- Data Quality: Perform data cleaning transformation validation and reconciliation to ensure accuracy and consistency.
- Collaboration: Conduct workshops and interviews with business users; translate business questions into analytic specifications and metrics definitions.
- Documentation: Produce clear documentation of report logic KPIs data flows lineage and glossary for governance and reuse.
Tools and Technologies
- Core: Power BI Desktop Power BI Service DAX Power Query (M) SQL PostgreSQL SQL Server
- ETL: SnapLogic (preferred) or equivalent ETL/ELT tools
- Cloud/Storage: Amazon S3 (or Azure/AWS equivalents)
- Collaboration: Git-based version control ticketing systems (e.g. ServiceNow) documentation tools (e.g. Confluence)
