Senior Data Engineer
Firstup Chicago, Illinois, United States
Software Development · 201-500 employees
About the role
The Senior Data Engineer will design, build, and maintain scalable data pipelines and warehouse models while integrating GenAI techniques to improve data accessibility. They will also collaborate across teams to ensure data quality, support production systems, and evolve the company's data architecture.
What they look for
Requirements
Candidates must have at least 8 years of experience in building large-scale distributed systems and data pipelines. Proficiency in SQL, Python, and experience with cloud platforms like AWS or GCP are required, along with a bachelor's degree in a related field.
Benefits
Full description
Who We Are
At Firstup, our mission is to improve the employee experience at every moment that matters, large and small. As the communication pipeline for the world's workforce, we now serve 40 of the Fortune 100 companies, reaching and connecting more than 17 million employees daily.
Our employees are experts in the employee experience, workforce communications and technology.
Joining Firstup means joining a movement to make work better for every worker. As the world’s first intelligent communication platform, Firstup meaningfully engages employees at every moment from hire to retire, and delivers engagement insights to help companies support, promote and retain their talent. Our movement has taken root and is evident in our world-class customer base. Now we need your help. Ready to make a difference in the world?
The Senior Data Engineer will design and build reliable data solutions that translate complex product and business logic into scalable, well-tested data models and pipelines. This role requires deep expertise in SQL, query acceleration, and applying GenAI to both engineering workflows and data/analytics interfaces. They will partner across engineering, analytics, and business teams, contribute to shared codebases, improve data quality and observability, and help evolve the data architecture.
\n
Responsibilities
• Design, build, and maintain scalable data pipelines, warehouse models, and analytics solutions, balancing data quality, business value, and speed.
• Build and maintain natural language interfaces to data and analytics, applying GenAI/LLM techniques to make data more accessible across the business.
• Use GenAI coding tools and practices in daily development to improve code quality, testing, and delivery speed.
• Continuously evaluate new technologies that could improve and scale the team's data platform and technology stack.
• Establish and follow standards for SQL development, data modeling, testing, documentation, code reviews, and production support.
• Support production data pipelines through on-call rotation and incident response, partnering with engineering, analytics, and business teams.
• Document and maintain expertise in the technology stack and product domain, translating business needs into technical solutions with product management.
Minimum Qualifications
• Bachelor's degree in Computer Science or related field, or equivalent professional experience
• 8+ years building reliable, high-performance, large-scale distributed systems, with an emphasis on streaming and data pipelines
• Experience working with and maintaining multi-tenant SaaS experiences
• Experience building natural language interfaces over data warehouses, including applying GenAI/LLM techniques to data and analytics
• Enterprise-level experience with at least one large-scale analytical data warehouse or query engine: StarRocks, Amazon Redshift, Snowflake, Databricks, or Trino
• Expertise writing, optimizing, and analyzing SQL
• Hands-on experience building and operating distributed data platforms on AWS or GCP
• Hands-on experience with streaming platforms such as Kafka and Spark
• Experience scaling data modeling and warehousing
• Proficiency in python.
Preferred Qualifications
• Experience with Cube or other semantic layers
• Experience with scheduling tools such as Airflow
• Familiarity with the BI tool Metabase
• Proficiency in Ruby on Rails, React, or other adjacent languages.
\nThe starting rate of pay may vary based on factors including, but not limited to, position offered, location, education, training, and/or experience.
Why Firstup?
Because you care - about people, the work you do, and the connections you make. Work is such a large part of life; it only makes sense to make it awesome.
If you want to engage brilliant minds in a high-growth and inclusive environment where ideas are rewarded regardless of who they come from, join us. This is a rapidly changing space so if you thrive on ambiguity, are hungry for a challenge, and have the guts to speak your mind, you could be a perfect fit.
We offer an excellent PTO program, great health benefits, a casual and friendly environment, remote work, and a leadership team who truly believes in your growth – both personally and professionally.
Firstup is committed to providing equal employment opportunities to all applicants for employment and to all employees, without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, protected disability, veteran status, or any other protected status in accordance with applicable federal, state or local laws.
#LI-TM1
#LI-Remote
Similar roles
-
Senior Data Engineer R&D
MSD Prague, Prague, Czechia
-
Sr Data Engineer
Porch Group India
-
FBS SAP Informatica Power Center Data Engineer
Capgemini Mexico
-
Forward Deployed Data Engineer
Total Performance Consulting Georgia, United States
-
Senior Data Engineer - Algolia
Perficient Bogota, RAP (Especial) Central, Colombia
-
Senior Data Engineer - Tableau
Perficient Bogota, RAP (Especial) Central, Colombia