Data Architect

Koniag Management Solutions, LLC is seeking an experienced Data Architect with an active Secret security clearance to support KMS and our government customer in Huntsville, AL. This is an onsite position that offers 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.

Requirements

• 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.

Benefits

• Health, dental, and vision insurance
• 401K with company matching
• Flexible spending accounts
• Paid holidays
• Three weeks paid time off