Data Warehouse Engineer

Summary

Join ECP, a market-leading SaaS solution for senior living communities, as a talented developer to play a lead role in building new applications, enhancing our product, improving processes, and modernizing our tech stack. You will work with a committed team, utilize state-of-the-art tools, and build solutions that fuel our growth. We are open to remote candidates within the U.S. The position requires significant experience in data warehousing and related technologies. ECP offers competitive benefits, including insurance plans, 401k matching, and unlimited PTO.

Requirements

• Bachelor’s Degree in Computer Science or related field
• 4+ years software development experience
• Strong proficiency in SQL and database design
• Experience with AWS Redshift, AWS DMS, and AWS Glue
• Knowledge of data modeling techniques (dimensional and snowflake)
• Understanding of ETL processes and data warehousing concepts
• Proficiency in scripting languages (Python, Shell, etc.) for automation
• Experience with data quality tools and techniques
• Strong analytical and problem-solving skills
• Ability to work independently and as part of a team
• Excellent communication and documentation skills
• Experience working in an agile development process
• Fluent English, grammatical skills
• Legally authorized to work in the United States without sponsorship

Responsibilities

• Design, develop, and maintain enterprise data warehouses and data marts
• Extract, transform, and load (ETL/ELT) data from various sources into the AWS Redshift using AWS Glue
• Create and maintain the data pipeline using tools like AWS DMS
• Optimize data warehouse performance and query execution
• Create and maintain complex SQL queries and stored procedures
• Develop and implement data quality checks and monitoring processes
• Collaborate with data analysts and business users to understand their data needs
• Design and implement data models, including dimensional and snowflake schemas
• Troubleshoot data quality issues and performance problems
• Stay up-to-date with the latest data warehouse technologies and best practices

Benefits

• Competitive insurance plans
• A 401k match
• Unlimited PTO