Back to Search

Data Engineer II

Date Posted: 9/30/2024

Apply Now

Job Description

We are seeking a Data Engineer to work on a team for a project with our client. The position is 6 months in duration, but could be extended. Please, no 3rd parties.

Job Description Summary:

  • 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

All qualified applicants will receive consideration for employment without regard to race, color, national origin, age, ancestry, religion, sex, sexual orientation, gender identity, gender expression, marital status, disability, medical condition, genetic information, pregnancy, or military or veteran status. We consider all qualified applicants, including those with criminal histories, in a manner consistent with state and local laws, including the California Fair Chance Act, City of Los Angeles' Fair Chance Initiative for Hiring Ordinance, and Los Angeles County Fair Chance Ordinance. To the extent our customers require a background check for certain positions, the Company faces a significant risk to its business operations and business reputation unless a review of criminal history is conducted for those specific job positions.


To apply please email your resume to mdelaney@rothstaffing.com

Apply Now Send to a Friend

Job Snapshot

  • Employee Type:Contractor
  • Location:Newport Beach, CA
  • Job Type:Finance
  • Experience:3-5 years
  • Education:4 Year Degree
  • Date Posted:9/30/2024
  • Contact: Melanie Delaney (949) 271-2973
  • Pay Range: $0.00 - $70.00 Hourly
Get Job Alertsby Email
  • Receive alerts with new job opportunities that match your interests
  • Receive relevant communications and updates from our organization

Sign Up Now


Job Reference: JN -092024-378852