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.

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

• 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 frameworks
• Collaborate with the BI Team to create automated data quality monitoring, including: quarantine tables, alerts, and error handling
• Conduct in-depth data analysis to uncover trends, patterns, and correlations that drive business decisions
• Architect and design 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 the linked data they need
• Establish version control practices for analytics code and database objects
• Perform complex statistical analyses and hypothesis testing to support strategic initiatives
• Design and implement data processes and automation to enhance efficiency and accuracy
• Confidently provide detailed insights and recommendations based on data analysis to influence business strategies
• Provide support on data use and analysis to BI Developers, including SQL, structuring views, creating stored procedures and database analysis tasks
• Ensure compliance with data integrity, security, and company policies in all analytical tasks
• Stay…