Analytics Engineer

G3 Enterprises; Modesto (CA); On-site; USD 94,000 - 117,000; Full time

Job summary

G3 Enterprises seeks an Analytics Engineer to bridge data engineering and analytics, ensuring data quality and building robust data assets in a Databricks-based lakehouse.

You will model data in silver/gold layers, define standards, and collaborate with IT and business stakeholders to deliver analytics-ready datasets for stakeholders and BI tools.

Qualifications

• Bachelor's degree plus 3 years analytics engineering, technical architecture, database management, BI, or related role; or 2 years in G3 analytics engineering; or high school plus 7 years analytics engineering/related role; or high school plus 6 years in G3 analytics engineering/related role.
• Proven experience designing and maintaining data models for analytics and reporting.
• Hands-on data lake modeling concepts and governance practices.

Responsibilities

• Designs data architectures to enable business decisions and scalable solutions.
• Develops and enforces data quality controls for silver and gold layers.
• Collaborates to define data standards, lineage, and governance.

Skills

SQL

Data modeling

Databricks

ETL

Data governance

Education

Bachelor's degree

Tools

Databricks

SQL

Power BI

Tableau

Looker

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.

This position includes a competitive benefits package. Please click here to view our full list of benefits.

Equal Employment Opportunity Statement

G3 is enrolled in the Department of Homeland Security's E-Verifying program and will use the program to verify the employment eligibility of all newly hired employees as required. G3 does not sponsor for employment based visas for this position now or in the future.