Senior Data Architect - Cloud Data Platform & Governance

Steampunk, Inc.; McLean (VA); On-site; USD 125,000 - 175,000; Full time

Job summary

Steampunk, Inc. is seeking a seasoned Data Architect to collaborate with clients and internal teams to architect and develop data models, warehouses, lakes, lakehouses, and governance frameworks.

You will drive migrations, document sources, and design cloud solutions (AWS preferred, Azure/GCP as alternatives), with a focus on data quality and scalable pipelines, in an Agile environment. This role requires strong communication and customer service skills, with a passion for data and problem

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
• Demonstrated on-the-job experience supporting the development of related 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 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

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)
• Support an Agile software development lifecycle
• You will contribute to the growth of our Data Exploitation Practice!

Skills

Data modeling

Cloud

SQL

Python

ETL

Education

Bachelor's degree in computer science or related field

Tools

AWS

Azure

GCP

SQL

NoSQL

Job description

Steampunk, Inc. is seeking a seasoned Data Architect to collaborate with clients and internal teams to architect and develop data models, warehouses, lakes, lakehouses, and governance frameworks.

You will drive migrations, document sources, and design cloud solutions (AWS preferred, Azure/GCP as alternatives), with a focus on data quality and scalable pipelines, in an Agile environment. This role requires strong communication and customer service skills, with a passion for data and problem