Your browser cookies must be enabled in order to apply for this job. Please contact support@jobscore.com if you need further instruction on how to do that.

Data Engineer (SQL, ETL, Pentaho)

Data Engineering | West Los Angeles, CA | Full Time

Job Description

When was the last time you put an industry on its head, shook it up, and then smacked it to the point of complete disruption? Never? Want to?

FreedomPop has been a disruptive freemium telco delivering the nation’s first 100% FREE mobile phone and wireless internet service since 2011. With $100m+ in series c funding, FreedomPop is rewriting the rules of the global telecom industry. The company offers a suite of smartphones, tablets, hotspots, services, and innovative social sharing and incentivized benefits, providing consumers access to free mobile phone and high-speed internet services worldwide.

Yes, EVERYONE and EVERYWHERE. FreedomPop is the world's first 100% free mobile plan so that no one is left off the "connected grid.” That is the dream. But to realize our vision we need incredible people that want to put that “dent in the universe” and be a relevant part of our growing yet close knit crew.  

We are looking for a Data Engineer to join our Business Intelligence Team at our new HQ in Westwood Village, CA. The ideal candidate will have a few years of experience, familiar with data architecture principles including data warehousing techniques, data quality, testing procedures. Our ideal fit will thrive in a fast-paced, highly versatile work environment that values team-based product development to solve business problems and scale for growth. The position duties are:

  • Participate in all Data Warehouse development projects. Work with the end-users and stakeholders to collect technical requirements.

  • Review available data sources and current processes. Perform Data Model design and documentation; continue with development, implementation, process scheduling, task tracking, and status reporting.

  • Work with team to understand existing ETL processes and to assist with production support, troubleshooting, optimizing and tuning as needed. Participate in design and deployment of the new data warehouse ETL processes using Pentaho DataIntegration and custom scripting.

  • Participate in developing new reporting solutions, using cloud based technologies like Redshift and QuickSight. Participate in POC’s for new platforms and tools for ETL, Analysis and Reporting.

  • Collaborate with  analysts and key stakeholders in developing reliable analytics in a fast-paced agile environment. Support power users and business analysts with ad-hoc SQL queries for analysis and reporting. 

We require for this role:

  • Strong analytical and problem solving skills.

  • 3+ years of professional experience.

  • 3+ years of experience working with BI tools. Experience working with Pentaho BI reporting and ETL is a plus.

  • 3+ years of experience writing SQL queries, performance tuning of underlying BI queries by analyzing query plans, table joins etc.

  • Linux Shell scripting skills.

  • Experience with Amazon RDS Aurora and Redshift is a plus.

  • Experience with data manipulation languages like python, perl etc. is a plus.

  • Experience working with small collaborative teams

  • Startup Experience is a plus.

  • Ability to work under pressure to meet tight deadlines.

  • Willingness to learn, a can do attitude, and motivated to succeed and grow.

With 100% free basic plans, FreedomPop also offers premium unlimited talk and text plans up to 80% off other carriers and top brand smartphones up to 50% off MSRP. With no contract and no commitment, FreedomPop offers the best value in mobile. So get your freemium on and disrupt your career for the better here at FreedomPop!

FreedomPop is an EOE M/F/D/V. We do not work with Search &/or Staffing Agencies.