RQ07731 - Software Developer - Senior

Scope :

TheOPGT is developing PGTIMS a new Dynamics CE based solution thatwill modernize OPGT s legacy applications and systems. This projectrequires migrating historical data from the legacy solutions to anew data warehouse / lakehouse building all the new data assets inthe lakehouse and creating new PowerBIreports.

Deliverables :

Asa member of the reporting team you will be responsible deliver theMVP for reporting build the new data warehouse / lakehouse anddeliver the required reporting.

A highlevel list of deliverablesfor the data migration teamfollows :

• DataWarehouse Design : analyze business requirements and design anefficient data warehouse / lakehouse / golden layer on MicrosoftAzure
• DataIntegration and ETL : help develop and automate ETL processes toload data from Dynamics 365 CE and F&O into the new datawarehouse / lakehouse (bronze / silver / golden layers).

Help integratedata from diverse sources into the new datawarehouse.

• DataModeling : create logical and physical data models that align withthe project s reporting and analyticalneeds.
• DataSecurity and Governance : implement appropriate security controls toprotect sensitive data within the data warehouse andreports.
• Reportingand Visualization : develop reports dashboards and visualizations asper reporting MVP. Ensure the quality accuracy and integrity ofreports.
• PerformanceOptimization : finetune the data warehouse and reporting processesto optimize query performance and overall systemefficiency.
• Otherduties asassigned.

Requirements

Experienceand Skill SetRequirements :

MustHaves :

• PowerBI : Proficiency in Power BI including data modeling creatinginteractive reports and dashboards and utilizing advancedfeatures.
• ETL / MicrosoftAzure Synapse Analytics experience including its architecture datastorage options data ingestion mechanisms and securityfeatures.
• Dynamics365 CE and / or F&O report developmentexperience.

Nice toHave :

• Azurecloud certifications (e.g. Azure fundamentals Azure Power BI DataAnalystAssociate)
• Dynamics365certifications

Skill SetRequirements :

• DataWarehouse / Lakehouse Concepts : Strong understanding of datawarehousing principles including data modeling ETL processes dataintegration and datagovernance.
• MicrosoftAzure Synapse : Indepth knowledge and experience with Azure SynapseAnalytics including its architecture data storage options (e.

g. SQLData Warehouse Data Lake Storage) data ingestion mechanisms (e.g.Azure Data Factory) and securityfeatures.

• PowerBI : Proficiency in Power BI including data modeling creatinginteractive reports and dashboards configuring data gateways andutilizing advanced features such as DAX and PowerQuery.
• SQLand Query Optimization : Strong SQL skills for writing complexqueries optimizing database performance and troubleshooting queryperformance issues.

Understanding of indexing partitioning andquery executionplans.

• Developmentexperience with Dynamics 365 and understanding of the Common DataModel for Dynamics.
• Reportdevelopment experience for Microsoft Dynamics 365 CustomerEngagement (CE) and / or Finance and Operations(F&O)
• Familiaritywith version control systems (e.g. Azure Repos) and collaborationtools (e.g. Azure DevOps) for managing code tracking changes andcollaborating with teammembers.

PowerBI :

• Demonstratedexperience working Power BI creating interactive reports anddashboards configuring data gateways utilizing advanced featuressuch as DAX and PowerQuery.
• Experiencewith SSISSSRS

ETL / AzurePlatform :

• Experiencewith Azure Synapse Workspaces and / or Azure DataFactory
• Azurecloudcertifications

Dynamics365 :

Demonstratedsoftware development experience with PowerApps platform PowerAutomate Dynamics CE &F&O and producing reportsfromDynamics

SQL / DB :

• Demonstratedexperience with data manipulation languages (TSQL PL / SQL) datadefinition languages query performance analysis &tuning
• Demonstratedexperience with SQL Server Oracle Azure SQLDatabases

AzureDevOps :

Demonstratedexperience with Azure DevOps for version control managing codetracking changes and collaborating with teammembers.

Experience and Skill Set Requirements : Must Haves : Power BI : Proficiency in Power BI, including data modeling, creatinginteractive reports and dashboards and utilizing advanced features.

ETL / Microsoft Azure Synapse Analytics experience, including itsarchitecture, data storage options, data ingestion mechanisms andsecurity features.

Dynamics 365 CE and / or F&O reportdevelopment experience. Nice to Have : Azure cloud certifications(e.g. Azure fundamentals, Azure Power BI Data Analyst Associate)Dynamics 365 certifications Skill Set Requirements : DataWarehouse / Lakehouse Concepts : Strong understanding of datawarehousing principles, including data modeling, ETL processes,data integration, and data governance.

Microsoft Azure Synapse : In-depth knowledge and experience with Azure Synapse Analytics,including its architecture, data storage options (e.

g., SQL DataWarehouse, Data Lake Storage), data ingestion mechanisms (e.g.,Azure Data Factory), and security features. Power BI : Proficiencyin Power BI, including data modeling, creating interactive reportsand dashboards, configuring data gateways, and utilizing advancedfeatures such as DAX and Power Query.

SQL and Query Optimization : Strong SQL skills for writing complex queries, optimizing databaseperformance, and troubleshooting query performance issues.

Understanding of indexing, partitioning, and query execution plans.Development experience with Dynamics 365 and understanding of theCommon Data Model for Dynamics.

Report development experience forMicrosoft Dynamics 365 Customer Engagement (CE) and / or Finance andOperations (F&O) Familiarity with version control systems(e.

g., Azure Repos) and collaboration tools (e.g., Azure DevOps)for managing code, tracking changes, and collaborating with teammembers.

PowerBI : Demonstrated experience working Power BI,creating interactive reports and dashboards, configuring datagateways, utilizing advanced features such as DAX and Power Query.

Experience with SSIS, SSRS ETL / Azure Platform : Experience withAzure Synapse Workspaces and / or Azure Data Factory Azure cloudcertifications Dynamics 365 : Demonstrated software developmentexperience with PowerApps platform, Power Automate, Dynamics CE&F&O and producing reports from Dynamics SQL / DB : Demonstrated experience with data manipulation languages (T-SQL,PL / SQL), data definition languages, query performance analysis& tuning Demonstrated experience with SQL Server, Oracle, AzureSQL Databases Azure DevOps : Demonstrated experience with AzureDevOps for version control, managing code, tracking changes, andcollaborating with team members.