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 onsite 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
Must have a bachelor’s degree and 5 years of experience in data science, analytics, or business intelligencePrefer technical lead or team lead experienceDeep expertise in SQL Server, SSIS, and Power BIStrong understanding of Active Directory for role‑based access controlArchitect and optimize SQL Server databases and SSIS ETL pipelines for performance and scalabilityAbility to architect end‑to‑end data solutions and guide technical direction for complex data schemasExperience with Azure Data Factory and Microsoft Fabric for cloud‑based data orchestrationExcellent communication skills for stakeholder engagement and executive presentationsBachelor’s or Master’s degree in Data Science, Computer Science or related fieldNice to Have
Familiarity with Azure Synapse, Databricks or Delta LakeMicrosoft certifications (e.g., Azure Data Scientist Associate, Power BI)Exposure to CI / CD pipelines and DevOps practices for data workflowsProficiency in Python for statistical modeling and machine learningClearance Requirement
Must be eligible to obtain a U.S. Public Trust ClearanceWe Offer
Competitive salary based on experienceProfit sharing distributed twice a year15 days of paid time off and 10 paid holidays per year401(k) with employer matchingHealth and dental benefitsOpportunity to work with other talented technical professionalsSharePointXperts 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.
#J-18808-Ljbffr