Data Architect

UNAVAILABLE; McLean (VA); On-site; USD 140,000 - 190,000; Full time

Job summary

UNAVAILABLE Data Architect position involves designing data models, warehouses, lakes and governance for client projects with a focus on scalable, cloud-based architectures. The role seeks a technologist who communicates well and delivers practical data-driven solutions.

Responsibilities include migrations, source documentation, and building data platforms in cloud environments (AWS preferred; Azure/GCP viable) while advancing data quality and governance within an Agile setting.

Qualifications

• 8-10 years of experience with data model and data warehouse design, including schema design and entity relationship diagrams.
• 8-10 years of experience collaborating with management, personas, and engineers to support data quality efforts
• Demonstrated on-the-job experience with large-scale data migration
• Demonstrated on-the-job experience designing storage and retrieval solutions for both structured and unstructured data, in support of data science pipelines
• Demonstrated on-the-job experience designing data platforms for user consumption
• Familiarity with data artifacts: Data Dictionary, ER Diagrams, Data Flow Diagram, Data Quality Plan, Data Management Plan, Data Asset Catalog
• Demonstrated experience working with SQL and relational databases, query development and optimization (SQL) as well as working familiarity with Oracle, SQL Server, PostgreSQL, and others
• Demonstrated experience programming in Python, R, Scala, or similar language
• Experience with relational SQL and NoSQL databases
• Experience working with lakehouses and medallion architecture
• Familiarity with stream-processing systems: Storm, Spark-Streaming, etc.
• Familiarity with cloud technology, using AWS or Azure. Knowledge of managed service offerings (e.g. AWS EC2, EMR, RDS, Redshift) and demonstrated experience delivering in a cloud environment.
• Experience working in a DevSecOps environment, utilizing CI/CD best practices
• Demonstrated on-the-job experience developing specifications for modern large-scale data repositories including development of specifications for cloud-based database solutions
• Familiarity with FIPS 140-2 compliant encryption to both stored data and data in motion
• Demonstrated and understanding customer requirements and prioritize for maximum customer / user experience.
• Demonstrated experience working with software and data science teams to operationalize information
• Demonstrated experience collaborating with staff, IT customers, and other technical and non-technical staff and contractors at all levels
• Demonstrated experience working in an agile environment and leading agile projects
• Bachelor's degree in computer science, information systems, engineering, business, a scientific or technical discipline, or comparable professional experience

Responsibilities

• Lead and architect migration of data environments with performance and reliability
• Assess, understand, and document data sources
• Address technical inquiries concerning customization, integration, enterprise architecture and general feature / functionality of data products
• Experience in crafting database / data warehouse solutions in cloud (Preferably AWS. Alternatively Azure, GCP)
• Key must have skill sets – data modeling, cloud
• Support an Agile software development lifecycle
• You will contribute to the growth of our Data Exploitation Practice!

Skills

data modeling

cloud

SQL

Python

data quality

NoSQL databases

ETL

Agile

communication

Education

Bachelor's degree in computer science, information systems, engineering, business, a scientific or technical discipline

Tools

AWS

Azure

Redshift

RDS

Oracle

SQL Server

PostgreSQL

Job description

Overview

We are looking for seasonedData Architectto work with our team and our clients to architect and develop data models, data warehouses, lakes, and lakehouses, data governance, services, and pipelines. We are looking for a more than just a "Data Architect", but a technologist with excellent communication and customer service skills and a passion for data and problem solving.

Responsibilities

• Lead and architect migration of data environments with performance and reliability
• Assess, understand, and document data sources
• Address technical inquiries concerning customization, integration, enterprise architecture and general feature / functionality of data products
• Experience in crafting database / data warehouse solutions in cloud (Preferably AWS. Alternatively Azure, GCP)
• Key must have skill sets – data modeling, cloud
• Support an Agile software development lifecycle
• You will contribute to the growth of our Data Exploitation Practice!

Qualifications

• Ability to hold a position of public trust with the US government.
• 8-10 years of experience with data model and date warehouse design, including schema design and entity relationship diagrams
• 8-10 years of experience collaborating with management, personas, and engineers to support data quality efforts
• Demonstrated on-the-job experience with large-scale data migration
• Demonstrated on-the-job experience designing storage and retrieval solutions for both structured and unstructured data, in support of data science pipelines
• Demonstrated on-the-job experience designing data platforms for user consumption
• Demonstrated on-the-job experience supporting the development of related data artifacts
  • Data Dictionary
  • Entity Relationship Diagrams
  • Data Flow Diagram
  • Data Quality Plan
  • Data Management Plan
  • Data Asset Catalog
• Demonstrated experience working with SQL and relational databases, query development and optimization (SQL) as well as working familiarity with a variety of databases, such as Oracle, SQL Server, PostgreSQL, and others
• Demonstrated experience programming in Python, R, Scala, or similar language
• Experience with relational SQL and NoSQL databases
• Experience working with lakehouses and medallion architecture
• Familiarity with stream-processing systems: Storm, Spark-Streaming, etc.
• Familiarity with cloud technology, using AWS or Azure. Knowledge of managed service offerings (e.g. AWS EC2, EMR, RDS, Redshift) and demonstrated experience delivering in a cloud environment.
• Experience working in a DevSecOps environment, utilizing CI/CD best practices
• Demonstrated on-the-job experience developing specifications for modern large-scale data repositories including development of specifications for cloud-based database solutions
• Familiarity with FIPS 140-2 compliant encryption to both stored data and data in motion
• Demonstrated and understanding customer requirements and prioritize for maximum customer / user experience.
• Demonstrated experience working with software and data science teams to operationalize information
• Demonstrated experience collaborating with staff, IT customers, and other technical and non-technical staff and contractors at all levels
• Demonstrated experience working in an agile environment and leading agile projects
• Bachelor's degree in computer science, information systems, engineering, business, a scientific or technical discipline, or comparable professional experience