24 Jan
S.i. Systems
Toronto
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.
Apply
Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.