Senior Data Engineering Administrator (D365/Azure)

Job Title: Senior Data Engineering Administrator (D365/Azure)
Location: Washington, DC (Hybrid Onsite 4 days/week)
Rate: $80

Job Description

CFSA is seeking a Senior Data Engineering Administrator with expertise in Dynamics 365 and Azure to provide high-level data engineering administration support. This role will focus on managing Dataverse, Azure Data Factory, Synapse Analytics/SQL, and Power BI environments while ensuring data integrity, security, and scalability across platforms. The ideal candidate will lead data operations, reporting, and governance activities while mentoring and coordinating a team of Data Analysts and Report Engineers.

Responsibilities:

• Provide Dataverse data management support including schema integrity, TDS Endpoint configuration, data extraction, queries, and backup/restore.
• Design, monitor, and troubleshoot Azure Data Factory pipelines for secure ingestion, transformation, orchestration, and performance.
• Manage Azure Synapse workspaces (Dataverse Link, SQL pools, Serverless SQL), optimizing queries for analytics/reporting.
• Setup and maintain Power BI workspaces, datasets, and gateways, enforcing data security (including row-level security).
• Develop Power BI dashboards leveraging system log datasets for usage analytics.
• Build and refine complex SQL queries for operational, audit, and performance reporting.
• Create reusable Python scripts for parsing, cleansing, enrichment, and automation (structured & unstructured data).
• Develop/maintain data security policies across Azure data services.
• Provide data models, schema/table diagrams to support integrations and data exchange.
• Manage data replication from Dynamics to Synapse (Dedicated SQL pool, Serverless, API-enabled endpoints).
• Support legacy Oracle database management, ensuring availability, backup, and data integrity.
• Collaborate with stakeholders to define data requirements, mappings, and transformations.
• Lead and coordinate Data Analysts and Report Engineers for timely execution of data-dependent reporting tasks.
• Perform data profiling and quality analysis to identify risks and gaps.
• Define and enforce data migration standards, governance, and best practices.
• Maintain technical artifacts including replication plans, data architecture, and error reports.
• Conduct training and guidance sessions for business and QA staff.
• Stay updated with industry trends to recommend improvements for data governance.

Required Skills & Experience:

• Strong hands-on experience with Dynamics 365 Dataverse management.
• Advanced skills in Azure Data Factory, Synapse Analytics (SQL Pools, Serverless), and SQL optimization.
• Proficiency in Power BI administration (workspaces, datasets, security, dashboards).
• Strong SQL development (queries, performance tuning, reporting).
• Experience with Python scripting for data parsing, cleansing, and automation.
• Solid understanding of data security, governance, and migration best practices.
• Knowledge of data replication tools and APIs for Dynamics-Synapse integrations.
• Experience with legacy Oracle database administration.
• Strong leadership skills to coordinate and mentor Data Analysts/Reports team.

Nice to Have:

• Experience in child welfare information systems or similar government/public sector systems.
• Prior work with audit/compliance reporting.