Data Architect - DA 25-25076

Overview

Remote
Depends on Experience
Accepts corp to corp applications
Contract - W2
Contract - Independent
No Travel Required

Skills

Specification Gathering
Workflow
Reporting
Scala
Snow Flake Schema
Software Engineering
Mentorship
Git
Good Clinical Practice
Google Cloud Platform
Informatica
Database
Database Architecture
Data Architecture
Data Engineering
Data Processing
Collaboration
Microsoft Azure
Oracle
Orchestration
Python
SQL
ELT
Emerging Technologies
Extract
Transform
Load
Java
Leadership
Microsoft
Continuous Delivery
Continuous Integration
Dashboard
Data Modeling
Data Quality
Agile
Amazon Web Services
Analytics
Apache Airflow
Cloud Computing
Storage

Job Details

Job Title: Data Architect
Location: Remote (NY-based candidates preferred)
Duration: 1 Year

Job Overview:

A skilled Data Architect is sought to help build and maintain scalable, secure, and efficient data pipelines and infrastructure using a Cloud Data Platform. The successful candidate will work under the direction of data engineering leadership, contributing to modern data architecture, infrastructure-as-code practices, and automated CI/CD processes. This is a senior-level role requiring deep technical expertise and leadership in cloud-based data solutions.

Scope of Services / Responsibilities:

  • Collaborate with stakeholders to gather data requirements and translate them into technical specifications.

  • Design and implement scalable data architectures to meet the needs of high-volume data processing.

  • Build, maintain, and optimize robust ETL/ELT pipelines and data models.

  • Partner with other data engineering teams to create reusable tools and frameworks.

  • Monitor, troubleshoot, and fine-tune data processes to ensure high performance and availability.

  • Safeguard data quality and consistency across multiple systems and data sources.

  • Stay informed about emerging technologies and recommend improvements to existing pipelines and workflows.

  • Mentor junior engineers by conducting code reviews and promoting best practices in data engineering.

Mandatory Skills / Experience:

Note: Only candidates who meet all of the following criteria will be considered.

  • 12+ years of hands-on data engineering experience.

  • Expert in Snowflake data modeling and schema design.

  • Strong experience defining Snowflake database objects for optimized storage and retrieval.

  • Advanced proficiency in SQL and at least one programming language: Python, Java, or Scala.

  • Deep knowledge of cloud platforms such as AWS, Azure, or Google Cloud Platform, with hands-on experience in:

    • Cloud storage

    • Compute resources

    • Data processing services

  • Proven ability to develop and maintain ETL/ELT pipelines at production scale.

  • Solid grasp of data modeling concepts and best practices in database architecture.

  • Experience in Agile environments and working with cross-functional teams.

  • Experience with workflow orchestration tools such as Apache Airflow or Dagster.

  • Strong knowledge of Git, CI/CD workflows, and automation pipelines.

  • Familiarity with dashboards and reporting tools, including:

    • Oracle Analytics Server (OAS)

    • Microsoft Power BI

    • Google Looker

  • Experience integrating data using tools such as:

    • Informatica Intelligent Cloud Services

    • MuleSoft

  • Expertise with Azure services, including:

    • Blob Storage

    • Data Lake

    • Azure Databricks

    • Azure Data Factory

    • Azure Security and Monitoring

  • Holds one of the following certifications (or similar):

    • Microsoft Certified Azure Solutions Architect Expert

    • SnowPro Certification

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.