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.

Meet Some of Mosaic's Employees

Julie E.

Manager, Back Office Engineering

Julie oversees one of Mosaic’s trio of Engineering Teams. Together with her team, Julie works with product managers and oversees the back-end aspects of Mosaic’s financial accounting and commerce.

Ajay D.

Marketing Project Manager

Ajay works on Mosaic’s Marketing Team. He facilitates collaborative projects involving multiple teams and helps produce the marketing content that different teams need.

Back to top