Senior Data Engineer
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.
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.
- Design data warehouse/data marts in AWS Redshift and other Data bases 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
- Fix bugs, coach and mentor junior resources, work collaboratively with team members
What you bring to the team
- 8-12 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
- Experience with open source tools such as Presto DB and Kafka is a plus
- Financial services & accounting data experience is a plus
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
Assistant General Counsel
As Mosaic’s Assistant General Counsel, Veronica oversees the legal and regulatory compliance of company operations. She also drafts and negotiates contracts for every aspect of Mosaic’s business dealings.
Back to top