Data Solution Architect

About the role

We are looking for a seasoned Data Solution Architect to work with our team and our clients to develop enterprise-grade data platforms, services, pipelines, data models, visualizations, and more!

The Data Solution Architect needs to be a technologist with excellent communication and customer service skills and a passion for data and problem solving. This role spans the spectrum of data capabilities, from data vision and strategy all the way through data science.

Responsibilities

• Designing greenfield data solution stacks in the cloud or on premises, using the latest data services, products, technology, and industry best practices
• Architecting migration of legacy data environments with performance and reliability
• Assessing and understanding historical and current data sources, data models and schemas, and data workflows
• Assessing, understanding, and designing ETL jobs, data pipelines, and workflows
• Assessing, understanding, and designing reports, selecting BI tools, creating dynamic dashboards, and setting up data pipelines in support of dashboards and reports
• Assessing, understanding, and designing machine learning and AI applications, designing MLOps pipelines, and supporting data scientists
• Addressing technical inquiries concerning customization, integration, enterprise architecture and general feature/functionality of data products
• Crafting data lakehouse solutions (preferably Databricks), including relational databases, data warehouses, data lakes, and distributed data systems

Qualifications

• Ability to hold a position of public trust with the US government
• Bachelor's degree and 10+ years of total experience
• 5+ years industry experience coding commercial software and a passion for solving complex problems
• 5+ years direct experience in Data Solutions with experience in tools such as:

• Big data tools: Databricks, Spark, Kafka, etc.
• Relational SQL databases, such as Postgres, MySQL, MS SQL Server, Oracle, etc.
• Data pipeline and workflow management within the cloud or big data tools
• AWS cloud services such as EC2, RDS, Redshift, Glue
• Data streaming systems: Storm, Spark-Streaming, etc.
• Data science tools/languages: Python (data preparation and analysis libraries), Databricks, etc.
• Advanced working SQL knowledge and experience working with relational databases, query authoring and optimization (SQL) as well as working familiarity with a variety of databases
• Experience with DBOps and MLOps frameworks and exposure/understanding of DevOps
• Experience with message queuing, stream processing, and highly scalable ‘big data’ data stores
• Experience manipulating, processing, and extracting value from large, disconnected datasets
• Experience manipulating structured and unstructured data for analysis
• Experience constructing complex queries to analyze results using databases or in a data processing development environment
• Experience with data modeling tools and process
• Experience architecting data systems (transactional and warehouses)
• Experience aggregating results and/or compiling information for reporting from multiple datasets
• Experience working in an Agile and fast-evolving mission environments
• Experience supporting project teams of developers and data scientists who build web-based interfaces, dashboards, reports, and analytics/machine learning models

Benefits

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 $140,000 to $180,000.