Skip to content

 

Oakland, California Full Time Posted: Thursday, 12 October 2017
 
 
Applicants must be eligible to work in the specified location
DATA ENGINEER

Company Overview

Mosaic makes it simple to go solar by leveraging technology and financial innovation, with a goal of providing access to clean energy for everyone. We are looking to collaborate with passionate, thoughtful people who want to make a real social impact while working to solve climate change. Come join our team centrally located in beautiful downtown Oakland and help build the movement towards 100% clean energy for all.

The Opportunity

We are a fast paced, growing company and are looking for a rock star to join our Data Engineering team. You are a full stack Data Engineer, that can take a business concept, identify data sources, build data pipelines, design data structures and objects in Redshift and other databases as appropriate, test, double test and move to production. This is a 100% hands on role.

Your day-to-day

  • Design data warehouse/data marts in AWS Redshift and other Databases as appropriate
  • Design and build robust data pipelines using ETL tools and Scripting in SQL/Java/Scala. Create automated data validation routines
  • Manage code and tickets in JIRA, Gitlab
  • Validate and build audit, balance and control of mission critical data pipelines
  • Develop cool viz using Tableau and other open source Viz tools as needed
  • Interact with Product Managers and other departments to understand, validate and iterate on requirements, build quick prototypes
  • Identify best data sources among multiple sources to use for data pipelines to improve trust in data

What you bring to the team

  • 6-8 years of total technical experience with heavy data warehouse experience for about 8 years
  • Masters or equivalent in CS/Engineering or other comparable discipline
  • Very strong, demonstrable SQL, Data Model, ETL and Data Warehouse skills
  • Hands on experience with AWS Redshift (We are entirely on AWS)
  • Familiarity with Agile methods (we are highly agile and use agile tools)
  • Hands on experience in JAVA, Python, or Scala
  • Experience with reporting tools like Tableau
  • Team player, agile, highly accountable, curious, willing to learn, implement and teach
  • Ability to work both independently and in close collaboration with team members and managers
  • Ability to juggle multiple responsibilities and work under pressure with tight deadlines

Bonus Points

  • Experience with open source tools such as Presto DB and Kafka is a plus
  • Financial services & accounting data experience is a plus

Why Mosaic

As a customer focused and driven-to-win organization, there are many exciting reasons to join the Mosaic team. We provide competitive salaries, quality healthcare and an enjoyable, be-yourself office environment. We are deeply mission and vision driven, have unlimited vacation days, and support flexible schedules when needed. Mosaic has a dynamic, fast-paced, and entrepreneurial environment, which requires a professional, flexible, self-starter attitude. We believe in hiring the best, the brightest, and cultivating a culture of collaboration and appreciation.

We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.


Associated topics: data analyst, data engineer, data manager, data scientist, data warehousing, database administrator, etl, erp, mongo database administrator, SQL

Oakland, California, United States of America
IT
Solar Mosaic
Solar Mosaic
JS4506650750/276932462
10/12/2017 3:20:08 PM

We strongly recommend that you should never provide your bank account details to an advertiser during the job application process. Should you receive a request of this nature please contact support giving the advertiser's name and job reference.

Other jobs like this

San Francisco, California
USD
Mountain View, California
USD