Cloud Data Engineer

Kavaliro; Napa (CA); On-site; USD 115,000 - 152,000; Full time

Job summary

Kavaliro in the United States is seeking a Cloud Data Engineer to design, implement, and manage data pipelines on Azure and other cloud platforms. You will collaborate with analysts and stakeholders to ensure secure, scalable data solutions and support data-driven decision making.

The role requires five years of Azure experience, Python and SQL expertise, strong communication, and on-site work in Napa, CA. The position offers direct hire, opportunities to mentor colleagues and influence security

Qualifications

• Bachelor's degree in Computer Science or closely related field.
• Five years of Azure migration experience.
• Proven experience using Python and SQL.
• Experience with Azure: Data Factory, Databricks, Data Lake Storage, SQL DW, Analysis Services, and PySpark.
• ETL experience in data warehouse with slowly changing dimensions.
• Experience building and optimizing big data pipelines and data sets.
• Ability to multi-task in a fast-paced environment.
• Familiarity with JIRA.
• Knowledge of laws and regulations relating to IT for financial institutions.
• Ability to work independently with limited supervision.
• Strong written and verbal communication skills.

Responsibilities

• Design and implement scalable and secure data pipelines and storage environments.
• Collaborate with analysts and stakeholders to understand data requirements and implement data solutions.
• Ensure data cleansing, mapping, and transformation per requirements.
• Build data pipelines to streamline ingestion, processing, and distribution.
• Load transformed data into data warehouses and analytics systems.
• Monitor and troubleshoot data environments for high availability and performance.
• Provide on-call support for production systems.
• Implement data security measures including encryption and access controls.
• Utilize analytics services to provide actionable insights.
• Maintain documentation of data procedures and architectures.
• Mentor IT staff on security best practices and emerging technologies.
• Collaborate on technology plans to enhance security posture.
• Manage relationship with System Integrator and review SOWs.

Skills

Azure migration

Python

SQL

Azure Data Factory

Databricks

Data Lake Storage

SQL DW

Analysis Services

PySpark

ETL

Big data pipelines

JIRA

Regulatory knowledge

Communication skills

Independent worker

Education

Bachelor's degree in Computer Science

Job description

Pay Rate: $115,037 to $151,561 annually commensurate with experience

Location: M-F onsite in Napa, CA

JOB DESCRIPTION

Our client is seeking a Cloud Data Engineer for a direct hire opportunity. The Cloud Data Engineer’s responsibilities include designing, implementing, and managing data solutions on Microsoft Azure and other cloud platforms. Oversee the creation and maintenance of data pipelines, storage solutions, processing, analysis, and integration to facilitate data-driven decision-making. This role requires a combination of technical skills, analytical problem-solving, and collaboration with cross-functional teams to achieve data-driven goals.

DUTIES

• Design and implement scalable and secure data processing pipelines and storage environments using cloud services and tools.
• Collaborate with technical analysts, business analysts, and line of business stakeholders to understand data requirements and implement appropriate data solutions.
• Ensure data is cleansed, mapped, transformed, and otherwise optimized for storage and use according to business and technical requirements.
• Build effective data pipelines and workflows to streamline data ingestion, processing, and distribution tasks.
• Load transformed data into storage and reporting structures in destinations including data warehouse, reporting systems and analytics applications.
• Monitor and troubleshoot issues with the data environment to maintain high availability and performance.
• Provide on-call support for critical production systems.
• Implement data security measures, including encryption, access controls, and auditing, to protect sensitive information.
• Utilize analytics services to provide actionable insights and support data-driven decision-making.
• Maintain effective documentation regarding data procedures, systems, and architectures to maintain clarity and ensure compliance with regulatory standards.
• Mentor IT staff on security best practices and emerging technologies.
• Participate in continuous learning to stay current with cybersecurity advancements.
• Collaborate with colleagues to draft technology plans that enhance security posture.
• Manage the relationship with the System Integrator.
• Review Statements of Work (SOWs), deliverables, and invoices.
• Measure SI performance against KPIs and SLAs.
• Resolve contractual or delivery issues.

REQUIREMENTS

• The ideal candidate has a combination of education and experience equivalent to a bachelor’s degree in computer science or closely related field
• Minimum of five years of Azure migration experience.
• Proven experience using data processing languages such as Python and SQL.
• Experience with Azure: Data Factory, Databricks, Data Lake Storage, SQL DW, Analysis Services, and API – PySpark.
• ETL experience in a data warehouse environment using slowly changing dimensions.
• Experience building and optimizing ‘big data’ data pipelines, architectures, and data sets.
• Ability to multi-task in a fast‑paced environment.
• Familiarity with JIRA preferred.
• Current knowledge of laws, rules, and regulations pertaining to information technology relating to financial institutions.
• Ability to work independently with limited supervision.
• Ability to effectively interact and communicate with outside vendors and internal clients.
• Ability to communicate effectively both verbally and in writing.
• Ability to establish and maintain effective working relationships with a diverse group of people.