Data Engineer: Architect Data Pipelines & Warehouses

4Insite, LLC; Sacramento (CA); On-site; USD 118,000 - 130,000; Full time

Job summary

SBM Management Services, LP in Sacramento, CA is seeking a Data Engineer to design, evolve, and govern the data architecture supporting internal applications. This role 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.

You will work with the Integrations Engineer and other technology teams to ensure alignment of data initiatives with analytics, reliability, and

Qualifications

• Bachelor’s degree in computer science, information systems, engineering, statistics, or a related field.
• 5+ years in data engineering, database engineering, data architecture, or related discipline.
• Advanced experience designing relational data models and crafting complex SQL queries.
• Experience with Python to develop data pipelines, automation, and tooling.
• Knowledge of data warehousing, ETL/ELT, data marts, and analytics workloads.

Responsibilities

• Define and own the data architecture and implementation approach for internal systems and BI solutions.
• Design, build, test, document, and monitor data pipelines using SQL, PostgreSQL, Python, and other platform technologies.
• Collaborate with the Integrations Engineer to define data contracts and architectural boundaries.
• Advise stakeholders on database, data-modeling, and data-platform decisions.

Skills

Data modeling

SQL

Python

Data warehousing

Analytical thinking

Education

Bachelor's degree in Computer Science or related field

Tools

PostgreSQL

SQL Server

Amazon Redshift

AWS

Python

Job description

SBM Management Services, LP in Sacramento, CA is seeking a Data Engineer to design, evolve, and govern the data architecture supporting internal applications. This role 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.

You will work with the Integrations Engineer and other technology teams to ensure alignment of data initiatives with analytics, reliability, and