Talent.com
Microsoft SQL Architect

Microsoft SQL Architect

Bamboo SolutionsWashington, DC, US
6 days ago
Job type
  • Full-time
  • Quick Apply
Job description

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   Powered by JazzHR
  • Create a job alert for this search

    Architect • Washington, DC, US

    Related jobs
    • Promoted
    • New!
    Oracle SQL Developer with Public Trust

    Oracle SQL Developer with Public Trust

    VirtualVocationsWashington, District of Columbia, United States
    Full-time
    A company is looking for an Oracle SQL Developer to support the modernization of a legacy system.Key Responsibilities Design and develop Oracle PL / SQL packages, stored procedures, and functions f...Show moreLast updated: 1 hour ago
    • Promoted
    Data Engineer with GCP Certification

    Data Engineer with GCP Certification

    VirtualVocationsAlexandria, Virginia, United States
    Full-time
    A company is looking for a Data Engineer (Gen AI).Key Responsibilities Install and test Looker and Looker Studio extensions or API plugins Identify and deprecate unused Looker dashboards Enhanc...Show moreLast updated: 1 day ago
    • Promoted
    Provider Data Manager

    Provider Data Manager

    VirtualVocationsBaltimore, Maryland, United States
    Full-time
    A company is looking for a Provider Data Manager responsible for driving data quality initiatives and managing compliance reporting. Key Responsibilities Lead and develop a team while overseeing s...Show moreLast updated: 30+ days ago
    • Promoted
    Senior Data Manager

    Senior Data Manager

    Oceaneering International, Inc.Hanover, MD, United States
    Full-time
    Oceaneering Technologies (OTECH) develops, manufactures, and operates customized marine systems, shipboard equipment, subsea vehicles, and engineered solutions for commercial and U.Oceaneering Aero...Show moreLast updated: 5 days ago
    • Promoted
    Database Administrator

    Database Administrator

    Full Circle Solutions IncBaltimore, MD, US
    Full-time
    Overview : Design, create, implement and maintain databases in MS SQL and MS Access applications.Design disaster recovery plan for infrastructure and databases. Configure systems for high availabilit...Show moreLast updated: 30+ days ago
    • Promoted
    Senior Big Data Engineer

    Senior Big Data Engineer

    VirtualVocationsBaltimore, Maryland, United States
    Full-time
    A company is looking for a Senior Big Data Engineer to join their team.Key Responsibilities Support the transition from a monolithic application to loosely coupled microservices Ensure data is c...Show moreLast updated: 30+ days ago
    • Promoted
    • New!
    Data and Automation Lead

    Data and Automation Lead

    VirtualVocationsAlexandria, Virginia, United States
    Full-time
    A company is looking for a Data and Automation Lead to support program management, automation engineering, data configuration, data analytics, and reporting activities. Key Responsibilities Provid...Show moreLast updated: 11 hours ago
    • Promoted
    Database Administrator

    Database Administrator

    Crystal Management | CMITSpringfield, VA, United States
    Full-time
    At CMIT, we do more than provide real-world solutions.We deliver transformative results.Through cutting-edge technology and process innovations, we are changing how federal and commercial clients w...Show moreLast updated: 30+ days ago
    • Promoted
    Senior Business Intelligence Developer

    Senior Business Intelligence Developer

    VirtualVocationsAlexandria, Virginia, United States
    Full-time
    A company is looking for a Senior Business Intelligence Developer - Product & Platform Innovation.Key Responsibilities Collaborate with cross-functional teams to drive data enablement and support...Show moreLast updated: 30+ days ago
    • Promoted
    • New!
    Application Database Administrator

    Application Database Administrator

    VirtualVocationsBaltimore, Maryland, United States
    Full-time
    A company is looking for an Application Database Administrator to manage and optimize Oracle databases and applications remotely. Key Responsibilities : Administer and optimize Oracle databases and...Show moreLast updated: 17 hours ago
    • Promoted
    Data Engineer

    Data Engineer

    Crystal Management | CMITWashington, DC, United States
    Full-time
    At CMiT, we do more than provide real-world solutions.We deliver transformative results.Through cutting-edge technology and process innovations, we are changing how federal and commercial clients w...Show moreLast updated: 30+ days ago
    • Promoted
    ETL Data Architect

    ETL Data Architect

    VirtualVocationsBaltimore, Maryland, United States
    Full-time
    A company is looking for an ETL Data Architect to design and develop enterprise-wide application systems.Key Responsibilities Collaborate with business partners and teams to identify technical an...Show moreLast updated: 2 days ago
    • Promoted
    Data Team Lead

    Data Team Lead

    VirtualVocationsBaltimore, Maryland, United States
    Full-time
    A company is looking for a Head of Data to lead its data team and manage data infrastructure.Key Responsibilities Lead a data team while contributing hands-on technical expertise Manage the enti...Show moreLast updated: 1 day ago
    • Promoted
    Principal Database Programmer

    Principal Database Programmer

    VirtualVocationsBaltimore, Maryland, United States
    Full-time
    A company is looking for a Principal Database Programmer.Key Responsibilities Provide training and mentoring to (Senior) Database Programmers on CDMS systems and processes Plan client deliverabl...Show moreLast updated: 1 day ago
    • Promoted
    DataBricks Database Administrator

    DataBricks Database Administrator

    VirtualVocationsBaltimore, Maryland, United States
    Full-time
    A company is looking for a DataBricks Database Administrator (DBA).Key Responsibilities Modernize the data warehouse environment by migrating to Azure Databricks Architect, design, and perform o...Show moreLast updated: 2 days ago
    • Promoted
    PMP Certified Data Manager

    PMP Certified Data Manager

    VirtualVocationsBaltimore, Maryland, United States
    Full-time
    A company is looking for a Data Lead / Manager with PMP.Key Responsibilities Ensure seamless data transition from the legacy pension administration system to COPS 2. Enhance data quality and integri...Show moreLast updated: 2 days ago
    • Promoted
    Data Operations Associate

    Data Operations Associate

    VirtualVocationsBaltimore, Maryland, United States
    Full-time
    A company is looking for a Data Operations Associate-Client Ads.Key Responsibilities Maintain, audit, and improve advertiser and catalog data to support business growth Collaborate with Sales, C...Show moreLast updated: 1 day ago
    • Promoted
    ADABAS DB2 Database Specialist

    ADABAS DB2 Database Specialist

    VirtualVocationsBaltimore, Maryland, United States
    Full-time
    A company is looking for an ADABAS / DB2 Database Specialist to provide expert-level technical support in a remote setting. Key Responsibilities Plan, install, configure, and implement SAG ADABAS so...Show moreLast updated: 1 day ago
    • Promoted
    Geoprocessing and Database Analyst

    Geoprocessing and Database Analyst

    VirtualVocationsBaltimore, Maryland, United States
    Full-time
    A company is looking for a Project Management Support Analyst (Geoprocessing and Database).Key Responsibilities Collaborate in the implementation of project activities with federal, municipal, ac...Show moreLast updated: 1 day ago
    • Promoted
    SAS / SQL Data Analyst

    SAS / SQL Data Analyst

    VirtualVocationsBaltimore, Maryland, United States
    Full-time
    A company is looking for a SAS / SQL Data Analyst / Engineer - Claims / Healthcare.Key Responsibilities : Submit claim records and risk adjustment data to CMS while ensuring compliance and accuracy ...Show moreLast updated: 1 day ago