Data Architect

Role Overview: We are looking for an experienced, detail-oriented Data Architect/Engineer who will be excited by the prospect of optimizing or even re-designing the division’s data architecture to support our next generation of data initiatives. Key Responsibilities & Candidate Profile • :Architecture & Optimization: Expand and optimize our data and data pipeline architecture, as well as optimize data flow and collection for economic policy and research teams • .Hands-On Development: Act as a hands-on data modeler with working knowledge of database design and administration, data pipeline building, and data wrangling • .System Improvement: Take pride in improving existing data systems and/or building them from the ground up • .Support & Delivery: Support our economists and technical experts by ensuring optimal data delivery architecture is designed and developed • .Work Style: Must have a service mindset, be self-directed, and be comfortable supporting the data needs of multiple teams and systems . Qualifications & Experienc • e:Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related technical fiel • d.At least 7 years of related experience (advanced degree preferred ). Data Architecture & Engineeri • ng:Experience working with large-scale data systems, including distributed computing, scalable data processing, data storage architecture, and optimization of high-volume data workloa • ds.Experience designing, developing, and automating ETL/ELT workflows and data integration pipelin • es.Experience building, optimizing, and maintaining scalable databases, data pipelines, and data processing framewor • ks.Experience with workflow orchestration and pipeline automation tools (e.g., Apache Airflow, Prefect, Dagster, or AWS Step Function • s).Ability to design and communicate enterprise information architecture at conceptual, logical, and physical leve • ls.In-depth experience designing and implementing database, data lake, and enterprise data platform solutio • ns.Experience implementing data warehouses utilizing Change Data Capture (CDC) methodologi es. Programming & Databa • ses:Advanced working knowledge of SQL and experience working with relational database platforms (including PostgreSQL, Microsoft SQL Server, and MyS • QL).Advanced working knowledge of Python, R, and other scripting languages used for data engineering and analyt • ics.Working knowledge of additional programming and scripting languages such as Java, Scala, JavaScript, or P • erl.Experience with NoSQL and graph database technolog ies. Cloud, DevOps & Software Enginee • ring:Working experience with cloud technologies such as AWS, Microsoft Azure, and Snowf • lake.Experience migrating workflows and data pipelines between on-premises and cloud environm • ents.Experience implementing and maintaining CI/CD pipelines and DataOps platf • orms.Strong hands-on software engineering and implementation experience, including the development, testing, and deployment of data applications and serv • ices.Experience developing in Linux environments and using source control platforms such as GitLab and/or Gi tHub. Data Analytics, ML & Domain Know • ledge:Experience processing, analyzing, and integrating structured and unstructured data so • urces.Experience performing root cause analysis on internal and external data and business processes to answer business questions and identify opportunities for improv • ement.Understanding of time series data and related analytical and forecasting techn • iques.Experience working in a research environment and/or with economic or financial • data.Experience developing, training, deploying, and maintaining machine learning m odels. Soft • Skills:Excellent oral and written communication skills with a strong customer service orien • tation.Exceptional analytical, problem-solving, and troubleshooting skills.