Azure Data & Analytics Architect

Cloud Analytics Technologies, LLC; Jefferson City (MO); On-site; USD 110,000 - 150,000; Full time

Job summary

CLOUD ANALYTICS TECHNOLOGIES is seeking an experienced data professional to design, develop, and maintain cloud-based data pipelines and analytics solutions. The role centers on modernizing ingestion, ETL/ELT processes, and data storage while ensuring security and regulatory compliance across distributed cloud environments.

You will partner with data scientists, analysts, and business partners to translate requirements into scalable architectures, implementing robust testing, documentation, and

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) with hands-on experience using ADF, Data Factory, SSIS, and related tools.
• 3+ years of experience with cloud data and cloud-native data lakes/warehouses. Microsoft Azure services (Fabric Lakehouse, ADF, Data Factory, Synapse, etc.).

Responsibilities

• Provide technical leadership in modernizing legacy data ingestion, ETL/ELT, and databases to cloud technologies (AWS/Azure).
• Demonstrate a self-driven, ownership mindset to navigate ambiguity, resolve constraints, and mitigate risks with minimal supervision.
• Implement data access, classification, and security patterns that comply with regulatory standards (PII, locational data, contractual obligations, etc.).
• Build strong relationships with technical teams through effective communication, presentation, and collaboration skills.
• Collaborate with stakeholders, business analysts, and SMEs to translate business requirements into scalable solutions.
• Integrate data from multiple sources into cloud-based architectures, collaborating with cross-functional teams.
• Work closely with data scientists, analysts, and stakeholders to meet data requirements with high-quality solutions.
• Function within a matrixed team environment, sharing responsibilities across various teams.
• Perform data profiling and analysis on both structured and unstructured data.
• Design and map ETL/ELT pipelines for new or modified data streams, ensuring integration into on-prem or cloud-based data storage.
• Automate, validate and maintain ETL/ELT processes using technologies such as Databricks, ADF, SSIS, Spark, Python, and Scala.
• Proactively identify design, scope, or development issues and provide recommendations for improvement.
• Conduct unit, system, and integration testing for ETL/ELT solutions, ensuring defects are resolved.
• Create detailed documentation for data processes, architectures, and workflows.
• Monitor and optimize the performance of data pipelines and databases.

Skills

Azure data services

ADF / Data Factory

Azure Synapse

ETL/ELT design

Python / Spark

CI/CD with DevOps

Tools

Databricks

SSIS

Spark

Python

Azure DevOps

Git

Jenkins

Job description

CLOUD ANALYTICS TECHNOLOGIES is seeking an experienced data professional to design, develop, and maintain cloud-based data pipelines and analytics solutions. The role centers on modernizing ingestion, ETL/ELT processes, and data storage while ensuring security and regulatory compliance across distributed cloud environments.

You will partner with data scientists, analysts, and business partners to translate requirements into scalable architectures, implementing robust testing, documentation, and