Exavalu is a US based consulting firm specialized in Digital Transformation Advisory and Digital Solution Delivery for select industries like Insurance, Healthcare and Financial Services. Our Headquarters is in California, US with multiple offices across US, Canada, and delivery centers in India. We were founded by Industry executives and Consulting principals with deep industry experience that allows us to bring advisory strength and solution expertise to clients. We’re in a hyper growth trajectory growing at over 100% year on year.

Join our diverse and inclusive team where you will feel valued and motivated to contribute with your unique skills and experience.

This is a remote position.

Data Warehouse Engineer

Experience: 5+ relevant exp

Roles & responsibilities:

Collaborate with analytics and business teams to improve data models that feed business intelligence tools, increasing data accessibility and fostering data-driven decision making across the organization.

Build and implement scalable solutions that align to our data governance standards and architectural roadmap for data integrations, data storage, reporting, and analytic solutions.

Design and develop data integrations and a data quality framework. Write unit/integration/functional tests and document work.

Perform data analysis required to troubleshoot data-related issues and assist in the resolution of data issues.

Requirements

Required Skills:

Experience with a variety of database technologies and data warehouse schema design patterns (snowflake and star in particular). Design and Development experience of an EDW,

Experience with cloud-based databases, specifically AWS technologies (e.g., Redshift, RDS, S3, EMR, EC2, Kinesis) is a plus.

Experience using SQL queries as well as writing and optimizing SQL queries in a business environment with large-scale, complex datasets.

Experience creating ETL and/or ELT jobs.

Experience with Agile software development methodologies.

Excellent problem solving and troubleshooting skills.

Process oriented with great documentation skills.

Proficient in object-oriented programming (Python in particular).

Experience with DevOps methodologies and tools (e.g., Git, Artifactory, etc.).

Experience developing in a Unix/Linux environment.

Experience a plus developing integrations across multiple systems and APIs .

Experience a plus with Big Data tools like Spark, Hadoop, Kafka, etc.