Scope<\/span><\/b>:<\/span>
<\/p>
- The Office of the Public Guardian and Trustee (OPGT) requires a Senior Software Developer to help build a new data warehouse\/lakehouse and deliver the reporting MVP (minimum viable product).<\/span>
<\/li>
<\/ul> <\/span>
<\/p>Assignment Deliverables<\/span><\/b>:<\/span>
<\/p>As a member of the data team, you will be responsible to help define the MVP for reporting, build the new data warehouse\/lakehouse and deliver the required reporting. A high\-level list of deliverables for the data migration team follows:<\/span>
<\/p>
- Data Warehouse Design: analyze business requirements and design an efficient data warehouse\/lakehouse\/golden layer on Microsoft Azure<\/span>
<\/li>
- Data Integration and ETL: help develop and automate ETL processes to load data from Dynamics 365 CE and F&O into the new data warehouse\/lakehouse (bronze\/silver\/golden layers). Help integrate data from diverse sources into the new data warehouse.<\/span>
<\/li>
- Data Modeling: create logical and physical data models that align with the projectâs reporting and analytical needs.<\/span>
<\/li>
- Data Security and Governance: implement appropriate security controls to protect sensitive data within the data warehouse.<\/span>
<\/li>
- Reporting and Visualization: develop reports, dashboards and visualizations as per reporting MVP. Ensure the quality, accuracy and integrity of reports.<\/span>
<\/li>
- Performance Optimization: fine\-tune the data warehouse and reporting processes to optimize query performance and overall system efficiency.<\/span>
<\/li>
- Other duties as assigned.<\/span>
<\/li>
<\/ul>
<\/div><\/span>
Requirements<\/h3>
Experience and Skill Set Requirements:<\/span><\/u><\/b>
<\/p>Must Haves:<\/span><\/u><\/b>
<\/p>
- Power BI: Proficiency in Power BI, including data modeling, creating interactive reports and dashboards and utilizing advanced features.<\/span>
<\/li>
- Demonstrated experience with data analytics and reporting from Dynamics 365 CE and\/or F&O.<\/span>
<\/li>
- Data Warehouse\/Lakehouse Concepts: Strong understanding of data warehousing principles, including data modeling, ETL processes, data integration, and data governance.<\/span>
<\/li>
<\/ul> <\/span>
<\/p>Nice To have:<\/span><\/b>
<\/p>
- Azure cloud <\/span>certifications (e.g. Azure fundamentals, Azure Power BI Data Analyst Associate)
<\/span><\/li>
- Experience with PowerApps platform, Power Automate, Dynamics CE and F&O<\/span>
<\/span><\/li>
<\/ul> <\/span>
<\/p>Skill Set Requirements:<\/span><\/u><\/b>
<\/p>Desired Skills and Experience<\/span><\/b>:<\/span>
<\/p>
- Data Warehouse\/Lakehouse Concepts: Strong understanding of data warehousing principles, including data modeling, ETL processes, data integration, and data governance.<\/span>
<\/li>
- Power BI: Proficiency in Power BI, including data modeling, creating interactive reports and dashboards, configuring data gateways, and utilizing advanced features such as DAX and Power Query.<\/span>
<\/li>
- Knowledge of technologies commonly used with Dynamics 365, such as DataVerse \/ Common Data Service (CDS), Data Entities, and APIs.<\/span>
<\/li>
- SQL and Query Optimization: Strong SQL skills for writing complex queries, optimizing database performance, and troubleshooting query performance issues. Understanding of indexing, partitioning, and query execution plans.<\/span>
<\/li>
- Data Modeling and Design: Proficiency in designing logical and physical data models, understanding relationships, defining hierarchies, and ensuring efficient data storage and retrieval.<\/span>
<\/li>
- Data Visualization: Ability to create visually appealing and informative reports and dashboards using Power BI, understanding best practices for data visualization, and storytelling with data.<\/span>
<\/li>
- Data Security and Governance: Knowledge of data security principles, data governance practices, data quality management, and data lifecycle management.<\/span>
<\/li>
- Analytical and Problem\-Solving Skills: Strong analytical thinking and problem\-solving abilities to identify business requirements, analyze data, and provide meaningful insights to stakeholders.<\/span>
<\/li>
- Communication and Collaboration: Effective communication skills to interact with stakeholders, gather requirements, and present findings. Collaboration skills to work with cross\-functional teams, such as data engineers, data analysts, and business stakeholders.<\/span>
<\/li>
- Familiarity with version control systems (e.g., Azure Repos) and collaboration tools (e.g., Azure DevOps) for managing code, tracking changes, and collaborating with team members.<\/span>
<\/li>
- Experience with SQL Server Management Studio, Azure data management tools, data modeling tools <\/span>
<\/li>
- Experience with SSIS, SSRS<\/span>
<\/li>
<\/ul> <\/span>
<\/p>Data Warehouse:<\/span><\/b>
<\/p>
- Demonstrated experience developing reports in a Data Warehouse\/ Lakehouse. Experience with supporting a data warehouse in a production environment<\/span>
<\/li>
- Demonstrated experience working with Azure Synapse workspaces, including knowledge of pipeline creation, data flows, integration runtimes, triggers, and monitoring. <\/span>
<\/li>
- Demonstrated experience with data warehousing modelling concepts such as star and snowflake schemas and data modelling tools.<\/span>
<\/li>
<\/ul> <\/span>
<\/p>PowerBI:<\/span><\/b>
<\/p>
- Demonstrated experience working Power BI, creating interactive reports and dashboards, configuring data gateways, utilizing advanced features such as DAX and Power Query.<\/span>
<\/li>
<\/ul> <\/span>
<\/p>SQL \/ DB:<\/span><\/b>
<\/p>
- Demonstrated experience with data manipulation languages (T\-SQL, PL\/SQL), data definition languages, query performance analysis & tuning<\/span>
<\/li>
- Demonstrated experience with SQL Server, Oracle, Azure SQL Databases<\/span>
<\/li>
- Experience with SSIS, SSRS<\/span>
<\/li>
<\/ul> <\/span>
<\/p>Dynamics 365:<\/span><\/b>
<\/p>
- Strong understanding of the Dynamics 365 data model, entities, and relationships.<\/span>
<\/li>
- Experience developing reports from source data from Dynamics 365 CE or F&O.<\/span>
<\/li>
- Familiarity with Dataverse and Power Platform application development.<\/span>
<\/li>
<\/ul> <\/span>
<\/p>Azure Platform:<\/span><\/b>
<\/p>
- Experience with Azure Data Factory (ADF) and Synapse Workspaces<\/span>
<\/li>
- Demonstrated experience Azure data management tools, DevOps, <\/span>
<\/li>
- Azure cloud certifications<\/span>
<\/li>
<\/ul>
<\/div><\/span>
<\/body>
<\/html>"}}],"isMobile":false,"iframe":"true","jobType":"Contract","applyName":"Apply Now","zsoid":"653862245","FontFamily":"PuviRegular","jobOtherDetails":[{"fieldLabel":"Term","uitype":1,"value":"158 days"},{"fieldLabel":"Assigned Recruiter(s)","uitype":80,"value":"Sweta Singh"},{"fieldLabel":"Job Opening ID","uitype":111,"value":"9739"},{"fieldLabel":"Industry","uitype":2,"value":"Technology"},{"fieldLabel":"Number of Positions","uitype":32,"value":"1"},{"fieldLabel":"Work Experience","uitype":2,"value":"10+ Years"},{"fieldLabel":"City","uitype":1,"value":"Toronto"},{"fieldLabel":"State\/Province","uitype":1,"value":"Ontario"},{"fieldLabel":"Zip\/Postal Code","uitype":1,"value":"M4C"}],"headerName":"RQ10090 \- Business Intelligence Specialist \- Senior","widgetId":"383123000000072311","isJobBoard":"false","userId":"383123000000184003","attachArr":[{"fileName":"RQ10090 \- Business Intelligence Specialist \- Senior.docx","linkDocs":0,"isView":"false","fileDigest":"6fbn5breIzBNwVUMiggIrpvQUwTm4jaU4CIbcrVsJT4xMRg6XEThv5lCXNyVX5as7NjckCVuqqZgnO8auPH8lg\-\-","fileType":"docx"}],"customTemplate":"4","isCandidateLoginEnabled":true,"jobId":"383123000202991308","FontSize":"15","googleIndexUrl":"https:\/\/maarutinc.zohorecruit.com\/recruit\/ViewJob.na?digest=6fbn5breIzBNwVUMiggIrv9lvU4@ZFKijcVFPaBPbSE\-&embedsource=Google","location":"Toronto","embedsource":"CareerSite","indeedCallBackUrl":"https:\/\/recruit.zoho.com\/recruit\/JBApplyAuth.do"}
