Data Architect and Engineer

Largeton Group; Sacramento (CA); On-site; USD 120,000 - 180,000; Full time

Job summary

The Largeton Group seeks a Data Architect and Engineer to design and implement automated data pipelines from public portals, APIs, and internal systems into Delta tables. You will collaborate with program management on platform architecture, naming standards, and documentation.

Partner with data governance to define data contracts, ownership, and quality standards, advise on data protection strategies, and establish monitoring and data quality checks.

Qualifications

• 7+ years of experience in data engineering or closely related roles.
• Proven background in large-scale, enterprise-wide data architecture or engineering projects.
• Strong skills in Python and SQL.
• Experience with Apache Spark or leading cloud data platforms (Databricks strongly preferred).
• Skilled in extracting data from REST APIs, databases, or other systems.
• Excellent communication and documentation abilities.

Responsibilities

• Design and implement automated data pipelines to integrate data from public portals, APIs, and internal systems into Delta tables.
• Collaborate with program manager on platform architecture, naming standards, and comprehensive documentation.
• Partner with data governance teams to define architecture, data sharing protocols, data contracts, ownership, and quality standards.
• Advise on data protection strategies including row-level and column-level access controls for sensitive data.
• Establish monitoring, alerts, and quality checks to ensure reliability and integrity of the data.
• Prepare datasets and documentation to make data easily accessible and explorable for business users and AI tools.
• Develop and maintain instruction (skill) files for consistent pipeline creation and support AI coding assistants.
• Assist other departments in building pipelines using standardized templates and best practices.
• Maintain clear communication and thorough documentation throughout the project.

Skills

Python

SQL

REST APIs

Tools

Apache Spark

Databricks

Job description

• Design and implement automated data pipelines to integrate data from public portals, APIs, and internal systems into Delta tables.
• Collaborate with program manager on platform architecture, naming standards, and comprehensive documentation.
• Partner with data governance teams to define architecture, data sharing protocols, data contracts, ownership, and quality standards.
• Advise on data protection strategies including row-level and column-level access controls for sensitive data.
• Establish monitoring, alerts, and quality checks to ensure reliability and integrity of the data.
• Prepare datasets and documentation to make data easily accessible and explorable for business users and AI tools.
• Develop and maintain instruction (skill) files for consistent pipeline creation and support AI coding assistants.
• Assist other departments in building pipelines using standardized templates and best practices.
• Maintain clear communication and thorough documentation throughout the project.

Job Summary Data Architect And Engineer

• Design and implement automated data pipelines to integrate data from public portals, APIs, and internal systems into Delta tables.
• Collaborate with program manager on platform architecture, naming standards, and comprehensive documentation.
• Partner with data governance teams to define architecture, data sharing protocols, data contracts, ownership, and quality standards.
• Advise on data protection strategies including row-level and column-level access controls for sensitive data.
• Establish monitoring, alerts, and quality checks to ensure reliability and integrity of the data.
• Prepare datasets and documentation to make data easily accessible and explorable for business users and AI tools.
• Develop and maintain instruction (skill) files for consistent pipeline creation and support AI coding assistants.
• Assist other departments in building pipelines using standardized templates and best practices.
• Maintain clear communication and thorough documentation throughout the project.

Requirements

• 7+ years of experience in data engineering or closely related roles.
• Proven background in large-scale, enterprise-wide data architecture or engineering projects.
• Strong skills in Python and SQL.
• Experience with Apache Spark or leading cloud data platforms (Databricks strongly preferred).
• Skilled in extracting data from REST APIs, databases, or other systems.
• Excellent communication and documentation abilities.