Data Architect

  • Washington, DC
  • Posted 4 hours ago | Updated 4 hours ago

Overview

Hybrid
$180,000 - $200,000
Full Time

Skills

SQL Server
SSIS
Power BI
Active Directory
Azure Data Factory
ETL
Azure Synapse
Databricks
Delta Lake

Job Details

Job Title: Data Architect

Location: WASHINGTON, DC, United States// Hybrid Remote (must be on-site 3 days per week)
Clearance Level Must Be Able to Obtain: Public Trust
Experience: 12+years Must

Job Description:

Client is seeking a strategic and technically adept Data Architect to drive enterprise analytics initiatives using the Microsoft data ecosystem. This role blends hands-on data science with leadership responsibilities, guiding a team in delivering scalable, secure, and actionable insights through tools like SQL Server, SSIS, Power BI, and Active Directory to develop and support SSIS/ETL Jobs and SQL Server databases pertaining to agency objectives and goals, public programs, education, research, and other initiatives. The role is a part of the Digital Transformation Team providing engineering solutions. This position is Hybrid with 3 days onsite per week at customer site in Washington DC.

Responsibilities:

  • Lead the design and deployment of predictive models and machine learning algorithms.
  • Architect and optimize SQL Server databases and SSIS ETL pipelines for performance and scalability.
  • Develop and oversee Power BI dashboards, ensuring alignment with business KPIs.
  • Manage secure data access and compliance using Active Directory roles and policies.
  • Mentor junior data scientists and analysts, fostering a culture of innovation and excellence.
  • Collaborate with cross-functional teams to translate business needs into data-driven strategies.
  • Establish best practices for data governance, quality assurance, and model lifecycle management.
  • Communicate insights through compelling visualizations and executive-ready storytelling.

Qualifications

  • Bachelor s or master s degree in data science, Computer Science, or related field.
  • 8+ years of experience in data science, analytics, or business intelligence.
  • Prefer technical lead or team lead experience.
  • Deep expertise in SQL Server, SSIS, and Power BI.
  • Strong understanding of Active Directory for role-based access control.
  • Architect and optimize SQL Server databases and SSIS ETL pipelines for performance and scalability.
  • Ability to architect end-to-end data solutions and guide technical direction for complex data schemas.
  • Experience with Azure Data Factory and Microsoft Fabric for cloud-based data orchestration.
  • Excellent communication skills for stakeholder engagement and executive presentations.

Preferred Qualifications:

  • Familiarity with Azure Synapse, Databricks, or Delta Lake.
  • Microsoft certifications (e.g., Azure Data Scientist Associate, Power BI).
  • Exposure to CI/CD pipelines and DevOps practices for data workflows.
  • Proficiency in Python for statistical modeling and machine learning.

Clearance Requirement:

All candidates must be eligible to obtain a U.S. Public Trust Clearance.

**This hybrid role requires a minimum of three on-site days per week in Washington, DC. **

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.