Senior Data Engineer (Azure/Dynamics 365)

OverviewShort Description: Client is looking for a resource to provide high-level data engineering administration expertise to support Dynamics 365/Azure data services, including Dataverse management, Azure Data Factory management, Synapse Analytics/SQL management, Power BI workspace.Complete Description: Client is seeking a Senior Data Engineering for managing and optimizing data services across Azure/Dynamics 365 and legacy Oracle Database environments. This role oversees Microsoft Dataverse, Azure Data Factory, Synapse Analytics, Power BI workspaces, and Oracle databases to ensure secure, compliant, and high-performance data operations. This position requires deep expertise in advanced SQL, database management, and database replication, including Health and human services data model experience. The candidate is responsible for design, build, and maintenance of scalable data pipelines, enforces privacy standards, and supports analytics teams with reliable, integrated data sets. The position involves cross-functional collaboration, architectural knowledge, and supporting program staff through data requests.ResponsibilitiesProvide Dataverse data management support to include schema integrity, TDS Endpoint configuration, Data extraction, query development, and data backup/restore operationsDesign, monitor, and troubleshoot scalable data pipelines in Azure Data Factory, with focus on secure ingestion, transformation, and orchestration, including monitoring and troubleshooting pipeline health and performanceManage Synapse workspaces (including Dataverse Link) and dedicated SQL pools/Managed SQL /Serverless SQLs, implementing advanced query optimization to support high-volume analytics and reporting workloadsSetup and maintain Power BI workspaces, datasets, and gateways, enforcing data security permissions including row-level securityDevelop Power BI Dashboards leveraging database datasets, including log files, to determine system usageDevelop and refine complex SQL queries to support operational and performance reporting, including audit system log analysisBuild and maintain reusable Python scripts for parsing datasets, data cleansing, enrichment, and automation, involving structured and un-structured dataDevelop and maintain data security for datasets across Azure data services platformProvide data model and schema/table relationship diagram to support integrations and data exchangeDevelop and maintain data replication tools to sync Dynamics data to Synapse Analytics, including managed SQL/Dedicated SQL pool, Serverless pool destination, and API-enabled data endpointsManage Legacy Oracle database, including data integrity, backup, and availability managementCollaborate with business stakeholders to understand data requirements, mapping, and transformation needs, ensuring alignment with the client information system's objectivesLead and coordinate Data Analysts and Reports Engineering Team activities, working closely with the system to ensure timely and accurate execution of data-dependent tasks, including Daily, Monthly, Weekly, Fiscal Year and Compliance reportingPerform data profiling and analysis to identify data quality issues, data gaps, and potential risks for mitigationDefine and enforce data migration standards, best practices, and governance policies to maintain data integrity and consistencyCreate and maintain technical artifacts for data services implementation, including replication plans, data, data architecture, rules, and error reportsConduct training sessions and provide guidance to business staff and Functional Quality Assurance staff on data services and provide data extraction supportStay current with industry trends and advancements in data management methodologies and tools, recommending improvements to enhance the overall data governance.SkillsBachelor’s degree in computer science, IT or related field or equivalent experienceOracle Database management and administration experiencesAdvanced SQL Query DevelopmentDatabase security administration, including row-level securityDatabase Replication expertise, including replication schedule, rules for automatic detection of schema and table changes and validation rep resultsHealth and Human Services Data model experienceProject management skills with the ability to prioritize tasks and meet deadlines, including documentation of technical artifactsProduce Data Model and Schema/Table link DiagramAzure Data services management including Data factory, Synapse AnalyticsPower BI Workspace Administration and Dashboard DevelopmentMicrosoft Azure Data Fundamentals certificationMicrosoft Certified Azure Administrator certificationPython scripting knowledgeFlexible work from home options available. #J-18808-Ljbffr