Data Solution Architect

UNAVAILABLE; McLean (VA); On-site; USD 120,000 - 180,000; Full time

Job summary

UNAVAILABLE is seeking a seasoned Data Solution Architect to design enterprise-grade data platforms, pipelines, models, dashboards, and analytics. You will contribute across data vision, architecture, engineering, visualization, and data science, working with clients and teams to deliver scalable solutions.

The role emphasizes communication, customer service, and deep data expertise, spanning data lakes, warehouses, and lakehouse architectures with Databricks and related tools.

Qualifications

• 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 Databricks, Spark, Kafka, and related data tools.

Responsibilities

• Design greenfield data solution stacks in cloud or on-premises.
• Architect migration of legacy data environments for performance and reliability.
• Contribute to data architecture including sources, models, schemas, and workflows.
• Design ETL jobs, data pipelines, and workflows for data processing.
• Design reports and dashboards; select BI tools and enable data visualization.
• Support AI/ML applications; design MLOps pipelines and support data scientists.
• Address inquiries on data products, integration, and enterprise architecture.
• Craft data lakehouse solutions (Databricks) including databases, warehouses, lakes, and distributed systems.
• Communicate progress to technical and non-technical stakeholders.
• Support agile software development lifecycle and gather technical requirements.
• Contribute to growth of AI & Data Exploitation Practice!

Skills

Public trust clearance

Data architecture

Communication

Cloud data platforms

Agile

Data visualization

AI/ML pipelines

Education

Bachelor's degree

Tools

Databricks

Spark

Kafka

PostgreSQL

MySQL

MS SQL Server

Oracle

AWS (EC2,RDS,Redshift,Glue)

Storm

Python

Job description

Overview

We are looking for 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
• Data Architecture contributions include assessing and understanding historical and current data sources, data models and schemas, and data workflows
• Data Engineering contributions include assessing, understanding, and designing ETL jobs, data pipelines, and workflows
• BI and Data Visualization contributions include assessing, understanding, and designing reports, selecting BI tools, creating dynamic dashboards, and setting up data pipelines in support of dashboards and reports
• Data Science contributions include 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
• Experience in crafting data lakehouse solutions (Preferably Databricks). This includes relational databases, data warehouses, data lakes, and distributed data systems.
• Key must have skill sets – broad understanding of data exploitation lifecycle and capabilities and the ability to effectively communicate progress to technical and non-technical stakeholders
• Experiencing supporting each step within the Agile software development lifecycle and in gathering and executing upon technical requirements
• You will contribute to the growth of our AI & Data Exploitation Practice!

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 toools
  • 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 librarie0s), 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.