USASAC Unified IT Enterprise - Data Architect

Koniag Management Solutions, LLC Koniag Government Services is seeking an experience SQL Developer/Administrator with an active Secret security clearance to support KMS and our government customer in Huntsville, AL. This is an onsite position.

We offer competitive compensation and an extraordinary benefits package including health, dental and vision insurance, 401K with company matching, flexible spending accounts, paid holidays, three weeks paid time off, and more.

Koniag is seeking a highly skilled Data Architect or Associate Data Architect to design, implement, and manage enterprise-level data solutions. This role combines expertise in database administration, data architecture, and modern data technologies to support business intelligence, data migration, and cybersecurity initiatives. The ideal candidate will work closely with or under the guidance of a Lead Architect to ensure alignment with organizational goals and best practices. This role requires a strong background in SQL development, data modeling, data architecture, and cloud-based platforms, along with a proven ability to optimize database performance and ensure data security.

Note: Candidates with 3-5 years' experience may be considered for the Associate Data Architect role.

Key Responsibilities:

• Work with the Lead Architect to design and implement enterprise data architecture, including conceptual, logical, and physical data models.
• Guide and mentor Database Administrators and Developers in areas such as database optimization, security protocols, and troubleshooting.
• Assist in leading data migration projects from on-premises systems (SQL Server) to modern platforms such as Azure, Vantage, and Dataverse.
• Develop and maintain complex SQL functions, stored procedures, and queries for applications and business intelligence reporting.
• Optimize database performance, including indexing, querying, and normalization.
• Architect and manage ETL processes using tools like Azure Data Factory, and equivalent Microsoft stack technologies.
• Architect data models and data flows optimized for business intelligence reporting and dashboarding.
• Ensure database integrity, security, and compliance with industry standards (e.g., DISA, DoW).
• Collaborate with stakeholders to gather requirements and deliver solutions that align with business objectives.
• Maintain documentation, including schematics, configurations, performance metrics, user manuals, SOPs, and change management requests.
• Implement and maintain security provisions to guard against unauthorized updates, copying, or destruction of databases.
• Support risk management processes, including security technical implementation guides and plans of action and milestones.
• Act as a final escalation point for complex database incidents, providing expert analysis and resolution strategies
• Assign metadata tags, develop search strategies, and maintain a metadata library for data analytics.

Required Skills and Qualifications:

• BS in Computer Science and/or Computer Engineering or equivalent.
• At least 7 years of experience in database architecture design and development.
• Expertise in SQL development, including troubleshooting, debugging, and performance optimization.
• Strong knowledge of relational database management systems, indexing, querying, and normalization.
• Familiarity with integration patterns, SOA, REST, SOAP, and Enterprise Service Bus.
• Knowledge of database schemas such as star schemas, snowflake schemas, and other data modeling techniques.
• Have, or capable of obtaining within 6 months, Security+ CE, and a government approved computing education certification consistent with primary skills.
• Excellent communication, leadership, and project management skills.
• Ability to collaborate effectively with the Lead Architect, stakeholders, and cross-functional teams.

Preferred Qualifications and Certifications:

• Experience with cybersecurity data analysis and reporting.
• Knowledge of Agile methodologies and CI/CD pipelines.
• Familiarity with Vantage (Army), Advana (DOW), or similar analytical engines.
• Completion of Oracle Database SQL Exam (1Z0-071) is a plus.
• Certifications such as:
  • Google Professional Data Engineer
  • Certified Analytics Professional (CAP)
  • Certified Data Management Professional (CDMP)
  • The Open Group Architecture Framework (TOGAF)

Other responsibilities:

• Perform other duties as assigned by leadership team

Our Equal Employment Opportunity Policy
The company is an equal opportunity employer. The company shall not discriminate against any employee or applicant because of race, color, religion, creed, ethnicity, sex, sexual orientation, gender or gender identity (except where gender is a bona fide occupational qualification), national origin or ancestry, age, disability, citizenship, military/veteran status, marital status, genetic information or any other characteristic protected by applicable federal, state, or local law. We are committed to equal employment opportunity in all decisions related to employment, promotion, wages, benefits, and all other privileges, terms, and conditions of employment.

The company is dedicated to seeking all qualified applicants. If you require an accommodation to navigate or apply for a position on our website, please get in touch with Heaven Wood via e-mail at accommodations@koniag-gs.com or by calling 703-488-9377 to request accommodations.

Koniag Government Services (KGS) is an Alaska Native Owned corporation supporting the values and traditions of our native communities through an agile employee and corporate culture that delivers Enterprise Solutions, Professional Services and Operational Management to Federal Government Agencies. As a wholly owned subsidiary of Koniag, we apply our proven commercial solutions to a deep knowledge of Defense and Civilian missions to provide forward leaning technical, professional, and operational solutions. KGS enables successful mission outcomes for our customers through solution-oriented business partnerships and a commitment to exceptional service delivery. We ensure long-term success with a continuous improvement approach while balancing the collective interests of our customers, employees, and native communities. For more information, please visit www.koniag-gs.com .

Equal Opportunity Employer/Veterans/Disabled. Shareholder Preference in accordance with Public Law 88-352