Data Architect

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

Job summary

Steampunk seeks a seasoned Data Architect to design and develop data models, warehouses, lakes, and lakehouses, along with governance, services, and pipelines. We want a technologist with strong communication and customer-service skills who is passionate about data.

You will lead migrations, document data sources, and craft cloud-based data platforms while supporting an Agile lifecycle and driving the Data Exploitation Practice forward.

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
• Experience designing storage and retrieval solutions for structured and unstructured data to support data science pipelines
• Experience designing data platforms for user consumption
• Experience supporting development of data artifacts (Data Dictionary, ER Diagrams, Data Flow Diagram, Data Quality Plan, Data Management Plan, Data Asset Catalog)
• Experience with SQL and relational databases, query development and optimization; familiarity with Oracle, SQL Server, PostgreSQL and others
• Experience programming in Python, R, Scala, or similar language
• Experience with relational SQL and NoSQL databases
• Experience with lakehouses and medallion architecture
• Familiarity with stream-processing systems (e.g., Storm, Spark-Streaming)
• Familiarity with AWS or Azure cloud technology and managed services (EC2, EMR, RDS, Redshift)
• Experience in DevSecOps environments with CI/CD practices
• Developing specifications for modern large-scale data repositories including cloud-based database solutions
• Familiarity with FIPS 140-2 encryption for data at rest and in motion
• Ability to translate customer requirements into technical solutions
• Collaborating with software and data science teams to operationalize information
• Collaborating with stakeholders, IT customers, and contractors at all levels
• Experience leading agile projects
• Bachelor's degree in computer science, information systems, engineering, business, or related field (or equivalent experience)

Responsibilities

• Lead and architect migration of data environments with performance and reliability
• Assess, understand, and document data sources
• Address inquiries concerning customization, integration, enterprise architecture, and data product functionality
• Craft data warehouse solutions in cloud environments (prefer AWS; Azure or GCP acceptable)
• Contribute to growth of the Data Exploitation Practice
• Support an Agile software development lifecycle

Skills

data modeling

cloud

SQL

Python/R/Scala

data governance

communication

customer service

Education

Bachelor's degree in computer science or related field

Tools

AWS

Azure

GCP

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.

Contributions

• 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

About steampunk

Steampunk relies on several factors to determine salary, including but not limited to geographic location, contractual requirements, education, knowledge, skills, competencies, and experience. The projected compensation range for this position is $125,000 to $175,000. The estimate displayed represents a typical annual salary range for this position. Annual salary is just one aspect of Steampunk’s total compensation package for employees. Learn more about additional Steampunk benefits here.

Identity Statement

As part of the application process, you are expected to be on camera during interviews and assessments. We reserve the right to take your picture to verify your identity and prevent fraud.

Steampunk is a Change Agent in the Federal contracting industry, bringing new thinking to clients in the Homeland, Federal Civilian, Health and DoD sectors. Through our Human-Centered delivery methodology, we are fundamentally changing the expectations our Federal clients have for true shared accountability in solving their toughest mission challenges. As an employee owned company, we focus on investing in our employees to enable them to do the greatest work of their careers - and rewarding them for outstanding contributions to our growth. If you want to learn more about our story, visit http://www.steampunk.com.

We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, or any other characteristic protected by law.Steampunk participates in the E-Verify program.