Develop and optimize large-scale batch and real-time data pipelines that ingest structured and unstructured data from a variety of sources.
This Jobot Job is hosted by: Samantha Cunningham
Are you a fit? Easy Apply now by clicking the "Apply" button
and sending us your resume.
Salary: $150,000 - $175,000 per year
A bit about us:
Luxury Retailer based out of NY,NY
Why join us?
Competitive compensation
Comprehensive Medical, Dental and Vision benefits
Generous Paid Time Off inclusive of holidays and flexible floating holidays
401k retirement plan with company matching
Job Details
The position will report directly to the SVP, of Development and will be part of the Development team responsible for building and scaling our existing data and reporting operational functions that support and inform strategic decision-making. The role requires hands-on technical data skills and good communication skills for collaboration with the rest of the development team and business stakeholders in other departments.
RESPONSIBILITIES:
Design, build, develop, deploy and maintain applications using the Looker and Snowflake business intelligence platforms.
Develop and optimize large-scale batch and real-time data pipelines that ingest structured and unstructured data from a variety of sources.
Experience loading and unloading data with different file types (such as CSV, JSON, XML, etc)
Hands-on experience with LookML and SnowSQL (writing procedures)
Strong experience with SQL language and data warehousing architecture
Develop and maintain pipelines using DBT
Experience with ETL technologies and integrations
Experience using code versioning and build processes (GIT)
Able to perform data quality checks and validation rules and various stages of processing.
Develop reporting solutions to challenging complex business problems.
Work closely with the business stakeholder team and shared development resources across all phases of projects
Lead and/or participate in project efforts using an Agile development methodology.
Collaborate with QA to develop comprehensive and appropriate test strategies for each release
POSITION REQUIREMENTS:
Bachelor’s degree in computer science, Engineering or a related subject, or equivalent experience
5 years in a data engineer or SQL-heavy data analyst role
Track record of success in building new data engineering processes with a wide range of data sets from various sources.
Demonstrated ability to work across disparate teams to achieve consensus on key business decisions.
Expert-level SQL skills.
Advanced knowledge with Looker, DBT, Snowflake and/or equivalent tools.
Willingness to roll up your sleeves and fix problems in a hands-on manner.
Intellectual curiosity and research abilities.
Demonstrated knowledge of modern SDLC, Agile/Scrum, Kanban etc.
Ability to organize and manage multiple tasks and priorities
Strong communication skills with the ability to cross collaborate amongst internal departments
Self-motivated and willing to "do what it takes" to get the job done
NICE TO HAVES:
Experience building on AWS
Expert level with basic tools like Excel
MySQL tuning and database optimization
Interested in hearing more? Easy Apply now by clicking the "Apply" button.