Data Architect

Ampcus Inc. • Washington DC, DC

12d • Onsite

About The Position

Ampcus Inc. is seeking a Data Architect to design, develop, and implement modern data infrastructure and analytical capabilities. This role focuses on enhancing economic forecasting and policymaking by modernizing legacy data environments. The program involves transforming legacy databases and data pipelines into integrated cloud platforms and enterprise data integration systems to improve data accessibility and security. The goal is to streamline workflows, enable timely economic insights, and support advanced analytical work, ensuring continued leadership in economic analysis and efficiency in meeting Congressional mandates.

Requirements

• Bachelor’s degree in computer science, Information Technology, Engineering or a related technical field and at least 7 years of related experience.
• Advanced working knowledge of SQL and experience working with relational database platforms including PostgreSQL, Microsoft SQL Server, and MySQL.
• Advanced working knowledge of Python, R, and other scripting languages used for data engineering and analytics.
• Experience working with large-scale data systems, including distributed computing, scalable data processing, data storage architecture, and optimization of high-volume data workloads.
• Experience designing, developing, and automating ETL/ELT workflows and data integration pipelines.
• Experience building, optimizing, and maintaining scalable databases, data pipelines and data processing frameworks.
• Experience with workflow orchestration and pipeline automation tools such as Apache Airflow, Prefect, Dagster, or AWS Step Functions.
• Experience migrating workflows and data pipelines between on-premises and cloud environments.
• Experience processing, analyzing, and integrating structured and unstructured data sources.
• Experience developing in Linux environments and using source control platforms such as GitLab and/or GitHub.
• Experience performing root cause analysis on internal and external data and business processes.
• Ability to design and communicate enterprise information architecture at conceptual, logical, and physical levels.
• In-depth experience designing and implementing database, data lake, and enterprise data platform solutions.
• Strong hands-on software engineering and implementation experience, including development, testing, and deployment of data applications and services.
• Excellent oral and written communication skills with a strong customer service orientation.
• Exceptional analytical, problem-solving, and troubleshooting skills.

Nice To Haves

• Advanced degree preferred.

Responsibilities

• Analyze data processes, applications, and source data to understand dependencies, anomalies, and implicit business rules.
• Review and analyze existing data models and processes to optimize and modernize current data architectures.
• Design, develop, and maintain robust data pipelines that ingest, transform, and deliver data from multiple sources to analytics platforms, ensuring optimal performance and data integrity.
• Architect and implement ETL/ELT workflows using modern data engineering tools and frameworks for large-scale data processing.
• Create data solution designs for economic policy and research projects, including conceptual models, integration models, and sourcing strategies.
• Translate division and section requirements into long-term information architecture solutions.
• Define specifications and implement database structures, including logical and physical data models, backup and recovery procedures, and access security controls.
• Develop and maintain formal documentation of data structures, data flows, data dictionaries, and technical metadata.
• Collaborate with research and business teams to improve data models and data processes, increasing data accessibility and fostering data-driven decision making.
• Implement processes and systems to monitor data quality, ensuring production data is accurate, reliable, and available.
• Identify, design, and implement internal process improvements, including automation of manual processes, optimization of data delivery, and redesign of infrastructure.
• Participate in the development of future-state data architecture standards, guidelines, and principles.

Benefits

• Ampcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veterans or individuals with disabilities.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior