Senior Data Engineer

Senior Data Engineer

Location: Newport Beach, CA or Charlotte, NC

Key Responsibilities:

• 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.

Qualifications:

• 5+ years of data engineering experience.
• BS Degree: IT or Computer Science or Engineering.
• Minimum 2-year hands on ETL development experience using DBT.
• Minimum 5+ 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.

Platinum Resource Group is a professional level consulting firm, providing resources to Fortune 1000 client companies in the areas of technology, human resources, accounting, finance, business systems, and supply chain, on a contract and interim basis. PRG has operations in Orange County, San Diego, Los Angeles, and San Francisco. As a W-2 employer, we offer our consultants direct deposit bi-weekly payroll, health, dental, vision benefits, and referral bonuses.