Data Architect

Washington, DC
Full Time
SPX
Experienced

We are 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 within the Pension Benefit Guaranty Corporation (PBGC), an independent agency of the United States government. The team operates within the agency’s Information Technology Infrastructure Operations Department (ITIOD). The role is a part of the Digital Transformation Team providing engineering solutions in support of the PBGC ITIOD. This position is Hybrid with 3 days onsite per week at customer site in Washington DC.

This role requires on site work in Washington, D.C. at least 3 days per week with remote work the other days.
Key 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
Required Skills & Qualifications:
  • Must have a Bachelors degree and 5+ 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.
  • Bachelor’s or Master’s degree in Data Science, Computer Science, or related field.
Nice to Have:
  • 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:
  • Must be eligible to obtain a U.S. Public Trust Clearance
We offer:
  • Competitive salary based on experience
  • Profit sharing distributed twice a year
  • 15 days of paid time off and 10 paid holidays per year
  • 401(k) with employer matching
  • Health and dental benefits
  • Opportunity to work with other talented technical professionals

SharePointXperts is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability, or protected Veteran status. 
SharePointXperts participates in E-Verify. Click the following links for important information about our participation in this program and your rights.
https://www.e-verify.gov/sites/default/files/everify/posters/IER_RightToWorkPoster%20Eng_Es.pdf
https://www.e-verify.gov/sites/default/files/everify/posters/EVerifyParticipationPoster.pdf
 

Share

Apply for this position

Required*
Apply with Indeed
We've received your resume. Click here to update it.
Attach resume or Paste resume
Attach resume as .pdf, .doc, .docx, .odt, .txt, or .rtf (limit 5MB) or Paste resume

Paste your resume here or Attach resume file

150
Invitation for Job Applicants to Self-Identify as a U.S. Veteran
  • A “disabled veteran” is one of the following:
    • a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or
    • a person who was discharged or released from active duty because of a service-connected disability.
  • A “recently separated veteran” means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.
  • An “active duty wartime or campaign badge veteran” means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.
  • An “Armed forces service medal veteran” means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.
Veteran status


Human Check*