Amazon RedshiftAWSCloudETLKafkaPythonSparkSQLSSISTableauELTData EngineeringData WarehousingAnalyticsBIPower BISnowflakeRedshiftDatabricksdbtSQL Server
About this role
Role Overview
Design, build, and maintain scalable ETL/ELT pipelines using Python, SQL, Spark, and dbt to support BI solutions
Develop and manage data infrastructure across SQL Server and AWS environments
Support migration of on-premise systems to AWS cloud platforms
Maintain and optimize SSIS packages and existing data workflows
Design and implement data models (e.g., star schemas) optimized for reporting and analytics
Partner with BI Analysts using tools such as Power BI/Tableau to deliver client reporting and data-driven insights
Automate manual data processes using Python and SQL to improve efficiency and data quality
Document data pipelines, models, and infrastructure across AWS, SQL Server, and Databricks environments
Collaborate with Product, BI, and Engineering teams to support BI product development leveraging Snowflake, Redshift, or Databricks
Stay current with emerging data and BI technologies including Kafka, Spark, dbt, and cloud-native tools
Participate in client-facing sessions when needed (design discussions, presentations, training), showcasing solutions built on AWS and modern data platforms
Requirements
Bachelor’s or Master’s degree in Computer Science, Data Engineering, Statistics, or a related field
3–5 years of experience in data engineering, preferably supporting BI or analytics teams
Hands-on experience with AWS or other cloud platforms
Strong experience building data pipelines (cloud or on-premise) using Python, SQL, Spark
Solid understanding of data modeling for analytics and reporting (e.g., star schemas, data warehousing concepts)
Strong proficiency in SQL and Python
Experience with tools/technologies such as Spark, Kafka, Databricks, Snowflake, Amazon Redshift, and dbt
Familiarity with BI tools and reporting environments such as Power BI or Tableau
Experience with streaming data using Kafka or similar technologies is an asset
Tech Stack
Amazon Redshift
AWS
Cloud
ETL
Kafka
Python
Spark
SQL
SSIS
Tableau
Benefits
Thrive in an award-winning, innovation-driven culture that champions growth, embraces diversity, and fosters inclusion for all. See our awards →
Earn competitive pay with annual performance-based bonuses that recognize your impact
Invest in your future with our 401(k) plan featuring company matching
Stay healthy with comprehensive medical, dental, and vision coverage, plus HSA and FSA options
Recharge with paid vacation and sick days — and a paid day off for your birthday
Make an impact with two paid volunteer days to give back to your community
Advance your skills with free access to LinkedIn Learning and our education reimbursement program
Prioritize your mental health with a free premium Headspace membership
Stay active with our on-site fitness center (Tempe office only)
Refuel at fully stocked refreshment stations with complimentary drinks and snacks
Enjoy exclusive perks with access to “Tickets at Work” discounts and memberships