Senior Data Engineer (Azure/Dynamics 365) Job at Ahu Technologies, Washington DC

RXc1ckw4SmFqM04yekxsVURqRWZ5WWF6cmc9PQ==
  • Ahu Technologies
  • Washington DC

Job Description




Short Description :

Client is look 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.

 

  Responsibilities: 


  • Provide Dataverse data management support to include schema integrity, TDS Endpoint configuration, Data extraction, query development, and data backup/restore operations

  • Design, 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 performance

  • Manage Synapse workspaces (including Dataverse Link) and dedicated SQL pools/Managed SQL /Serverless SQLs, implementing advanced query optimization to support high-volume analytics and reporting workloads

  • Setup and maintain Power BI workspaces, datasets, and gateways, enforcing data security permissions including row-level security

  • Develop Power BI Dashboards leveraging database datasets, including log files, to determine system usage

  • Develop and refine complex SQL queries to support operational and performance reporting, including audit system log analysis

  • Build and maintain reusable Python scripts for parsing datasets, data cleansing, enrichment, and automation, involving structured and un-structured data

  • Develop and maintain data security for datasets across Azure data services platform

  • Provide data model and schema/table relationship diagram to support integrations and data exchange

  • Develop 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 endpoints

  • Manage Legacy Oracle database, including data integrity, backup, and availability management

  • Collaborate with business stakeholders to understand data requirements, mapping, and transformation needs, ensuring alignment with the client information system's objectives. 

  • Lead 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 reporting

  • Perform data profiling and analysis to identify data quality issues, data gaps, and potential risks for mitigation

  • Define and enforce data migration standards, best practices, and governance policies to maintain data integrity and consistency. 

  • Create and maintain technical artifacts for data services implementation, including replication plans, data, data architecture, rules, and error reports. 

  • Conduct training sessions and provide guidance to business staff and Functional Quality Assurance staff on data services and provide data extraction support 

  • Stay current with industry trends and advancements in data management methodologies and tools, recommending improvements to enhance the overall data governance. 

     

     

Skills:

· Bachelor’s degree in computer science, IT or related field or equivalent experience.

· Oracle Database management and administration experiences.

· Advanced SQL Query Development.

· Database security administration, including row-level security.

· Database Replication expertise, including replication schedule, rules for automatic detection of schema and table changes and validation rep results.

· Health and Human Services Data model experience.

· Project management skills with the ability to prioritize tasks and meet deadlines, including documentation of technical artifacts.

· Produce Data Model and Schema/Table link Diagram.

· Azure Data services management including Data factory, Synapse Analytics.

· Power BI Workspace Administration and Dashboard Development.

· Microsoft Azure Data Fundamentals certification.

· Microsoft Certified Azure Administrator certification.

· Python scripting knowledge.

 

Flexible work from home options available.


Compensation: $60.00 - $67.00 per hour



About Us

AHU Technologies INC. is an IT consulting and permanent staffing firm that meets and exceeds the evolving IT service needs of leading corporations within the United States. We have been providing IT solutions to customers from different industry sectors, helping them control costs and release internal resources to focus on strategic issues. 

AHU Technologies INC. was co-founded by visionary young techno-commercial entrepreneurs who remain as our principal consultants. Maintaining working relationships with a cadre of other highly skilled independent consultants, we have a growing number of resources available for development projects. We are currently working on Various projects such as media entertainment, ERP Solutions, data warehousing, Web Applications, Telecommunications and medical to our clients all over the world.

Job Tags

Hourly pay, Permanent employment, Full time, Work from home, Flexible hours,

Similar Jobs

Silver Sitters LLC

CNA/HHA Job at Silver Sitters LLC

 ...Part-time Description Hiring for All Shifts at this time! Silver Sitters is looking for caring and dependable CNA's/HHA's to provide care to our elderly clients. CNA/HHA's provide assistance with ADL's and including but not limited to; bathing, dressing... 

TBC Corporation

Service and Delivery Driver Job at TBC Corporation

 ...Additionally, TBC responds to the needs of consumers in search of total car care at more than 465 franchised tire and automotive service...  ...to talk to you! We are hiring newly experienced and seasoned delivery drivers. Our Service and Delivery Drivers are responsible for... 

Providence Health and Services

Clinical Pharmacist - Cancer Center Job at Providence Health and Services

 ...care focused on optimizing medication therapy outcomes, particularly in cancer care. The role requires a PharmD or Bachelor's in Pharmacy, California pharmacist licensure, and preferably acute care hospital experience or residency completion. This per diem position offers... 

Top Level Promotions

Work from Home Office Support Assistant Job at Top Level Promotions

 ...assisting with online research and product evaluations. Full training is provided for qualified candidates. Responsibilities may...  ...remote work from home Flexible hours (part-time or full-time) Paid training included Entry-level position with career growth... 

Dark Wolf Solutions

Software Developer/Data Engineer Job at Dark Wolf Solutions

Dark Wolf constructs and deploys data management and analytics solutions for the defense and intelligence communities. We're proud to boast a world-class engineering team that thrives on rolling up their sleeves to solve your mission's biggest challenges.Dark Wolf is...