Sacramento Data Engineer: Architect & Pipelines Expert

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

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.