Data Engineer at McSweeney Auto Group

Redwood City, California, United States -

Full Time

Start Date

Immediate

Expiry Date

27 Aug, 26

Salary

140000.0

Posted On

29 May, 26

Experience

2 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

SQL, Data Modeling, AWS, Databricks, DBT, Dimensional Modeling, Data Marts, Medallion Schemas, API Integration, Data Pipeline Design, ETL, Financial Data Integration

Industry

Construction

Description

What You Will Do Build and Own Core Datasets. Design and maintain datasets that serve as sources of truth for key business reporting and decision making. Ensure datasets are accurate, consistent, and understandable by a broad set of stakeholders. Explore and Understand Source Systems. Develop a working understanding of source systems such as NetSuite, Salesforce, Autodesk Construction Cloud, Bill.com, and other operational platforms. Understand how data is generated and how it maps to business processes. Design Scalable Data Pipelines. Build, maintain, and monitor production data pipelines that meet current analytical needs and scale as data volume and complexity increase. Enable Access to High Quality Data. Help democratize access to reliable operational and financial data across Finance, Operations, and go-to-market teams. Ensure data products are well documented and suitable for self-service analytics. Continuously Expand Analytical Coverage. Identify opportunities for new tables, metrics, and derived datasets that unlock additional insight. Evaluate work based on clarity and usefulness to decision-makers. Establish Data Standards and Best Practices. Evolve standards for data modeling, testing, documentation, and ownership. What We Are Looking For 1-3 years experience as a data engineer, building core datasets and supporting business verticals as needed. You have hands-on experience shipping scalable data solutions in the cloud (e.g AWS, Databricks, DBT), across multiple data methodologies (e.g dimensional modeling, data marts, medallion schemas) Strong SQL and Data Modeling Skills. Advanced SQL proficiency with experience designing analytical data models that support reporting and analytics use cases. Comfort exploring source systems and tracing data through multiple layers of transformation. Ability and willingness to learn new systems, tools, and business domains. Comfortable working in environments where requirements and priorities evolve. Nice to Haves Experience integrating financial, ERP, CRM, or payment systems such as NetSuite, Salesforce, Bill.com or similar tools. Comfort in aggregating data from multiple sources, with proficiency in handling APIs, geospatial imagery/aerial photography, unstructured web data, and public governmental records. Experience supporting feature engineering, forecasting, or AI-adjacent analytics. You don’t need to be an AI expert, but you’re curious and willing to adopt AI tools to work smarter and deliver better results Why Join Us Be the first dedicated data engineer responsible for shaping how data is modeled, validated, and trusted across the company. Build datasets that support company wide reporting and decision making as the business scales. Work directly with leadership and cross functional teams to turn data into usable insight. Join a mission driven team solving California’s housing shortage through design, modular innovation, and responsible development. Gain equity ownership in a Series B startup positioned for rapid growth. What We Offer Salary range of $120-140K and performance-based bonuses. Hybrid work schedule with 3 days each week in our Redwood City office. Snacks and Lunch on days in-office. Early stage employee equity. Exceptional health, dental, and vision insurance. 401k eligibility after 6 months. Flexible PTO policy.

Responsibilities

Build and maintain core datasets and scalable data pipelines to serve as the source of truth for business reporting. Collaborate with cross-functional teams to democratize access to high-quality operational and financial data.