Data Architect

Koniag Management Solutions LLC Koniag Government Services is seeking an experienced Data Architect with an active Secret security clearance to support KMS and our government customer in Huntsville is an onsite 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 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 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 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 strategiesAssign 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 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 or capable of obtaining within 6 months Security CE and a government approved computing education certification consistent with primary communication leadership and project management to collaborate effectively with the Lead Architect stakeholders and cross-functional 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 such as: Google Professional Data EngineerCertified 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 PolicyThe 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 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 by calling to request 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 Opportunity Employer/Veterans/Disabled. Shareholder Preference in accordance with Public Law 88-352