Senior Data Engineer

Mosaic, a leading company providing powerful financial planning and business performance solutions, is on the lookout for a Senior Data Engineer. Our team is dedicated to building scalable, high-performance solutions. If you are an individual who thrives in a collaborative environment, enjoys managing the end-to-end data process, and is passionate about shaping how data is consumed within an organization, this could be your next role!

What You'll Be Responsible For:

1. Design, develop, and maintain scalable and efficient data pipelines to process large volumes of data from various sources.
2. Collaborate with stakeholders and other backend engineers to understand data requirements and deliver high-quality data solutions.
3. Optimize and maintain data infrastructure, ensuring reliability, scalability, and performance.
4. Implement best practices for data management, including data governance and data quality.
5. Develop and maintain ETL processes to integrate data from multiple heterogeneous sources into a unified data warehouse.
6. Monitor and troubleshoot data pipeline issues, ensuring data integrity and availability.

Requirements:

1. Strong communication and collaboration skills, with the ability to work effectively in a distributed team across various time zones.
2. Demonstrated ability to manage data projects from start to finish, effectively negotiating requirements and deliverables with key stakeholders.
3. 5+ years of experience in data engineering or a related field working with data in a high-volume environment.
4. Proficiency in programming languages such as Python, Java, or Scala.
5. Extensive experience with SQL and database technologies (e.g., PostgreSQL, MySQL, Oracle).
6. Familiarity with data orchestration tools (e.g., Apache Airflow), data transformation tools (e.g., Spark), dimensional modeling (e.g., star schema), metadata, indexing, dependencies, and data workflows to support data analytics and data science.
7. Experience with big data technologies (e.g., Hadoop, Spark, Kafka) and cloud platforms (e.g., AWS, Azure, Google Cloud).
8. Familiarity with data warehousing solutions (e.g., Redshift, BigQuery, Snowflake).
9. Solid understanding of data modeling, data architecture, and database design principles.
10. Excellent problem-solving skills and attention to detail.
11. Bachelor’s degree in Computer Science, Engineering, Information Technology, or a related field.

Preferred Qualifications:

1. Subject Matter Expertise (SME) on data structure and datasets in the Financial Planning and Analysis space.
2. Experience with containerization and orchestration tools (e.g., Docker, Kubernetes).
3. Experience in a fast-paced, agile development environment.
4. Understanding of data lake and data lakehouse architectures and Delta Lake or Apache Iceberg table formats.

At Mosaic, we take immense pride in our diverse workforce, continuously nurturing a cohesive team of talented, independent, and compassionate individuals who are revolutionizing the realm of corporate finance. As a staunch believer in equal opportunities, Mosaic ensures the inclusion of all intersectional identities and maintains a strict policy against any form of discrimination. Our team members are equipped with the tools they require to enjoy a high degree of autonomy, and we encourage everyone to chase both professional and personal growth. While our headquarters are located in the picturesque Del Mar, California, we adopted a remote-friendly work environment early in our journey. Our teams make biannual trips to San Diego, taking a break from digital screens to engage in in-person interactions and team-building activities.

The target salary for this position is $160,000 - $190,000 and is part of a competitive total rewards package including stock options, benefits, and additional opportunities for incentives and bonuses for performance beyond goals. Individual pay may vary from the target range and is determined by a number of factors including experience, location, internal pay equity, and other relevant business considerations. We review all employee pay and compensation programs annually at a minimum to ensure competitive and fair pay.