Data Engineer

Pacific West Site Services, Inc.; Sacramento (CA); On-site; USD 118,000 - 130,000; Full time

Job summary

SBM Management Services, LP in Sacramento is seeking a Data Engineer to design and govern the data architecture for internal systems and BI solutions. You will own the architecture of existing databases, develop scalable data models and pipelines, and evaluate migration to a data warehouse, collaborating with the Integrations Engineer and other tech teams.

The role requires 5+ years in data engineering, strong SQL and Python skills, and experience with PostgreSQL/Redshift.

Qualifications

• Bachelor’s degree in computer science, information systems, engineering, statistics, or related field, or equivalent experience.
• 5+ years of relevant data engineering, database engineering, data architecture, BI engineering, or related discipline.
• Advanced experience designing relational data models and writing, tuning complex SQL queries for production workloads and large data sets.
• Strong experience using Python to develop data pipelines, automation, validation, and tooling.

Responsibilities

• Define and own the data architecture and implementation approach for internal application systems and BI solutions.
• Design, build, test, document, and monitor reliable data pipelines.
• Interface with other technology teams to extract, transform, and load data from diverse sources.
• Advise stakeholders on database, data-modeling, pipeline, and data-platform decisions; document tradeoffs and risks.
• continually improve reporting and self-service analytics for customers.

Skills

SQL

Python

Data modeling

ETL/ELT design

Data warehousing

AWS

PostgreSQL

Education

Bachelor’s degree in computer science, information systems, engineering, statistics, or a related technical field

Tools

SQL Server

Amazon Redshift

PostgreSQL

Job description

# Title:
Data Engineer

Job Description:

NOW HIRING: Data Engineer

Compensation: $118,000-$130,000 per year

This role will be on-site in our Sacramento Office.

Job Overview

The Data Engineer will design, evolve, and govern the data architecture supporting the organization’s internally developed application systems. This position will own the architecture of existing operational databases, develop scalable data models and pipelines, and evaluate the transition of appropriate data assets into a data warehouse. Working closely with the dedicated Integrations Engineer and other technology teams, the Data Engineer will provide architectural direction that aligns application, integration, analytics, reliability, and reporting needs.

Roles & Responsibilities

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. Other duties may be assigned.

Architecture & Implementation Ownership:

• - Define and own the data architecture and implementation approach for internally developed application systems and business intelligence solutions, applying appropriate database technologies, data platforms, modeling techniques, and architectural patterns.
• - Ensure completeness and compatibility of the technical infrastructure to support system performance, availability, and architecture requirements.
• - Define the target-state architecture and migration roadmap for internal application databases and a potential data warehouse, including the separation of operational and analytical workloads.
• - Establish/maintain standards for schema design, normalization and denormalization, indexing, query performance, data retention, lineage, metadata, security, backup, recovery, and database change management.

Integration Team Partnership:

• - Partner with the dedicated Integrations Engineer to define data contracts, source-of-truth ownership, integration patterns, schema-change practices, and architectural boundaries between application databases and integration services.
• - Design, build, test, document, and monitor reliable batch and event-driven data pipelines using SQL, PostgreSQL, Python, and other approved platform technologies.
• - Interface with other technology teams to extract, transform, and load data from a wide variety of data sources.

Operational Support:

• - Advise product owners, program managers, developers, and internal technology leaders on database, data-modeling, pipeline, and data-platform decisions, documenting recommendations, tradeoffs, and risks.
• - Continually improve ongoing reporting and analysis processes, automating or simplifying self-service support for customers.

Qualification

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/or ability required. Other duties, responsibilities and activities may change or be assigned at any time with or without notice.

Education and/or Experience

Bachelor’s degree in computer science, information systems, engineering, statistics, or a related technical field, or an equivalent combination of education and relevant experience.

5+ years of relevant experience in data engineering, database engineering, data architecture, business intelligence engineering, or a related discipline, including substantial responsibility for production database design and data pipelines.

Advanced experience designing relational data models and writing, reviewing, and tuning complex SQL queries for production workloads and large data sets.

Strong experience using Python or a comparable programming language to develop data pipelines, automation, validation, and operational tooling.

Certificates, Licenses, Registrations

A valid driver's license may be required for this position based on business needs. Employees required to drive as part of their job duties must maintain an acceptable Motor Vehicle Record (MVR) and meet company driving eligibility requirements.

Knowledge, Skills, and Abilities

Demonstrated strength in relational and dimensional data modeling, ETL and ELT design, data warehousing, data marts, and the separation of operational and analytical workloads.

Strong experience with PostgreSQL and relational database architecture; experience with SQL Server, Amazon Redshift, or comparable analytical platforms is preferred.

Experience designing data solutions on AWS using relevant managed database, storage, compute, integration, monitoring, security, and analytics services.

Ability to evaluate alternatives, document architecture decisions, explain technical tradeoffs to technical and nontechnical stakeholders, and influence implementation without direct supervisory authority.

Knowledge of distributed systems as it pertains to data storage and computing.

Supervisory Responsibilities

This position has no supervisory responsibilities.

Physical Demands & Work Environment

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 and talk or hear. The employee is occasionally required to stand; walk and stoop, kneel, crouch, or crawl. The employee must regularly lift and/or move up to 10 pounds, frequently lift and/or move up to 25 pounds and occasionally lift and/or move up to 35 pounds.

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. The noise level in the work environment is usually quiet.

Benefits:

SBM offers comprehensive benefit packages. For information about SBM's benefits, please visit SBM's website at:

www.sbmmanagement.com/careers Careers – SBM

SBM Management Services, LP and its affiliates are proud to be equal opportunity workplaces. We are committed to equal employment opportunity regardless of race, sex, color, ancestry, religion, national origin, sexual orientation, citizenship, age, marital status, disability, gender identity, Veteran status, or other legally protected status.