Sr. Cloud Data Engineer

JOB DESCRIPTION

Title: Senior Cloud Data Engineer

Internal Job Description

Job Summary

Join our Data Engineering team as a Senior Cloud Data Engineer, where you will lead the development and implementation of data pipelines for our cloud-based enterprise data warehouse. This role will serve as a senior technical contributor within the data organization and will work closely with the AI and Automation and Data Insights teams to develop practical solutions that enhance data accessibility, enable natural language querying, and accelerate analytics insights across the enterprise.

The primary extraction platform is Netsmart's myAvatar electronic health record system, which uses InterSystems IRIS databases via ODBC connectors. The data warehousing technology is Snowflake, and the AI-enabled data integration platform is Matillion. The warehouse design uses a medallion architecture approach and is guided by the FHIR (Fast Healthcare Interoperability Resources) standard. Reporting domains include financial, operational, clinical, quality, and administrative metrics.

This is a hands-on engineering role expected to use AI to accelerate the development of data pipelines and contribute to the success of downstream business intelligence and AI initiatives. The Senior Cloud Data Engineer works with both technical and non-technical staff and relies on experience, judgment, and creativity to achieve objectives. Specific projects will vary widely depending on organizational need.

Essential Job Functions

• 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.

• Develop audit mechanisms to measure data accuracy and reduce resources required for systems support.

• Create features, functions, and data sets to enhance analysis or simplify report development.

• Monitor, refine, and resolve system performance issues.

• Develop and enforce database development standards.

• Recommend best practices for reporting and analytics.

• Develop technical documentation, including requirements, design decisions, system architecture, data models, and data dictionaries.

• Evaluate Snowflake and Matillion platform capabilities for potential adoption.

• Keep apprised of industry trends and learn new techniques and tools as appropriate.

• Function in accordance with operational guidelines and professional ethics.

• Participate in staff development activities.

• Other duties as assigned.

Knowledge, Skills, and Abilities

• 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 and Education 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.

• Experience with Netsmart myAvatar, healthcare analytics, and/or the InterSystems IRIS database platform preferred.

• Experience with Matillion data integration platform preferred.

Everforth Apex is a world-class IT services company that serves thousands of clients across the globe. When you join Everforth Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRateds Best of Staffing® in Talent Satisfaction in the United States and Great Place to Work® in the United Kingdom and Mexico.

Everforth Apex uses a virtual recruiter as part of the application process. Click here for more details. By applying for this job, you agree to receive calls, AI-generated calls, text messages, or emails from Everforth Apex and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy at

Everforth Apex Benefits Overview: 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.

Everforth Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Everforth Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law.

If you require an accommodation under the Americans with Disabilities Act to participate in an interview with a virtual recruiter or to use our website for a search or application, please contact our Benefits Department at [email protected] or View phone number on click.appcast.io. Please note that this contact information is strictly to be used for medical ADA accommodations and that no other inquiries will be answered.

UnitedHealthcare creates and publishes the Transparency in Coverage Machine-Readable Files on behalf of Everforth Apex Systems.