Data Engineer

Company:
Location: San Antonio, TX 78245

*** Mention DataYoshi when applying ***

Come work at a place where innovation and teamwork come together to support the most exciting missions in the world!

The Data Engineer will be integral part of Supply Chain Data Science team and is responsible for delivering various Analytics initiatives. They participate in defining and delivering the Data and Analytics based insights that can be leveraged by business teams. They align solutions, releases, and sprints consistent with program and project delivery cadence and are responsible for ensuring practical and implementable alignment with the organization and enterprise technological and architectural vision.

This role understands the solution context and actively collaborates with the teams, customers, and suppliers to ensure alignment. They are trained and practiced in both traditional and agile delivery models, understand and are able to manage the complexities of large-scale solution development, and will be fluent in English.

Essential Job Functions The incumbent must be able to perform all of the following duties and responsibilities with or without a reasonable accommodation.

This position will work closely with the Scrum masters, Data Architects, QA, Dev/Ops, as well as multiple organizations within the company Engineer data/ETL pipelines to bring new data into data warehouse Partner with the Data architects, Product managers and Scrum Masters to deliver data integrations and BI solutions required for various projects Ability to translate requirements for BI and Reporting to Database design and reporting design Ability to engineer solutions using AWS products such as EC2, S3 buckets, Lambda functions, SQS queues, Dynamo DB etc. Ability to understand data transformation and translation requirements and which tools to leverage to get the job done Ability to understand data pipelines and modern ways of automating data pipeline using cloud based and on premise technologies Enable Continuous Delivery (CD) to production for all data warehousing and BI builds Collaborate with DevOps team to align with CI/CD requirements for assigned projects Ability to understand end to end data integration requirements and response time SLA’s to build data driven solutions that provide best in class customer experience Ability to develop scripts (Unix, Python etc.) to do Extract, Load and Transform data Ability to write SQL queries against major databases such as Oracle, Netezza, Snowflake, SQL Server etc. Ability to integrate on premise infrastructure with public cloud (AWS, AZURE) infrastructure Actively test and clearly document implementations, so others can easily understand the requirements, implementation, and test conditions. Strong understanding of modern analytics using Machine Learning and data science

Other Duties and Responsibilities

  • Create and enforce technical, coding standards, tools, platforms, and approaches specific to Enterprise Data Warehouse, BI and Analytics
  • Strong understanding of Database concepts and data modeling
  • Strong understanding of dimensional modeling and data warehousing methodologies
  • Coordinate with the development teams and vendors to ensure the right teams are working on the right build components at the right time, with clear expectations of milestones and goals
  • Hands-on experience with JIRA, Confluence, Gitlab, and other DevOps tools
  • Agile / Scrum Methodology – Completed multiple projects leveraging the agile methodology in delivering data.
  • Data Integration – Hands on experience with data federation tools, ETL tools, cloud data integration / translations tools, etc.
  • Experience with retail industry a plus

Nature of Supervision:

Works under general direction. May take the lead in complex projects. Acts independently and advises technical associates and management.

Planning and Problem Solving:

Designs and reviews technical solutions to complex problems which require the regular use of ingenuity and creativity. Responsible for assigning, monitoring and reviewing progress and accuracy of work, directing efforts and providing technical guidance on more complex issues. Exercises considerable latitude in determining technical objectives of assignment.

Impact:

Drives the completion of milestones associated with issues, tasks, projects or large initiatives. Failure to achieve results or erroneous decisions or recommendations may cause delays in delivery of technology solutions or in program schedules, may result in the allocation of additional resources, and can result in system outages or poor performance. Work has an impact on day-to-day and strategic organizational priorities.

