Data Architect

Job Overview

Custom Software Systems, Inc. (CSS) is seeking a Senior Data Architect/Engineer to support a critical data modernization initiative for our client. The selected candidate will play a key role in transforming legacy data environments into scalable, cloud-enabled data platforms that improve data accessibility, security, and analytical capabilities supporting research, forecasting, and data‑driven decision‑making.

The Senior Data Architect/Engineer will be responsible for designing and implementing enterprise data architectures, developing robust data integration and pipeline solutions, and optimizing data delivery processes across complex business and analytical environments. This role requires a hands‑on technical leader with expertise in data modeling, database architecture, ETL/ELT development, cloud technologies, and data governance. The ideal candidate will collaborate closely with business stakeholders, researchers, and technical teams to deliver innovative, secure, and scalable data solutions that advance organizational objectives and support next‑generation analytics initiatives.

• Analyze data processes, applications, and source data to understand dependencies, anomalies and implicit business rules that impact the division’s ability to manage data.
• 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 throughout the process.
• Architect and implement ETL/ELT workflows using modern data engineering tools and frameworks to support large‑scale data processing for economic analysis.
• Create data solution designs for economic policy and research projects, including conceptual models, integration models, and sourcing strategies, in alignment with the division’s research needs and data strategy.
• 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 that support analytics and visualization tools, increasing data accessibility and fostering data‑driven decision‑making across the organization.
• Implement processes and systems to monitor data quality, ensuring production data is accurate, reliable and available for end users and dependent business processes.
• Identify, design and implement internal process improvements, including automation of manual processes, optimization of data delivery and redesign of infrastructure to improve scalability and performance.
• Participate in the development of future‑state data architecture standards, guidelines and principles.
• Collaborate with important stakeholders to establish an understanding of the organization’s vast processes and data.
• Actively participate in process improvement initiatives and in setting best practice standards around Data Architecture, Metadata, Governance, Master Data Management and Data Quality flows.

• US Citizenship

• Minimum of ten (10) years’ experience developing data architecture and data engineering solutions at enterprise scale.
• Minimum of five (5) years’ experience of Data Warehouse Architecture.
• Minimum of five (5) years of experience with business intelligence technologies and solutions and leading teams on IT initiatives.
• Minimum of one (1) year of experience with cloud platforms such as AWS and Azure.
• Minimum of two (2) years’ experience working in an agile development environment.

• Well‑versed in data governance and management.
• Strong background in various types of data infrastructure and services.
• Experience building, optimizing and maintaining scalable databases, data pipelines and data processing frameworks.
• Experience with…