Data Engineer

TEKsystems
$70.00 - $80.00 / hr
life insurance, sick time, 401(k), retirement plan
United States, California, Newport Beach
Jul 11, 2025
Description 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, and 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 the backlog, participate in agile scrum ceremonies. Collaborate with product owner, analysts, architects, QA, and other team members Skills DBT, Matillion, control m, sql, python Top Skills Details DBT,Matillion,control m Additional Skills & Qualifications Hands on Experience in ELT development using Matillion (ingestion tool), DBT (transformation tool) and Snowflake (Database technology) Experience working with AWS and Control M Experience coding complex transformations (not just extract/load mappings) in DBT Not required, but typical qualifications 7-10 years BS Degree: IT or Computer Science or Engineering Experience Level* Intermediate Level Pay and Benefits The pay range for this position is $70.00 - $80.00/hr. Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role may include the following: * Medical, dental & vision * Critical Illness, Accident, and Hospital * 401(k) Retirement Plan - Pre-tax and Roth post-tax contributions available * Life Insurance (Voluntary Life & AD&D for the employee and dependents) * Short and long-term disability * Health Spending Account (HSA) * Transportation benefits * Employee Assistance Program * Time Off/Leave (PTO, Vacation or Sick Leave) Workplace Type This is a hybrid position in Newport Beach,CA. Application Deadline This position is anticipated to close on Jul 17, 2025. h4>About TEKsystems: We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company. The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law. About TEKsystems and TEKsystems Global Services We're a leading provider of business and technology services. We accelerate business transformation for our customers. Our expertise in strategy, design, execution and operations unlocks business value through a range of solutions. We're a team of 80,000 strong, working with over 6,000 customers, including 80% of the Fortune 500 across North America, Europe and Asia, who partner with us for our scale, full-stack capabilities and speed. We're strategic thinkers, hands-on collaborators, helping customers capitalize on change and master the momentum of technology. We're building tomorrow by delivering business outcomes and making positive impacts in our global communities. TEKsystems and TEKsystems Global Services are Allegis Group companies. Learn more at TEKsystems.com. The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.