Data Warehouse Engineer

ECP is growing quickly and is looking for experienced engineers looking to join an amazing team and write great code to help make life better at senior living communities around the world.

ECP is a market-leading SaaS solution that enables senior living communities to better care for their residents. ECP is used in over 7,500 communities around the world. We're looking to further expand by increasing the number of customers that use our software and increasing the scope of how we serve our customers by developing and releasing new products. 

As a talented and experienced developer, you will jump right in and play a lead role as we build new applications, enhance and expand our product, improve our processes, and continuously tune and modernize our tech stack. You will join a talented and committed team, and you will have constant opportunities to learn about our business, work with state-of-the-art tools and technology, and build solutions that fuel our growth.

Our headquarters is in Wisconsin, but we are open to remote candidates within the U.S.

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.

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.

Benefits

ECP offers competitive insurance plans, a 401k match, and unlimited PTO.