Senior Data Engineer

Senior Data Engineer

UST

Chicago, IL • On-site

$109.30K - $148.50K/yr

Full-time

Posted 6 days ago


UST rating

8.8

Company rating: 8.8 out of 10

Based on 6 frontline employees who took The Breakroom Quiz

25th of 422 rated business services


Job description

Job Summary:
UST is a mission-driven company that transforms lives through technology. They are seeking a Senior Data Engineer to design, build, and optimize scalable data pipelines and modern data platforms, ensuring high-performance data solutions for analytics and business intelligence in a cloud-native environment.
Responsibilities:
• Design, develop, and maintain scalable ETL/ELT pipelines using Python and PySpark for batch and streaming workloads.
• Build and manage data lake / lakehouse architectures (Bronze/Silver/Gold layers) to support enterprise analytics.
• Optimize Spark jobs for performance, scalability, and cost efficiency using best practices.
• Work with AWS services such as S3, Glue, EMR, Lambda, and Step Functions to integrate and orchestrate data workflows.
• Implement data quality, validation, and monitoring frameworks to ensure data reliability and integrity.
• Collaborate with cross-functional teams (Data, Platform, Application teams) to deliver end-to-end data solutions.
Qualifications:
Required:
• 4+ years of experience in Data Engineering / Software Development.
• Strong proficiency in Python programming (data structures, OOP, design patterns).
• Hands-on experience in PySpark and Spark ecosystem including DataFrames, Spark SQL, and Spark Streaming.
• Experience in building large-scale ETL/ELT pipelines.
• Strong knowledge of data modeling and data lake architecture (Bronze/Silver/Gold).
• Expertise with file formats such as Parquet, Avro, JSON.
• Knowledge of data quality, validation, and governance practices.
• Hands-on experience with AWS Glue (ETL jobs, Data Catalog, workflows).
• Hands-on experience with Amazon EMR (cluster management, scaling, optimization).
• Hands-on experience with Amazon S3 (data lake design, partitioning, lifecycle).
• Hands-on experience with AWS Lambda (serverless integrations).
• Experience with orchestration tools: AWS Step Functions / Airflow (MWAA).
• Monitoring via CloudWatch (logs, metrics, s).
• Strong experience in Spark performance tuning and optimization.
• Handling large datasets with focus on efficiency and cost optimization.
• Experience with CI/CD pipelines (CodePipeline, CodeBuild, CodeDeploy).
• Familiarity with Infrastructure as Code (Terraform/CloudFormation).
• Strong focus on testing and code quality (pytest, unit/integration testing, PEP 8 standards).
• Strong analytical and problem-solving skills.
• Excellent communication and stakeholder collaboration abilities.
• Ability to work independently and in Agile environments.
Company:
UST is a Digital Transformations Solutions Provider. Founded in 1999, the company is headquartered in Aliso Viejo, USA, with a team of 10001+ employees. The company is currently Late Stage.


Frequently asked questions

Q: What skills or qualities help someone succeed as a Senior Database Engineer?

A: To succeed as a Senior Database Engineer, key technical skills include expertise in database management systems (DBMS) such as MySQL, PostgreSQL, or Oracle, as well as proficiency in programming languages like SQL, Python, or Java. Additionally, soft skills like strong communication, problem-solving, and analytical abilities are crucial for collaborating with cross-functional teams, troubleshooting complex database issues, and making informed technical decisions. These strengths enable Senior Database Engineers to effectively design, implement, and optimize database solutions, driving business growth and career advancement through their technical expertise and leadership.

Q: What is the career path for a Senior Database Engineer?

A: A Senior Database Engineer's typical career progression involves starting as a Junior/Associate Database Engineer, progressing to a Database Engineer/Developer, and then advancing to a Senior Database Engineer, with key responsibilities including designing, implementing, and optimizing database systems. Along the way, they can develop skills in areas such as data modeling, query optimization, and database administration, as well as programming languages like SQL, Python, and Java, and cloud platforms like AWS and Azure. With experience and expertise, Senior Database Engineers can transition into leadership roles, such as Technical Lead or Database Architect, or pursue specialized areas like Data Science, Business Intelligence, or DevOps.



UST job posting for a Senior Data Engineer in Chicago, IL with a salary of $109,300 to $148,500 Annually with a map of Chicago location.