Senior Data Engineer

Chipotle
Senior Data Engineer
Newport Beach, CA (Remote)
12+ month contract (Potential for extension)
Key Responsibilities:

• Design, develop and maintain scalable data pipelines
• Develop data ingestion and integrations (REST, SOAP, SFTP, MQ, etc.) processes
• Take ownership of building data pipelines
• Actively engage in technology discovery and implementation for both on-prem and in Cloud (i.e. Azure or AWS) to build solution for future systems
• Develop high performance scripts in SQL/Python/etc. to achieve objectives of enterprise data, BI and analytics need.
• Incorporate standards and best practices into engineering solutions
• Manage code versions in source control and coordinate changes across team
• Participate in architecture design and discussions
• Provide logical and physical data design, and database modeling
• Be part of the Agile team to collaborate and to help shape requirements
• Solve complex data issues around data integration, unusable data elements, unstructured data sets, and other data processing incidents
• Supports the development and design of the internal data integration framework
• Works with system owners to resolve source data issues and refine transformation rules
• Partner with enterprise teams, data scientist, architects to define requirements and solution

Key Qualifications :

• Have a B.A./B.S. and 5-8 years of relevant work experience; or an equivalent in education and experience
• Must have excellent experience with Snowflake
• Hands on experience with Microsoft Stack - SSIS, SQL, etc.
• Possess strong analytical skills with the ability to analyze raw data, draw conclusions, and develop actionable recommendations
• Experience with the Agile development process preferred
• Proven track-record of excellence and consistently delivered past project successfully
• Hands on experience with Azure data factory V2, Azure Databricks, SQLDW or Snowflake, Azure analysis services and Cosmos DB
• Experience with Python or Scala.
• Understanding of continuous integration and continuous deployment on Azure
• Experience with large scale data lake or warehouse implementation on any of the public cloud (AWS, Azure, GCP)
• Have excellent interpersonal and written/verbal communication skills
• Manage financial information in a confidential and professional manner
• Be highly motivated and flexible
• Effectively handle multiple projects simultaneously and pay close attention to detail
• Have experience in a multi-dimensional data environment

Required Skills : Chipotle needs a resource who understands the end-to-end process of moving data from on-prem to the cloud. They will be using Azure Data Factory, moving SSIS packages to the cloud, and ultimately ending in Snowflake. This Data Engineer may also be developing integrations on Snowflake data warehouse. For a candidate to be successful in this role they need to be strong with SQL, Azure and Snowflake. It would be a huge benefit if they also have DBT Cloud Tool experience/knowledge.
Basic Qualification : SQL, ETL, Azure Data Factory, SSIS, and Snowflake
Additional Skills : SQL, ETL, Azure Data Factory, SSIS, and Snowflake We have placed 4 contractors on this team and all have been on for long term engagements, this role provides cutting edge tech in a stable environment for those who come in and perform.
Background Check :Yes
Notes :
Selling points for candidate :We have placed 4 contractors on this team and all have been on for long term engagements, this role provides cutting edge tech in a stable environment for those who come in and perform.
Project Verification Info :
Candidate must be your W2 Employee :No
Exclusive to Apex :No
Face to face interview required :No
Candidate must be local :No
Candidate must be authorized to work without sponsorship ::No
Interview times set :Yes
Type of project :Development/Engineering
Master Job Title :Dev: SQL Server Database
Branch Code :Orange County