Sr Data Engineer
Sonata Software8 days ago
San Antonio, TX, USASenior
Responsibilities
- Design, build, and maintain scalable data pipelines and workflows in Snowflake using dbt and Fivetran.
- Architect and optimize enterprise data warehouse solutions through dimensional modeling, performance tuning, and scalability improvements.
- Support data governance, cataloging, lineage, stewardship, data quality, security, and compliance.
- Partner with business and analytics teams to translate requirements into scalable data solutions.
- Use AWS services, primarily S3, for data storage and integration while ensuring reliability, performance, and cost-effectiveness.
- Mentor junior engineers and contribute to engineering best practices.
Requirements
- Bachelor’s degree in Computer Science, Data Engineering, Information Systems, or a related technical field.
- At least 5 years of professional experience in data engineering or related roles.
- Expertise with Snowflake for data pipelines, development, query optimization, and enterprise-scale implementation.
- Strong experience with dbt modular transformations and Fivetran automated ingestion pipelines.
- Experience with data warehousing, dimensional modeling, star and snowflake schemas, and performance tuning.
- Hands-on experience with AWS cloud services, especially S3, for data integration and storage.
- Familiarity with Alation or Atlan for data cataloging, lineage, and stewardship.
- Proficiency in SQL and scripting with Python.
- Preferred qualifications include a related master’s degree, streaming technology experience with Kafka, Kinesis, or Flink, knowledge of data security and compliance, exposure to AI/ML workflows, experience with Power BI, Tableau, or Looker, and the ability to mentor junior engineers.
Benefits
- Contract-to-hire position.
- Based in Irvine, California, with 3 days working from the office per week.
Tech Stack
Categories
Data Engineering