PROGRAM OVERVIEW

The Data Architect (Microsoft SQL Server) role is a critical position focused on designing, implementing, and managing SQL Server-based data solutions. This role ensures that the organization’s data infrastructure is robust, scalable, and secure, aligning with business objectives. Responsibilities include database architecture, data integration, governance, security, performance optimization, and cloud integration when applicable.
We are looking for a Data Architect (Microsoft SQL Server) to join our team. In this role, you will be responsible for developing and managing SQL Server-based data solutions that support critical business functions. You will collaborate with stakeholders to create scalable and high-performance database architectures, optimize data processes, and ensure compliance with security and governance standards.

REQUIRED SKILLS & EXPERIENCE:

• Expertise in Microsoft SQL Server, T-SQL, SSIS, SSRS, and data modeling
• Experience with database performance tuning, indexing, and query optimization
• Knowledge of ETL processes, data warehousing, and cloud-based database solutions (Azure SQL Database)
• Familiarity with compliance frameworks such as GDPR and HIPAA
• Strong analytical, problem-solving, and communication skills

PREFERRED QUALIFICATIONS:

• Experience with Azure Data Factory, Power BI, and big data technologies
• Prior experience in government contracting or federal data environments
• Proficiency in automation tools for database maintenance and monitoring
  BENEFITS: ASI Government offers a comprehensive benefit package to our employees. Benefits can be viewed on our careers site.
  EQUAL OPPORTUNITY EMPLOYER: ASI Government is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, religion, color, national origin, gender, sexual orientation, gender identity, age, status as a protected veteran, or status as a qualified individual with a disability. To view the EEO Is the Law Poster, click here.
  PAY TRANSPARENCY NONDISCRIMINATION PROVISION: We will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant.
  E-VERIFY: ASI Government participates in E-Verify, a service of DHS and SSA. See the E-Verify Notice and Learn About your Right to Work here and here.
  REASONABLE ACCOMMODATIONS: ASI is committed to working with and providing reasonable accommodations to individuals with disabilities. If, because of a medical condition or disability, you need a reasonable accommodation for any part of the application process, please send an email at hr@asigovt.com or call 703-253-6300 and let us know the nature of your request

• Data Architecture & Design: Develop logical and physical data models, optimize normalization/denormalization strategies, and implement data warehouses.
• Database Administration: Deploy and configure SQL Server instances, optimize query performance, and manage backup/recovery processes.
• Data Integration & ETL: Design solutions for integrating data from multiple sources using SSIS, ETL pipelines, and Azure Data Factory.
• Governance & Security: Implement role-based access controls, encryption, and compliance with industry regulations like GDPR and HIPAA.
• Collaboration & Documentation: Engage with stakeholders to understand data requirements and maintain technical documentation.
• Cloud & Advanced Analytics: Integrate SQL Server with Azure Cloud, support BI tools such as Power BI, and assist with data visualization strategies.