BI Engineer IV

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.

The BI (Business Intelligence) Engineer IV’s purpose at Gemini is to organize and design: comprehensive data collection, organization, analysis, and support: sculpting enterprise-quality data warehouse solutions that support fast visualization providing actionable insights that support strategic business decisions. This role involves managing ETL, architecting, designing and implementing data warehouse solutions (including OLAP), complex dashboards and reports, and performing detailed statistical analyses using professional-grade indicators.

As a member of the Engineering team, the BI Engineer IV is an experienced, detail-oriented, and self-motivated architect both in terms of data warehouse structure and data presentation.

The BI (Business Intelligence) Engineer IV at Gemini is responsible for designing and implementing enterprise-quality data warehouse solutions. This critical role involves architecting and managing the complete data lifecycle—from comprehensive data collection and organization to detailed analysis. The ultimate goal is to sculpt solutions, including OLAP, that provide fast visualization and actionable insights, supporting strategic business decisions.

As an experienced, self-motivated, and detail-oriented member of the Engineering team, the BI Engineer IV will manage ETL processes, design complex dashboards and reports, and perform detailed statistical analyses using professional-grade indicators. This individual acts as a core architect for both data warehouse structure and data presentation.

• Location: Hybrid / Remote in Rocklin, CA HQ
• 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.

• In collaboration with the BI team, design and engage engineering best practices (code review processes, git workflows, CI/CD)
• Collaborate with the BI team to follow and keep up to date “Definition of Done” agreements
• Collaborating with the BI team to architect and design modern, scalable warehouse architecture (Snowflake: dimensional models for reporting)
• Evaluating and recommending data transformation methodologies, frameworks and tools
• Collaborate with the Director of Engineering on Build vs. Buy decisions for tools and infrastructure
• Collaborate with the BI Team to architect and design processes and standards for table design include primary and foreign keys, and audit columns
• Optimize warehouse performance via partitioning, clustering, query design and other processes to balance fast execution versus spend
• Collaborate with the BI Team to build repeatable transformation patterns and establish the standard use of…