CDC Foundation is hiring a
Systems Architect

Summary

Join the CDC Foundation as a Systems Architect in a remote, limited-term opportunity. The role involves designing and overseeing the implementation of complex technical solutions for a public health organization, specifically focusing on data warehouse architecture within the Louisiana Department of Health, Office of Public Health. The salary range is $103,500-$143,500 per year plus benefits.

Requirements

• Bachelor’s degree in computer science, Information Technology, or a related field (or equivalent)
• 5+ years in data systems architecture, design, implementation and data warehouse architecture experience
• Deep knowledge of system architecture, modern architectural patterns, cloud-based solutions, and security best practices
• Extensive experience with SQL Server, Oracle, PostgreSQL, Snowflake; performance tuning, backup/recovery, and security management
• Proficiency in ETL tools, data modeling, and database performance tuning; experience with orchestration tools like Apache Airflow, and integration tools such as SSIS, Talend, or Informatica
• Hands-on experience with programming languages (Python, Java, JavaScript), modern JavaScript frameworks ( Node.js , React, Vue), and mobile development
• Experience in designing and writing automated test scripts for unit, integration, and end-to-end testing
• Expertise in feasibility studies, system architecture reviews, and developing solutions for complex, multi-year plans
• Ability to resolve complex integration and technical issues and adapt to evolving project requirements
• Strong analytical thinking, communication, and teamwork abilities; experience working in diverse, virtual environments

Responsibilities

• Develop and implement scalable and efficient data warehouse architectures that support business intelligence, analytics, and reporting needs
• Design and manage Extract, Transform, Load (ETL) processes to ensure data integration and consistency across multiple sources
• Define data models, schemas, and database structures to optimize data storage and retrieval
• Collaborate with data architects to design and implement scalable and secure data storage solutions, including data warehouses and data lakes
• Recommend and implement new technologies, tools, and frameworks to enhance system performance, scalability, and reliability
• Provide expertise and leadership in technology architecture with a focus on technical (including infrastructure and networks) and application architecture, strategy, road mapping, and methodology
• Contribute to and manage the planning, design, delivery and implementation of user-centric solutions related to large scale, complex products required to meet critical business requirements
• Monitor the management and maintenance of SQL Server databases ensuring optimal performance, security, and data integrity
• Monitor and tune SQL Server performance including query optimization, indexing, and partitioning
• Perform system performance tuning, capacity planning, and scalability assessments
• Ensure security, compliance, and regulatory requirements are integrated into the system architecture
• Provide technical support and troubleshooting for systems and data warehouse - related issues, collaborating with IT teams and end-users to resolve problems promptly
• Document system configurations, procedures, and troubleshooting steps for reference and knowledge sharing
• Stay updated with industry trends and advancements in systems and data warehousing technologies to recommend improvements and innovations
• Identifies proactive measures to reduce incidents of failure and to increase sustainability and maintainablity of data systems
• Evaluate existing systems and technologies to identify opportunities for improvement and optimization
• Develop and maintain automated data pipelines using DevOps/DataOps principles and tools (e.g., Git, CI/CD pipelines)
• Automate data tasks and processes to improve efficiency and reduce manual errors, leveraging scripting languages and automation tools