Data Engineer II at The Judge Group Inc. in Newport Beach, California

Job Description:

Location: Newport Beach, CA

Salary: $50.00 USD Hourly - $60.00 USD Hourly

Description: Our client is currently seeking a Data Engineer II


Work with technology and business stakeholders to understand data requirements


Exposure to data warehousing concepts and must have participated in various implementations building data hubs, data marts etc.


Build scalable and reliable data pipelines to support data ingestions (batch and /or streaming) and transformation from multiple data sources such as Flat Files, SQL, AWS RDS, S3 etc. and help centralize the information on Snowflake.


Hands on experience in ingestion, transformation, and database technologies. Expertise in SQL, complex query writing, query organization, optimization.


Create unit/integration tests and implement automated build and deployment. Participate in code reviews to ensure standards and best practices.


Deploy, monitor, and maintain production systems. Create and update user stories in backlog, participate in agile scrum ceremonies.


Collaborate with product owner, analysts, architects, QA and other team members The experience you will bring:


Minimum 2-year hands on ETL development experience using DBT Minimum 4-year hands on experience working with SQL and Snowflake database Minimum 1-year hands on experience (not just training or POC) in using Git and Python Strong communication skills and work in collaborative environments.


What will make you stand out:


Hands on Experience in ELT development using Matillion (ingestion tool), DBT (transformation tool) and Snowflake (Database technology) Experience working with Azure Dev Ops, Build and Release CI/CD pipelines Experience working with AWS and Control M Experience coding complex transformations (not just extract/load mappings) in DBT Typical


Qualifications:


3-5+ years of data engineering experience


BS Degree: IT or Computer Science or Engineering TECHNICAL SKILLS:


Must Have: o Minimum 1year hands on experience (not just training or POC) in using Git and Python o Minimum 2 year hands on ETL development experience using DBT o Minimum 2 year hands on experience working with SQL and Snowflake database Nice To Have: • Experience coding complex transformations (not just extract/load mappings) in DBT • Experience working with AWS and Control M • Experience working with Azure Dev Ops, Build and Release CI/CD pipelines • Hands on Experience in ELT development using Matillion



Contact: aflores@judge.com


This job and many more are available through The Judge Group. Find us on the web at www.judge.com