Azure Data Solutions Architect: Cloud Pipelines

Robotic Technologies Automation; Jefferson City (MO); On-site; USD 90,000 - 130,000; Full time

Job summary

ROBOTIC PROCESS AUTOMATION LLC seeks an experienced data engineer to design, develop, and maintain cloud-based data pipelines powering analytics and BI. The role emphasizes modernizing ETL/ELT, data ingestion, and databases to AWS/Azure while ensuring security and regulatory compliance.

You will collaborate with data scientists, analysts, and SMEs to translate requirements into scalable solutions, build robust data architectures, and optimize pipeline performance within a matrixed,

Qualifications

• 4+ years of experience in designing and implementing data warehouse and analytics solutions (on-premise and cloud).
• 3+ years of expertise in data warehousing concepts (ETL/ELT, data quality management, privacy/security, MDM).
• 3+ years of experience with cloud data and cloud-native data lakes/warehouses. Microsoft Azure services (Fabric Lakehouse, ADF, Data Factory, Synapse).
• 2+ years of experience in Python, Scala, or Java for distributed processing and analytics (Spark).
• Familiarity with CI/CD practices and tools such as Azure DevOps, Git, or Jenkins.

Responsibilities

• Provide technical leadership in modernizing legacy data ingestion, ETL/ELT, and databases to cloud technologies (AWS/Azure).
• Implement data access, classification, and security patterns that comply with regulatory standards (PII, locational data, contractual obligations).
• Build relationships with technical teams through effective communication and collaboration.

Skills

Azure Data Factory

Azure Synapse

Databricks

Python

Scala/Java

Spark

CI/CD

Azure DevOps

Git

SSIS

Tools

Databricks

SSIS

Job description

ROBOTIC PROCESS AUTOMATION LLC seeks an experienced data engineer to design, develop, and maintain cloud-based data pipelines powering analytics and BI. The role emphasizes modernizing ETL/ELT, data ingestion, and databases to AWS/Azure while ensuring security and regulatory compliance.

You will collaborate with data scientists, analysts, and SMEs to translate requirements into scalable solutions, build robust data architectures, and optimize pipeline performance within a matrixed,