Sr Data Engineer

Job Title: Sr Data Engineer

Location: Irvine, CA (3 days work from office per week)

Duration: CTH

Purpose of the job:

The Senior Data Engineer will be part of a team designing and implementing our modern data platform to support enterprise-wide analytics, integration, and AI/ML initiatives. Together, the team will build a scalable enterprise data warehouse, enable modern visualization tools, and advance self-service analytics capabilities for business users.

Major Duties and Responsibilities:

Data Engineering & Pipeline Development – Design, build, and maintain scalable data pipelines and workflows in Snowflake, leveraging dbt for modular transformations and Fivetran for automated ingestion.

Enterprise Data Warehouse & Modeling – Architect and optimize the enterprise data warehouse, applying best practices in data modeling, performance tuning, and scalability to support enterprise-wide analytics.

Data Governance & Quality – Partner with governance teams to document cataloging, lineage, and stewardship, while ensuring data quality, security, and compliance.

Collaboration & Business Enablement – Work closely with business and analytics teams to translate requirements into scalable data solutions.

Cloud Integration & Infrastructure – Utilize AWS services (primarily S3) for data storage and integration, ensuring reliability, performance, and cost-effectiveness.

Education and Experience:

Required:

Bachelor’s degree in Computer Science, Data Engineering, Information Systems, or a related technical field.

5+ years of professional experience in data engineering or related roles.

Proven expertise with Snowflake for data pipelines, development, and optimization.

Strong experience with dbt for modular transformations and Fivetran for automated ingestion.

Solid background in data warehousing, dimensional modeling, and performance tuning.

Hands-on experience with AWS cloud services (especially S3) for data integration and storage.

Familiarity with data governance tools (Alation or Atlan) for cataloging, lineage, and stewardship.

Proficiency in SQL and comfort with scripting languages such as Python.

Preferred:

Master’s degree in a related field.

Experience with real-time/streaming technologies (e.g., Kafka, Kinesis, Flink).

Knowledge of data security, compliance, and access control best practices.

Exposure to AI/ML workflows and integrating data engineering solutions with ML pipelines.

Background in modern visualization platforms (Power BI, Tableau, Looker) to support self-service analytics.

Demonstrated ability to A39mentor junior engineers and contribute to engineering best practices.

Knowledge and skill level:

Snowflake (Expert) – deep expertise in data pipelines, query optimization, and enterprise-scale implementation.

dbt (Advanced) – strong ability to design modular, reusable transformations and maintain version-controlled models.

Fivetran (Advanced) – hands-on skill in managing ingestion pipelines and troubleshooting data connectors.

Data Warehousing & Data Modeling (Advanced) – proficiency in dimensional modeling, star/snowflake schemas, and performance tuning.

AWS Cloud (Intermediate) – working knowledge of S3 for storage and integration; familiarity with broader AWS data services a plus.

Data Governance (Intermediate) – understanding of metadata management, lineage, and cataloging.

SQL (Expert) – strong command of writing complex queries and optimizing performance.

Python (Intermediate) – ability to script automation, testing, and lightweight data transformations.

Collaboration & Communication – skilled in working with cross-functional teams and translating technical concepts to business stakeholders.

Emerging Tech & AI – awareness of how AI/ML can accelerate data engineering practices; willingness to experiment and learn.

ABOUT SONATA SOFTWARE

Sonata Software is an AI-first modernization engineering company that helps enterprises transform legacy systems into intelligent, scalable business platforms. Powered by its Platformation™ framework and Harmoni.AI platform, Sonata delivers AI-led modernization across cloud, data, AI, Dynamics, test automation, and managed services. Headquartered in Bengaluru, India, Sonata has more than $1.2 billion in revenue and 6,400+ AI engineers supporting global delivery across regions including the US, UK, India, Malaysia, Mexico, Australia, DACH, and the Nordics. With deep partnerships across Microsoft, AWS, Salesforce, and Snowflake, Sonata helps Fortune 500 enterprises accelerate innovation, improve efficiency, and drive sustainable growth.

For more information, please visit

"Sonata Software is an Equal Opportunity Employer encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, national origin, gender identity, age, religion, disability, sexual orientation, veteran status, marital status, or any other characteristics protected by law"