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