Big Data Architect

Drevol LLC

Washington, DC

JOB DETAILS
JOB TYPE
Temporary, Contractor, Full-time
SKILLS
Amazon Web Services (AWS), Analysis Skills, Apache, Automation, Big Data, Business Processes, Centers for Disease Control and Prevention (CDC), Cloud Computing, Communication Skills, Computer Science, Continuous Deployment/Delivery, Continuous Integration, Customer Support/Service, Data Analysis, Data Collection, Data Lake, Data Management, Data Migration, Data Modeling, Data Processing, Data Storage, Data Warehousing, DataArchitect Data Modeling Tool, Database Administration, Database Design, Database Extract Transform and Load (ETL), Database Technology, Detail Oriented, Distributed Computing, Enterprise Architecture, Environmental Economics, Equipment Maintenance/Repair, Forecasting, GitHub, Identify Issues, Information Architecture, Information Technology & Information Systems, Java, JavaScript, Large-Scale Systems, Linux Operating System, Machine Learning, Microsoft SQL Server, Microsoft Windows Azure, MySQL, NoSQL, Perl Programming Language, PostgreSQL, Presentation/Verbal Skills, Problem Solving Skills, Python Programming/Scripting Language, R Programming Language, Relational Databases (RDBMS), Root Cause Analysis, SQL (Structured Query Language), Scala Programming Language, Scripting (Scripting Languages), Software Engineering, Source Code/Configuration Management (SCM), Storage Architecture, Structured Data, Test Plan/Schedule, Unstructured Data, Writing Skills
LOCATION
Washington, DC
POSTED
1 day ago
Work Experience: Data Architect/Engineer

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.
 
Technical Skills & Qualifications
Education & Experience
  • Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related technical field.
  • At least 7 years of related experience (advanced degree preferred).
Data Architecture & Engineering
  • 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 (e.g., Apache Airflow, Prefect, Dagster, or AWS Step Functions).
  • 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.
  • Experience implementing data warehouses utilizing Change Data Capture (CDC) methodologies.
Programming & Databases
  • 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.
  • Working knowledge of additional programming and scripting languages such as Java, Scala, JavaScript, or Perl.
  • Experience with NoSQL and graph database technologies.
Cloud, DevOps & Software Engineering
  • Working experience with cloud technologies such as AWS, Microsoft Azure, and Snowflake.
  • Experience migrating workflows and data pipelines between on-premises and cloud environments.
  • Experience implementing and maintaining CI/CD pipelines and DataOps platforms.
  • Strong hands-on software engineering and implementation experience, including the development, testing, and deployment of data applications and services.
  • Experience developing in Linux environments and using source control platforms such as GitLab and/or GitHub.
Data Analytics, ML & Domain Knowledge
  • Experience processing, analyzing, and integrating structured and unstructured data sources.
  • Experience performing root cause analysis on internal and external data and business processes to answer business questions and identify opportunities for improvement.
  • Understanding of time series data and related analytical and forecasting techniques.
  • Experience working in a research environment and/or with economic or financial data.
  • Experience developing, training, deploying, and maintaining machine learning models.
Soft Skills
  • Excellent oral and written communication skills with a strong customer service orientation.
  • Exceptional analytical, problem-solving, and troubleshooting skills.

About the Company

D

Drevol LLC