Sr. Cloud Data Engineer

About the role

The Senior Cloud Data Engineer leads the development and implementation of data pipelines for our cloud-based enterprise data warehouse. This role collaborates with the AI and Automation team to design semantic data models that support reliable AI-driven query generation.

Responsibilities

• Lead the design and maintenance of ETL processes, the data warehouse, and data model.
• Build scalable and efficient systems that accommodate business growth and reduce processing costs.
• Collaborate closely with the AI and Automation team to design semantic data models that support reliable AI-driven query generation.
• Determine and implement performance improvements for data architectures.
• Create features, functions, and data sets to enhance analysis or simplify report development.
• Maintain and resolve system performance issues.
• Develop audit mechanisms to measure data accuracy and reduce resources required for systems support.
• Develop and enforce database development standards.
• Recommend best practices for reporting and analytics.
• Create technical documentation, including requirements, design decisions, system architecture, data models, and data dictionaries.
• Evaluate Snowflake and Matillion platform capabilities for potential adoption.
• Stay updated on industry trends and learn new techniques and tools as appropriate.

Requirements

• Strong understanding of modern data warehouse architecture and analytics data modeling practices.
• Strong skills writing and optimizing complex SQL queries against diverse relational databases.
• Ability to communicate complex technical topics clearly to both technical and non-technical stakeholders.
• Self-directed problem solver capable of leading new technical initiatives.
• Knowledge of semantic data modeling and data governance principles.
• Ability to translate complex analytical questions into scalable technical solutions.
• Strong analytical and systems-thinking skills.
• Experience with Snowflake or a similar cloud-based data platform, required.
• Experience with Netsmart myAvatar, healthcare analytics, and/or the InterSystems IRIS database platform preferred.
• Experience with Matillion data integration platform preferred.

Qualifications

• Bachelor’s Degree or equivalent experience in Computer Science, Data Engineering, Data Science, Information Systems, or related field.
• 5+ years of experience with enterprise data warehousing and business intelligence solutions.
• Demonstrated experience building ETL pipelines in cloud-based enterprise environments.

Skills

• Strong understanding of modern data warehouse architecture and analytics data modeling practices.
• Strong skills writing and optimizing complex SQL queries against diverse relational databases.
• Ability to communicate complex technical topics clearly to both technical and non-technical stakeholders.
• Self-directed problem solver capable of leading new technical initiatives.
• Knowledge of semantic data modeling and data governance principles.
• Ability to translate complex analytical questions into scalable technical solutions.
• Strong analytical and systems-thinking skills.

Benefits

Everforth Apex offers a range of supplemental benefits, including medical, dental, vision, life, disability, and other insurance plans that offer an optional layer of financial protection. We offer an ESPP (employee stock purchase program) and a 401K program which allows you to contribute typically within 30 days of starting, with a company match after 12 months of tenure. Everforth Apex also offers a HSA (Health Savings Account on the HDHP plan), a SupportLinc Employee Assistance Program (EAP) with up to 8 free counseling sessions, a corporate discount savings program and other discounts. In terms of professional development, Everforth Apex hosts an on-demand training program, provides access to certification prep and a library of technical and leadership courses/books/seminars once you have 6+ months of tenure, and certification discounts and other perks to associations that include CompTIA and IIBA. Everforth Apex has a dedicated customer service team for our Consultants that can address questions around benefits and other resources, as well as a certified Career Coach. You can access a full list of our benefits, programs, support teams and resources within our ‘Welcome Packet’ as well, which an Everforth Apex team member can provide.