Senior BI Data Engineer

Description

A Little Bit About Us

If you're looking for a rewarding career at a company with a supportive workplace culture and unlimited potential for growth, consider Gemini Legal. We are a dynamic, industry-leading, technology-based company headquartered in Rocklin, California. Gemini provides support services to California attorneys, collecting digital records and offering vocational counseling to injured workers.

Our management team has an open-door policy, and our exceptional growth is credited solely to our team members and their dedication to collaborate, achieve and give back. Success is celebrated and integrity is the essence of who we are.

Ethical. Passionate. Smart. These three tenets drive our diverse team, and we welcome dedicated individuals to apply to join our work family.

Gemini’s vision and opportunity is to earn respect as the leading provider of ethical, quality legal support products and services to a growing number of attorneys and types of law. We deliver on our mission through principled, personal leadership. We embrace and meet our clients’ true needs by providing a safe, stable and competitive work environment where employees, clients and vendors enrich their community and themselves personally and professionally.

A Little Bit About the Position

The  Senior BI Data Engineer’s purpose at Gemini is to organize and design comprehensive data collection, organization, analysis, and support. This role acts as an analytics engineer, sculpting enterprise-quality data warehouse solutions that support fast visualization providing actionable insights that support strategic business decisions. The Senior BI Data Engineer role owns the technical design of our Snowflake environment - dimensional modeling, transformation frameworks, data quality infrastructure and standards. This critical data engineering role involves architecting and managing the processes and procedures for the complete data lifecycle—from comprehensive data collection and organization to detailed analysis. The right candidate can translate business requirements into production-grade technical implementations.

Working within the Engineering team in close partnership with the BI Product Owner, the  Senior BI Data Engineer is an experienced, self-motivated, and detail-oriented contributor that provides the technical depth the team needs to establish modern data engineering practices, select the right tooling, and build the foundation for scalable analytics capabilities. This individual acts as a core architect for both data warehouse structure and data presentation.

• Location: Hybrid / Remote in Rocklin, CA HQ - 2 days in office weekly
• Schedule: Monday-Friday, 8:00am-5:00pm
• Compensation: $145,000 - $174,000 Annually

The pay range for this role is $145,000 - $174,000 Annually. Starting pay for new hires is typically within the lower third of the range: $145,000-$154,667 Annually. Exceptions may be made based on factors such as education, specialized skills, or significant relevant experience.

Requirements

RESPONSIBILITIES

• As a member of the BI team, collaboratively design and engage engineering best practices (code review processes, git workflows, CI/CD, and version control for analytics code and database objects)
• Collaborate within the BI team to follow and keep up to date “Definition of Done” agreements
• Collaborate within the BI team to architect and design modern, scalable warehouse architecture (Snowflake: dimensional models for reporting)
• Evaluate and recommend modern orchestration and transformation tooling. Collaborate with the Director of Engineering on Build vs. Buy decisions for tools and infrastructure
• Collaborate within the BI Team to architect and design processes and standards for database object design including primary and foreign keys, audit columns, as well as establish naming conventions, and object standards
• Optimize warehouse performance via partitioning, clustering, query design and other processes to balance execution speed against cost
• Collaborate within the BI Team to build repeatable transformation patterns and establish standards for how data moves from raw ingestion through staging to reporting layers
• Collaborate within the BI Team to design and implement data quality monitoring frameworks including quarantine tables, alerts, and error handling
• Architect operational dashboards that track pipeline health, data freshness, volume anomalies, schema drift, changes in error rates, etc.
• Design and develop data warehouse structures to support Tableau explorer-users finding and working with the data they need
• Design and impleme