Full-Time

Systems Architect

Posted on 9/17/2024

CDC Foundation

CDC Foundation

1,001-5,000 employees

Supports public health initiatives and organizations

Government & Public Sector
Social Impact

Compensation Overview

$103.5k - $143.5kAnnually

Mid

Remote in USA

Must be based in the United States.

Category
Data Management
Data Engineering
Data & Analytics
Required Skills
Talend
Python
JavaScript
React.js
Git
Node.js
Java
Postgres
Vue.js
Oracle
Snowflake
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.
  • Develop and maintain data models, schemas, and structures to optimize data storage and retrieval.
  • 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 in 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 the 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 maintainability 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. Conduct feasibility studies and risk assessments for proposed architectural changes or initiatives.
  • Implement data governance tools and practices to ensure data quality, consistency, and compliance with relevant regulations.
  • Utilize data governance platforms (e.g., Collibra, Informatica, Alation) to manage metadata, data lineage, and data stewardship.

The CDC Foundation enhances public health by supporting the CDC, particularly in combating COVID-19 through community-based organizations (CBOs). It works with these CBOs to share important health information and ensure equitable vaccine access. The Foundation raises funds through donations and partnerships, which are used to support various public health initiatives, including educational programs and emergency responses. Its goal is to strengthen community health efforts and ensure that vital health resources reach those in need.

Company Stage

N/A

Total Funding

N/A

Headquarters

Atlanta, Georgia

Founded

1992

Growth & Insights
Headcount

6 month growth

0%

1 year growth

0%

2 year growth

0%
Simplify Jobs

Simplify's Take

What believers are saying

  • The Workforce Acceleration Initiative addresses public health data infrastructure needs.
  • The Foundation's storytelling podcast enhances public health communication and engagement.
  • New board appointments bring diverse expertise to the Foundation's leadership.

What critics are saying

  • Increased competition for funding may limit resources for CDC Foundation programs.
  • Reliance on private sector partnerships could pose reputational risks.
  • Evolving public health data needs may strain the Foundation's resources.

What makes CDC Foundation unique

  • The CDC Foundation uniquely bridges CDC with private-sector partners for public health initiatives.
  • It has launched over 700 global programs since its inception in 1995.
  • The Foundation consistently earns a 4-star rating from Charity Navigator for financial transparency.

Help us improve and share your feedback! Did you find this helpful?

INACTIVE