Sr Power BI Developer to support multiple BI projects for a construction company

Our client is looking for a Sr Power BI Developer to support multiple BI projects for a construction company.

Must Have's:

• 5+ years of experience as a power BI developer

• 7+ years of experience delivering medium to large BI, data, or application projects, specifically with BI migration
• Proficiency in Power BI, Azure, DevOps, and Agile Delivery
• 5+ years of experience with Power BI, Azure, DevOps, and Agile Delivery
• Experience with MS Fabric platform - including building or migrating data warehouse processes to Fabric

Scope of Work:

• Develop and maintain business BI dashboards
• Create strategies and operational models for BI reporting/self-service.
• Improve and enhance the BI environment.
• Migrate all BI reports from SSRS to Azure.

Responsibilities:

• Collaborate with business stakeholders, data analysts, and other IT team members to gather and understand requirements and ensure that Power BI solutions meet business needs.
• Take an active role in BI projects, initiatives, enhancements, and incidents using the Microsoft Azure BI Stack (Azure Data Factory, Synapse Studio, Power BI, Azure DevOps).
• Attend daily team stand up meeting and other team meetings and provide weekly development updates.
• Power BI: Designing, developing, and maintaining Power BI solutions which adhere to the development and design frameworks in place.
• Develop data models using Power BI's data modeling capabilities, including relationships, calculated columns, and measures.
• Be proficient is DAX coding.
• Ensure all Power BI development follows IT design and coding standards.
• Perform data cleansing and transformation using Power Query Editor.
• Publish and share Power BI reports securely using DevOps CI/CD framework and deploy to Power BI Service.
• Provide training and support to users on how to use Power BI effectively, including creating reports in Power BI Service, navigating dashboards, and interpreting visualizations.
• Implement security measures to protect sensitive data and ensure compliance with organizational security policies.
• Azure Data Warehouse
• Collaborate in developing the BI Azure data warehouse, its semantic layer, metadata, reports, and dashboards with assistance from business SMEs and internal team members.
• Maintain and enhance the automated ingestion of internal and external data retrieval, client reporting and operational processes using the established BI framework.
• Interface with cross-functional teams to build centralized/custom data analytics tools to enhance the business process.
• Connect to various data sources, including databases, cloud services, SharePoint, and APIs.
• Ingest new data sources into the Azure data lake leveraging the ingestion framework.
• Update fact and dimension tables in the “gold” layer.
• Be proficient in T-SQL to build and update stored procedures.
• Use established DevOps CI/CD framework to publish and promote changes.
• Azure DevOps: Use the Azure DevOps toolset to document, code, test, and deploy all new or modified business intelligence applications, data models, and dashboards and reports.
• All deployments and changes leverage the standardized CI/CD processes.
• Work with the QA team to ensure data accuracy and alignment with requirements.
• Collaborate with the IT PMO to ensure project deliverables are met.
• Work on the design of dimensional data models, and data warehouse solutions to ensure interoperability with existing business intelligence solutions.
• Assist the business analysts in gathering business requirements and work with the appropriate teams to interpret requirements.
• Analyze user requirements and based on findings, design functional specifications for business intelligence front-end applications.
• Troubleshoot and support business intelligence tools, systems, and software; performance-tune these applications, as necessary.
• Support and enhance existing reports and dashboards based on evolving business needs.
• Develop queries and data visualizations for ad-hoc, recurring and troubleshooting requests.