AHU Technologies Recruitment · 3 months ago
Senior Data Engineer (Azure/Dynamics 365)
Washington , DC 20009
Full-time
Hybrid
Senior Level
$60/hr - $67/hrAHU Technologies Recruitment is an IT consulting and staffing firm that provides solutions to meet the evolving needs of corporations in the United States. They are seeking a Senior Data Engineer to manage and optimize data services across Azure and Dynamics 365, ensuring secure and high-performance data operations while collaborating with analytics teams and business stakeholders.
AppsConsultingEnterprise Resource Planning (ERP)OutsourcingStaffing AgencyWeb Development
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
Qualification
Required
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
Benefits
Flexible work from home options available.
Company
AHU Technologies Recruitment
At AHU Technology, we specialize in IT consulting and permanent staffing, serving the dynamic IT needs of top United States corporations.
Founded in 2010
51-200 employees
H1B Sponsorship
AHU Technologies Recruitment has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (4)
2024 (4)
2022 (8)
2021 (5)
2020 (5)
Funding
Current Stage
Growth StageCompany data provided by crunchbase