Senior Data Engineer - Remote

SquareTrade is the fastest growing company of its kind. We’re revolutionizing a $30b industry with service innovation and attention to customer satisfaction. We partner with some of the largest, most sophisticated retailers and carriers in the world (Walmart, Target, Amazon, Costco, and T-Mobile to name a few), consistently win industry awards, have received tens of thousands of 5-star reviews… and we’re just getting started. A member of the Allstate family, SquareTrade has headquarters in San Francisco and London.

Job Description

The SquareTrade Data Engineering team believes data is a key to decision making. We want to use data insight to look for new opportunities and help improve our award-winning service to our customers.

As a Data Engineer, you’ll develop, create, and modify data engineering applications software or specialized data pipeline utility programs. Analyze business users needs and develop data solutions. Design software or customize software for Merchant Integration, Supply chain and Finance use with the aim of optimizing operational efficiency. Analyze and design databases within a data warehouse area, working individually or coordinating database development as part of a team.

Employees can work remotely

Responsibilities Include:

• Confer with product managers, engineers, programmers and others to design system and to obtain information on project limitations and capabilities, performance requirements and data pipeline (ETL/ELT) interfaces.
• Modify existing data pipeline (ETL/ELT) to correct errors, allow it to adapt to new data pipeline (ETL/ELT), or to improve its performance.
• Analyze Merchant Integration, Finance and Supply chain Stakeholders and product managers needs and data requirements to determine feasibility of design within time and cost constraints.
• Consult with Merchant Integration, Finance and Supply Chain Stakeholders about data system design and maintenance.
• Design, develop and modify data systems, using scientific analysis and mathematical models to predict and measure outcome and consequences of design.
• Develop and direct data system testing and validation procedures, programming, and documentation.
• Analyze information to determine, recommend, and plan data system reports and layouts, and modifications.
  

Our Ideal Candidate:

• Loves to work with different technology stacks: We believe in using the best tool to get the job done which may be developing out our Java app, writing Python (our your favorite scripting language), laying out Informatica ETL mappings, or prototyping a problem with Hadoop and Spark.
• Develops for scalability: you’re able to solve both high-level architectural and in-depth problems.
• Is curious and want to learn: We believe in continual improvement, and we want teammates who share our vision of growing technology and people.
• You’ve got a solid foundation: This role requires both a broad and deep understanding of data; you must have an advanced understanding of MPP databases, data modeling & schema design, large-scale data processing frameworks and experience building data pipelines from disparate sources.

Qualifications

• Bachelor’s in Computer Science, Computer Engineering, or related is required
• 5+ years of relational database experience (Postgres preferred); strong analytical SQL skills necessary.
• 5+ years of experience w/ custom or structured ETL design, implementation and maintenance.
• 1+ years of dynamic scripting (Python preferred) development experience.
• 3+ years of shell scripting experience.
• 1+ years of experience working with big data technologies (Kafka, Spark, Hive, Hadoop).
• 1+ years of Java development experience required.

Additional skills:

• Informatica Cloud Platform or Python base Framework.
• Data Ingestion and Integration from/To between Flat file, Databases, ERP, SFTP, CRM.
• Tableau Desktop 9.0 for Reporting business metrics