Data Warehouse Engineer (Remote)

ECP; Denver (CO); Remote; USD 80,000 - 120,000; Full time

Job summary

Join a forward-thinking company that is revolutionizing senior living through innovative SaaS solutions. As a key developer, you'll design and maintain data warehouses, optimize performance, and collaborate with a dedicated team to enhance our product offerings. This role offers the chance to work with cutting-edge technology and contribute to meaningful projects that improve the lives of residents in senior living communities. With a commitment to continuous learning and professional growth, this opportunity is perfect for those looking to make an impact while advancing their careers in a supportive environment.

Benefits

Competitive Insurance Plans

401k Match

Unlimited PTO

Qualifications

• 4+ years of software development experience with strong SQL skills.
• Experience with AWS services and data warehousing concepts.

Responsibilities

• Design and maintain enterprise data warehouses and data marts.
• Optimize data warehouse performance and troubleshoot issues.

Skills

SQL

Data Modeling

ETL Processes

Analytical Skills

Problem-Solving

Scripting (Python, Shell)

Agile Development

Communication Skills

Education

Bachelor's Degree in Computer Science

Tools

AWS Redshift

AWS Glue

AWS DMS

Job description

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.

Seniority level

Mid-Senior level

Employment type

Full-time

Job function

IT Services and IT Consulting