What are the responsibilities and job description for the Power BI Specialist | Construction position at Stradigi?
Job Description
Job Description:
The Power BI Lead is responsible for leading the design, development, and deployment of data analytics and business intelligence solutions using Power BI. This role requires strong technical expertise in data modeling, visualization, and governance, as well as leadership capabilities to manage BI projects and mentor junior developers. The Power BI Lead collaborates with stakeholders to translate business needs into insightful, data-driven solutions that support strategic decision-making.
Key Responsibilities
Job Description:
The Power BI Lead is responsible for leading the design, development, and deployment of data analytics and business intelligence solutions using Power BI. This role requires strong technical expertise in data modeling, visualization, and governance, as well as leadership capabilities to manage BI projects and mentor junior developers. The Power BI Lead collaborates with stakeholders to translate business needs into insightful, data-driven solutions that support strategic decision-making.
Key Responsibilities
- BI Strategy & Leadership:
- Define and implement Power BI governance, standards, and best practices.
- Lead BI initiatives and mentor Power BI developers across teams.
- Collaborate with business and technical teams to define data strategies and roadmaps.
- Solution Development:
- Build complex, interactive dashboards and reports to visualize KPIs and business metrics.
- Develop data models and DAX calculations to optimize performance and usability.
- Integrate multiple data sources (SQL Server, Excel, APIs, etc.) into robust reporting layers.
- Data Management & Governance:
- Ensure data quality, security, and consistency across reports and data sources.
- Implement row-level security (RLS) and role-based access controls.
- Support data warehouse and ETL processes in collaboration with data engineering teams.
- Stakeholder Engagement:
- Partner with business units to gather requirements and deliver actionable insights.
- Conduct workshops and training for users on Power BI tools and capabilities.
- Present insights and dashboard prototypes to executives and stakeholders.
- Bachelor’s degree in Data Science, Computer Science, Information Systems, or a related field.
- 5 years of experience in BI/reporting with at least 3 years in Power BI.
- Strong experience in data modeling, DAX, and Power Query (M language).
- Deep knowledge of relational databases and SQL (T-SQL preferred).
- Experience leading BI teams or cross-functional analytics projects.
- Preferred certifications:
- Microsoft Certified: Data Analyst Associate (PL-300)
- Microsoft Certified: Azure Data Engineer Associate or related certs
- Strong leadership and mentoring abilities.
- Strategic thinker with attention to detail.
- Excellent problem-solving and analytical skills.
- Clear, confident communication with technical and non-technical audiences.
- Results-oriented and proactive mindset.
- Power BI (Service, Desktop, Gateway, Mobile)
- Microsoft Fabric / Azure Synapse (if in use)
- SQL Server / Azure SQL Database / Analysis Services
- Excel, SharePoint, Teams
- ETL tools: Power Query, Dataflows, Azure Data Factory (ADF)
- Source Control: Git, Azure DevOps
- Data Sources: APIs, OData feeds, flat files, cloud storage
- Data modeling and star schema design
- DAX (Data Analysis Expressions)
- Power Query (M)
- SQL and T-SQL for data extraction and transformation
- Advanced Power BI visuals and storytelling
- Performance tuning and optimization
- Power BI governance and workspace management
- Row-level security (RLS) and data privacy
- Agile/Scrum project management experience