Data Architect

Greetings from Skysoft Position: Data ArchitectLocation: Washington, DC Onsite -Local DMV Only (On-site work – Need only Locals and In-person interview might requireVisa: US Citizens (ONLYDuration: 12 MonthsPROJECT DESCRIPTION: Design, develop and implement modern data infrastructure and analytical capabilities to enhance economic forecasting and policymaking, with specific focus on modernizing legacy data environments. The program transforms legacy and proprietary databases, and fragmented data pipelines into integrated cloud platforms, enterprise data integration systems, and collaboration tools that improve data accessibility and security. These initiatives streamline workflows, enable timely economic insights, and support innovative analytical work. This modernization effort ensures continued leadership in economic analysis, promotes efficiency in meeting Congressional mandates, and supports adoption of advanced tools and best practices organization-widebackground: The Data Architecture, Technology, and Analytics (DATA) section is tasked with transforming how the Federal Reserve Board’s Division of Research & Statistics (R&S) ingests, organizes, uses, and visualizes dataThe Data Architecture, Technology, and Analytics (DATA) section is looking for an experienced detailed oriented Data Architect/Engineer who will be responsible for expanding and optimizing our data and data pipeline architecture, as well as optimizing data flow and collection for economic policy and research teams. The ideal candidate is an experienced hands-on data modeler with working knowledge of database design and administration, data pipeline building, and data wrangling who enjoys improving existing data systems and/or building them from the ground up. The Data Architect/Engineer will support our economists and technical experts and will ensure optimal data delivery architecture is designed and developed. They must have a service mindset, be self-directed, and be comfortable supporting the data needs of multiple teams and systems. The right candidate will be excited by the prospect of optimizing or even re designing the R&S division’s data architecture to support our next generation of data initiativesrequirements: The candidate shall possess the knowledge and skills set forth in the Technical Services BOA, Section 3.5 for labor category 3.5.9 Data Architect. The candidate shall also demonstrate the below knowledge and experienceanalyze 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 architecturedesign, 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 processArchitect and implement ETL/ELT workflows using modern data engineering tools and frameworks to support large-scale data processing for economic analysiscreate 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 solutionsDefine 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 metadateCollaborate 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 organizationImplement processes and systems to monitor data quality, ensuring production data is accurate, reliable, and available for end users and dependent business processesIdentify, design, and implement internal process improvements, including automation of manual processes, optimization of data delivery, and redesign of infrastructure to improve scalability and performanceParticipate in the development of future-state data architecture standards, guidelines, and Principlespecific Requirements and Skilbachelor’s degree in computer science, Information Technology, Engineering or a related technical field and at least 7 years of related experience; advanced degree preferreceadvanced working knowledge of SQL and experience working with relational database platforms including PostgreSQL, Microsoft SQL Server, and MySQLAdvanced working knowledge of Python, R, and other scripting languages used for data engineering and analyticexperience working with large-scale data systems, including distributed computing, scalable data processing, data storage architecture, and optimization of high-volume data workloadexperience designing, developing, and automating ETL/ELT workflows and data integration pipelineexperience building, optimizing, and maintaining scalable databases, data pipelines and data processing frameworkexperience with workflow orchestration and pipeline automation tools such as Apache Airflow, Prefect, Dragster, or AWS Step Functionexperience migrating workflows and data pipelines between on-premises and cloud environmentexperience processing, analyzing, and integrating structured and unstructured data sourceexperience developing in Linux environments and using source control platforms such as GitLab and/or GitHuBexperience performing root cause analysis on internal and external data and business processes to answer business questions and identify opportunities for improvementability to design and communicate enterprise information architecture at conceptual, logical, and physical levelIn-depth experience designing and implementing database, data lake, and enterprise data platform solutionstrong hands-on software engineering and implementation experience, including development, testing, and deployment of data applications and serviceexcellent oral and written communication skills with a strong customer service orientatioexceptional analytical, problem-solving, and troubleshooting skillexperience with NoSQL and graph database technologieworking experience with cloud technologies such as AWS, Microsoft Azure, and Snowflakexperience implementing data warehouses utilizing Change Data Capture (CDC) methodologiesexperience implementing and maintaining CI/CD pipelines and DataOps platformworking knowledge of additional programming and scripting languages such as Java, Scala, JavaScript