Senior Data Administrator/Architect (D365/Azure) Location: SE Washington, DC 20003 Contract: 12 months (possible extension)
Detail Description:
We are seeking a Senior Data Administrator/Architect to manage and optimize Dynamics 365/Azure data services—including Dataverse, Azure Data Factory, Synapse Analytics/SQL, Power BI workspaces, and legacy Oracle databases—to ensure secure, compliant, and high-performance data operations.
The role requires a Bachelor’s degree in Computer Science/IT (or equivalent) and deep expertise in Oracle Database Management and Administration, Advanced SQL Query Development, Database Security Administration (row-level security), and Database Replication. Experience with the Health and Human Services Data Model, strong Project Management skills with documentation of technical artifacts, and proficiency in Azure Data Services (Data Factory, Synapse Analytics) and Power BI Administration/Dashboard Development are essential. Microsoft Azure Data Fundamentals certification is required; Microsoft Certified Azure Administrator and Python scripting experience are highly desirable.
- Administer and optimize Dataverse, Azure Data Factory, Synapse Analytics/SQL, Power BI workspaces, and Oracle databases.
- Design, monitor, and troubleshoot scalable data pipelines and replication tools linking Dynamics 365 to Synapse Analytics and API endpoints.
- Develop and refine advanced SQL queries, Python scripts, and Power BI dashboards.
- Enforce data security (including row-level) and provide data models and schema diagrams to support integrations.
- Lead and coordinate data analysts/report engineering activities to meet reporting and compliance needs.
- Define and enforce data migration standards, governance, and best practices; maintain technical artifacts.
- Collaborate with stakeholders, conduct training sessions, and stay current with industry trends to enhance data governance.
Work Location: Hybrid remote in Washington, DC 20003