ETL Data Specialist

| Greater LA Area
ETL Data Specialist
Yankees, Angels, Eagles, Seahawks, Lollapalooza, Governors Ball, Bonnaroo…the biggest names in entertainment are our customers. We power the tech behind every t-shirt, hotdog and drink sold at
these venues, and at a global list of other clients that you just wouldn’t believe. Didn’t think Point of Sale could be sexy? Think again.
We’re looking for a truly exceptional ETL Data Specialist. This Data Engineer will be a specialist in building ETL pipelines with years’ experience in ETL and AWS. The ideal developer will have strong skills
in MySQL, AWS Redshift, Python or Perl scripting, and AWS Data Lakes.
Imagine Lollapalooza or a hot Yankees game in the middle of summer if you couldn’t buy a beer…unacceptable. The stuff you’ll work on has a very real impact, and our customers will love you or hate you for what you deliver. What you build matters here.
You should be able to operate without much direction, but be excited to work closely with a team. We want developers who are opinionated about smart ways to build, yet humble enough to listen
and take input well. We’re looking for engineers who care deeply about the databases in their care…it impacts your fellow devs, your company, and your customers. We have an incredible team, with a brilliant culture. Your friends will be jealous when you tell them about your day at work. What are you waiting for? Send us your resume!
Responsibilities:
● Model product and business data in our data warehouse for the efficient use of both technical and
non-technical users
● Develop complex SQL queries, scripts, user defined functions, views and triggers for business
logic implementation
● Participate in design reviews and ensure that all solutions are aligned to predefined project goals
and requirements
● Develop strong collaborative relationships with key partners in Analytics, Development,
Operations, and Quality Assurance teams
● Participate in data strategy and roadmap exercises, business intelligence/data warehouse
product selection, design and implementation
● Perform regular query optimizations to ensure performance stability
● Develop best practices for data modeling and query writing
Requirements:
● At least 5 years of hands-on experience in Data Modeling and Business Intelligence
● Experience in design or development of enterprise data solutions, applications, and integrations
● Ability to read, write, and tune complex SQL.
● Experience in scripting for ETL development and data munging & analysis (Python, Perl, etc.
● Working knowledge of basic statistical concepts and data analysis best practices
● Familiarity with large scale MPP systems (Hadoop, AWS Redshift, Snowflake etc.)
● In-depth understanding of database management systems and advantages & disadvantages of
different types of systems (OLAP, OLTP, etc.).
● Expertise with business intelligence solutions, such as Looker, Tableau, and Microstrategy
● Extensive knowledge of Data Warehousing, Data Marts and reporting objects such as facts,
dimensions, relationships, hierarchies, and calculations.
● Ability to lead own projects and work independently once given a direction
● Excellent communication, presentation and interpersonal skills
● Attention to detail
● Bachelor’s degree or equivalent experience in engineering, computer science, finance, math,
economics, statistics, or a similar quantitative or technical field
Desirable:
● Experience with automation tools (ansible, puppet, chef)
● Hardware stack experience
● Linux administration
● MySQL configuration and support
● PostgreSQL configuration and support
● Containers and virtualization
Read Full Job Description

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
    • GolangLanguages
    • PHPLanguages
    • PythonLanguages
    • ReactLibraries
    • MySQLDatabases
    • Google AnalyticsAnalytics
    • WordpressCMS
    • SalesforceCRM
    • MailChimpEmail
    • PardotEmail
    • SalesloftEmail

Location

6601 Center Drive West , Los Angeles, CA 90045

An Insider's view of Appetize

What’s the vibe like in the office?

I started at Appetize when it was (literally) in a garage as one of the first 10 employees. Even as the company with over 300 employees, it has never lost its startup charm. Everyone up the ladder is approachable and truly fun to be around – both inside and outside of work. It’s my first job where I don’t know how many hours are left in the day!

Mike

Director of Business Systems

What are Appetize Perks + Benefits

Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Wellness Programs
Retirement & Stock Options Benefits
401(K)
Company Equity
Child Care & Parental Leave Benefits
Family Medical Leave
Vacation & Time Off Benefits
Unlimited Vacation Policy
Paid Volunteer Time
Paid Holidays
Paid Sick Days
Perks & Discounts
Beer on Tap
Casual Dress
Commuter Benefits
Company Outings
Game Room
Stocked Kitchen
Some Meals Provided
Happy Hours
Parking
Pet Friendly
Fitness Subsidies
Professional Development Benefits
Job Training & Conferences
More Jobs at Appetize8 open jobs
All Jobs
Finance
Data + Analytics
Dev + Engineer
HR
Operations
Data + Analytics
new
Los Angeles
Developer
new
Los Angeles
Finance
new
Los Angeles
Developer
new
Los Angeles
Developer
new
Los Angeles
Operations
new
Los Angeles
HR
new
Los Angeles