Cloud Data Engineer

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

Job summary

Kavaliro is seeking a Cloud Data Engineer to design, implement, and manage data solutions on Microsoft Azure and other cloud platforms in a direct-hire role in California. The candidate will oversee data pipelines, storage, processing, analysis, and integration to enable data-driven decisions.

The ideal candidate has 5+ years of Azure migration experience, strong Python and SQL skills, and experience with Data Factory, Databricks, and Data Lake Storage.

Qualifications

• Bachelor’s degree in computer science or a closely related field.
• Minimum 5+ years of Azure migration experience.
• Proven experience using Python and SQL.
• Experience with Azure: Data Factory, Databricks, Data Lake Storage, SQL DW, Analysis Services.
• ETL experience in a data warehouse environment and big data pipelines.

Responsibilities

• Design and implement scalable data processing pipelines and storage environments using cloud services.
• Collaborate with analysts and stakeholders to translate data requirements into solutions.
• Ensure data is cleansed, mapped, and transformed for storage and use.
• Build data pipelines and workflows for ingestion, processing, and distribution.
• Load transformed data into data warehouses and analytics applications.
• Monitor and troubleshoot data environments for high availability and performance.
• Provide on-call support for critical production systems.
• Implement data security measures including encryption, access controls, and auditing.
• Document data procedures and architectures to ensure clarity and regulatory compliance.
• Mentor IT staff on security practices and emerging technologies.
• Engage with a System Integrator and review SOWs, invoices, and KPIs.

Skills

Azure

Python

SQL

ETL

APIs

Big data

Security

Education

Bachelor's degree in Computer Science or related field

Tools

Azure Data Factory

Databricks

Data Lake Storage

SQL Data Warehouse

Analysis Services

PySpark

JIRA

Job description

Job Description Our client is seekding 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.

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

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 plus 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.
• Ability to prioritize tasks and projects using a browser -based tracking system.
• 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.
• Expereince working with an 'SI' (System Integrator)
• Experience managing of 500 - 800+ pipelines during a large-scale enterprise cloud migration

Kavaliro provides Equal Employment Opportunities to all employees and applicants. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws. Kavaliro is committed to the full inclusion of all qualified individuals. In keeping with our commitment, Kavaliro will take the steps to assure that people with disabilities are provided reasonable accommodations. Accordingly, if reasonable accommodation is required to fully participate in the job application or interview process, to perform the essential functions of the position, and/or to receive all other benefits and privileges of employment, please respond to this posting to connect with a company representative.

Job Requirements

On-Site