Analytics Engineer (Onsite)

G3 Enterprises; Modesto (CA); On-site; USD 62,000 - 77,000; Full time

Job summary

G3 Enterprises is seeking an Analytics Engineer to join the Data and Analytics team in California. You will bridge data engineering and analytics, ensuring data quality, and designing efficient models within a Databricks-based lakehouse.

You will model data in silver and gold layers, collaborate with stakeholders, and implement governance standards. The role requires strong SQL, data warehousing, and BI tooling experience.

Qualifications

• Bachelor’s degree plus 3 years analytics engineering or related role.
• Proven experience designing data models for analytics and reporting.
• Hands-on experience with data lake modeling concepts (star/snowflake) and governance practices.
• Strong SQL skills for data querying and transformation.

Responsibilities

• Plans, creates, and maintains data architecture to enable business decisions and scalable solutions.
• Implements data quality checks and validation across silver and gold layers.
• Collaborates with stakeholders to enforce data standards and governance.
• Designs datasets and referential data aligned with business goals.
• Executes data strategy related to G3’s data lake goals and objectives.
• Maintains documentation of data models, ERDs, governance, and quality rules.
• Monitors and tunes performance of data models and queries for analytics.
• Translates business requirements into functional and technical design solutions.
• Collaborates with development teams to deliver high quality data solutions.
• Engages analytics teams to identify data sources and validation standards.
• Develops test plans and supports promotions.
• Performs cross-functional analysis and presents findings to leadership.

Skills

SQL

Data modeling

Data quality

Databricks

Data governance

BI tools

CI/CD

ETL pipelines

Git

Education

Bachelor's degree

High School diploma

Tools

Databricks

Power BI

Tableau

Looker

Unity Catalog

SAP HANA

Job description

Summary

The Analytics Engineer plays a key role on the Data and Analytics team working at the intersection of data engineering and analytics ensuring data quality, designing efficient models, and maintaining data assets to enable seamless consumption by business users and analytics tools. Responsible for preparing and modeling data in the silver and gold layers of G3’s Databricks-based data lakehouse environment.

Collaborates across IT and with business stakeholders to define and enforce data standards and

understand data needs.

Essential Functions

This job description reflects management’s assignment of essential functions; it does not prescribe or restrict the tasks that may be assigned.

• Plans, creates, and maintains data architecture to enable business decisions and recommend technical solutions to management based on scalability and complexity.
• Implements and maintains robust data quality checks and validation processes to ensure high levels of data accuracy, consistency, and integrity across the silver and gold layers.
• Collaborates with stakeholders to define and enforce data standards, including master data management, develops data lineage understanding, while adhering to privacy and security policies.
• Partners with data scientists, analysts, and business stakeholders to understand data needs and design datasets and referential data that align with organizational goals.
• Responsible for executing the implementation of the data strategy related to G3’s data lake goals and objectives.
• Develops and maintains clear documentation of data models, entity relationship diagrams (ERDs), governance processes, and quality rules to ensure transparency and reproducibility.
• Monitors and enhances the performance of data models and queries to ensure efficient use of resources and support timely analytics.
• Works with data warehousing teams to understand and recreate data layer structures.
• Translates business requirements to functional and technical design solutions, specifications, and prototypes.
• Collaborates with development teams to design high quality data solutions to enable analytics.
• Consults with analytics teams, business users, and decision makers to identify data sources, required data elements, or data validation standards.
• Develops test plans and facilitates testing prior to promotions.
• Performs cross-functional analysis and collaborates with stakeholders across departments. Partners and presents findings to senior leadership.
• Responsible for understanding and complying with applicable quality, environmental and safety regulatory considerations.

Qualifications

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill and ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Minimum Qualifications

• Bachelor’s degree plus 3 years of experience in analytics engineering, technical architecture, database management, business intelligence, application development, middleware or a related role; OR Bachelor’s degree plus 2 years of G3 experience in analytics engineering, technical architecture, database management, business intelligence, application development, middleware or a related role; OR High School diploma or State-issued equivalency certificate plus 7 years of experience in analytics engineering, technical architecture, database management, business intelligence, application development, middleware or a related role; OR High School diploma or State-issued equivalency certificate plus 6 years of G3 experience in analytics engineering, technical architecture, database management, business intelligence, application development, middleware or a related role.
• Proven experience in designing and maintaining data models for analytics and reporting.
• Hands-on experience with data lake modeling concepts and frameworks (e.g., star schema, snowflake schema), implementing data quality and governance practices.
• Strong SQL skills for data querying and transformation.

Preferred Qualifications

• Bachelor's degree in Computer Science, Business Administration, Mathematics, Data Analytics, Data Science, or Engineering.
• Experience with cloud computing and “big data” processing and analytics.
• Proficiency in Databricks and the Delta Lake architecture.
• Familiarity with Databricks SQL and Unity Catalog for data governance.
• Experience with BI tools like MicroStrategy, Power BI, Tableau, or Looker to validate and test analytics-ready data models.
• Knowledge of CI/CD processes and tools like Git for managing code and configurations.
• Understanding of cloud environments (e.g., Azure, AWS, GCP) and related storage and compute services.
• Understanding of web servers and applications.
• Knowledge of components of an enterprise systems architecture
• Knowledge of business process re-engineering processes including Lean Six Sigma principles.
• Lean Six Sigma Green or Black Belt Certified.
• Strong understanding of network architecture and application development methodologies
• Experience reading, analyzing, and interpreting common scientific and technical journals and financial reports.
• Knowledge of emerging technologies and development platforms.
• Experience applying machine learning or artificial intelligence to BI applications.
• Experience with performance tuning of business intelligence applications.
• Strong knowledge of SQL queries including writing, reading, and debugging.
• Experience working with Enterprise Data Warehousing, specifically SAP Data Warehousing (HANA).
• Possesses a passion for technology and its impact on the enterprise, customers and consumers along with a breadth of experience that can balance business, application and operational requirements.
• Strong understanding of systems and “systems thinking” with the ability to make trade-off decisions to accomplish system-wide goals.
• Skilled in navigating complex situations to ensure successful change management and balancing long-term and short-term goals and perspectives.
• Excellent written and verbal communication skills, with the ability to document processes and technical specifications clearly.
• Exceptional interpersonal skills, including teamwork, facilitation and negotiation.
• Excellent planning and organizational skills.
• Excellent analytical and technical skills. Skilled in applying multiple technical solutions to business problems.
• Remains unbiased toward any specific technology or vendor choice.
• Demonstrates strong technical thinking.

Physical Demands

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this job, the employee is frequently required to sit, use hands to finger, handle, feel, talk and hear. The employee is occasionally required to stand and walk.

Work Environment

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

The noise level in the work environment is usually moderate.

Compensation

Hiring Hourly Rate: $45.10 - $56.35

Actual compensation amount paid may be lower or higher to be determined by factors other than race and gender such as the education, experience, knowledge, skills and abilities of the applicant, internal equity, and alignment with market data.

Perks & Benefits

This position includes a competitive benefits package.