Education/Experience:

  • 3-5 years’ experience with major data warehousing platform such as Oracle, Teradata, Netezza, AWS Redshift, Snowflake etc.
  • 3-5 years’ experience developing ETL, ELT and Data Warehousing solutions
  • 3-5 years’ experience with data engineering using Alteryx and Python based data pipelines
  • 3-5 years’ experience AWS cloud, Azure or Google cloud
  • 3-5 years’ experience in data modeling using ERWIN
  • 3-5 years’ experience in loading source system data extracts into data warehouse
  • 3-5 years’ experience with batch job schedling and identifying data/job dependencies
  • 3-5 years’ experience with automation of DevOps build using Gitlab/Jenkins/Maven
  • Strong in Linux experience to for shell scripting and Python scripting
  • 3-5 years’ experience with REST API development and consumption
  • Strong undersatnding of various data formats such as CSV, XML, JSON etc.
  • Experience working directly with technical and business teams.
  • Strong understanding of Agile process and tracking using Jira and Confluence
  • IT governance and operations Comprehensive knowledge of hardware, software, and application dependencies.

Competencies:

  • Demonstrate Adaptability and Desire to Learn - Works productively in the face of ambiguity or uncertainty. Demonstrates flexibility and resilience in response to obstacles, constraints, adversity, and mistakes. Responds constructively to new demands, priorities, and challenges or obstacles. Updates knowledge and skills to handle new complexities, challenges, and responsibilities. Invites and incorporates feedback, without becoming defensive.
  • Perform Professional Analysis - Gathers and analyzes the most critical information needed to understand problems. Identifies the key issues in complex or ambiguous problems. Breaks down problems into manageable components. Recognizes symptoms that indicate problems.
  • Improve Processes and Quality - Focuses efforts on continuously improving processes and practices. Uses appropriate metrics and data to monitor and improve processes and practices. Ensures that outputs, products, and services are of high quality. Analyzes problems and process breakdowns to ensure that lessons are learned and improvements are made.
  • Plan and Execute - Develops realistic plans (e.g. , action steps, timelines) to accomplish objectives (e.g., optimizing staffing schedules). Plans and manages his/her own and others' time, based on business priorities, and follows up to ensure all work requirements are completed in a timely and accurate manner. Holds him/ herself and team accountable for outcomes (e.g., achieving goals and complying with policies and procedures). Anticipates and addresses obstacles, redirecting efforts to accelerate the work or improve quality.
  • Produce Results - Initiates decisive, timely action to address important issues. Leads sustained effort to accomplish desired results. Conveys challenging, clear goals/targets and expectations for achieving business results. Drives initiatives/efforts to successful completion and closure.
  • Satisfy the Customer - Ensures the accurate understanding of customer needs (e.g., ensures that customer facing employees ask key questions). Seeks feedback from customers to identify improvement opportunities. Ensures follow-up with customers to confirm problems are solved. Continually searches for ways to improve customer service (including the removal of barriers, and providing solutions).
  • Use Professional Judgment - Makes sound decisions regarding everyday issues and problems. Chooses from alternatives based on consideration of pros, cons, tradeoffs, timing, and available resources. Evaluates the impact or consequences of actions and decisions (e.g., impacts on sales, customer satisfaction). Makes timely decisions regarding problems/issues requiring immediate attention.

Work Environment:

Typically the incumbent will be in an office setting seated, in artificial light and working for prolonged periods of time on the computer. Some travel may be required.

Contacts:

Interact with internal company contacts as well as external vendor contacts. May communicate with outsourced team(s) when working on issues or tasks. Frequent inter-organizational team contacts on routine matters. May direct or interact with vendor contacts to evaluate solutions or resolve existing issues.

The above description is meant to provide an overview/summary of the nature and level of work being performed; it should not be construed as an exhaustive list of all responsibilities, duties and requirements of the job. PETCO reserves the right to modify the content formally or informally, either verbally or in writing, at any time without advance notice and employees are required to follow any other job-related duties/functions requested by their supervisor. Further, all employment at PETCO is of an at-will nature and, as such, the company reserves its right to terminate any position or employee (with or without notice and with or without cause) within its discretion.


Petco Animal Supplies, Inc. is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, age, protected veteran status, or any other protected classification.

*** Mention DataYoshi when applying ***

Offers you may like...

  • CyberCoders

    Data Engineer
    San Francisco, CA 94102
  • iVinci Health

    Data Engineer II
    Boise, ID 83702
  • Go Maverick Group

    Lead Data Engineer
    Remote
  • Logic20/20

    Senior Data Engineer
    San Francisco, CA 94016
  • Trova

    Remote Data Engineer/No Sponsorship
    Orlando, FL