Database Engineer II

Role Description

Under general supervision, the Database Engineer II is responsible for the overall development, testing and move to production of database products built in a cloud environment.

• Designs and creates moderately complex data models.
• Develops and implements data products to support business needs.
• Analyzes and determines informational needs and elements, data relationships and attributes, proposed manipulation, data flow and storage requirements, and data output and reporting capabilities.
• Defines logical attributes and inter-relationships and designs data structures to accommodate business needs.
• Tests designed applications utilizing database management software or general programming software.
• Gathers system metrics pertaining to the running of data products to identify and resolve problems; determines and develops performance enhancements with measurable benchmarks.
• Works with DBA and Productions Services staff to monitor the running of data products to identify and resolve problems; continues performance enhancement with measurable benchmarks.
• Owns the design/modeling portion of data projects through all project stages, preparing a technical design that reflects business requirements and is consistent with IT Strategy and overall IT Architecture.
• Evaluates new technologies and develops project proposals for new IT services, including pilots and production applications and services.
• Works under minimal supervision with latitude for independent judgment.
• May consult with senior peers on certain projects.
• Mentors junior Database Engineers.
• Other duties as assigned.

Qualifications

• Bachelor’s degree in Computer Science or related field.
• Minimum 3 years of Data Management experience proposing, documenting technology solutions and development experience with a focus on database architecture and data integration.
• 5+ years of expertise working with Data in a hands-on, developer role with advanced engineering principles and analytics development.
• Fluent in SQL (any flavor), having served in various capacities within design, development and deployment of data warehouses or relational/analytical/multi-dimensional data marts.
• Familiar with Virtual Data Warehousing or use of Snowflake DWaaS.
• Relational Database Management Systems and expert SQL skills. Extract/Load/Transform (ELT) development skills.
• Experience with cloud migrations is desirable.
• Experience building data pipelines on Azure following best practices in Cloud deployments.
• Demonstrated ability to debug complex data issues while working on very large data sets with billions of records.
• Proven ability to work with business and technical audiences, on business requirement meetings, technical white boarding exercises, and SQL coding/debugging sessions.
• Ability to take the initiative to pursue assignments, responsibilities, and intake requests to a logical and final solution and to employ System Development Life Cycle (SDLC) standards is required.
• Excellent verbal and written communication skills and strong analytical and problem-solving skills.

Benefits

• InnovAge is dedicated to empowering seniors to live independently, allowing them to age in their own homes and communities safely.
• InnovAge offers an alternative to nursing homes through its Program of All-inclusive Care for the Elderly (PACE), which provides enrolled seniors with customized healthcare and social support at PACE Adult Day Health Centers.
• Centers are staffed by medical professionals who are committed to creating personalized care plans for each participant.
• InnovAge is committed to equal opportunity and affirmative action, striving to create a diverse and inclusive workplace.
• Extensive benefits package includes medical/dental/vision insurance, short and long-term disability, life insurance and AD&D, supplemental life insurance, flexible spending accounts, 401(k) savings, paid time off, and company-paid holidays.