Senior Data Warehouse Developer

The Senior Data Warehouse Developer is responsible for developing and maintaining applications using a variety of technologies that support multiple lines of Business and IT initiatives. This individual may work independently or collaborate with a smaller group of developers in similar efforts. This position is responsible for technical analysis, design, development, testing, and deployment of IT solutions as needed by business or IT. The senior developer works closely with other subject matter experts and works on delivering technology including ETL / ELT, batch processing using Informatica to support a multitude of data warehouse and its downstream.

They are responsible for developing and maintaining applications using a variety of technologies like Informatica, shell scripting, SQL and ETL to support multiple lines of Business and IT initiatives.

This position is responsible for technical analysis, design, development, testing, and deployment of IT solutions / Data warehouse solutions to support Medica business, and will play a critical role in developing and migrating the Medica data warehouse on-premise and into Snowflake environment.

They are required to accurately track work time based on project and/or daily work activities according to Finance department guidelines

This position combines the role of data analyst, developer, consultant, troubleshooter, extract, transform and load (ETL).

Qualifications:

• Bachelor's degree or equivalent experience in related field
• 5+ years of years of experience in data warehouse environment and building ETL solutions using Informatica & Oracle etc, as well as knowledge on Snowflake & Cloud environment

Specific types of experience:

• Proficiency in SQL and Oracle PL/SQL is required - 5+ years
• Experience in healthcare environment - 2+ years
• ETL (SAS) experience - 5+ years
• Business Intelligence / Data Warehousing methodology is required - 5+ years
• Knowledge of Snowflake implementation is preferred
• Strong data analysis skills
• The candidate has to be very analytical and strong data analysis skills are required.

This position is a Hub role, which requires an employee to occasionally come onsite to the designated office - Minnetonka - for applicable heads-up work. Frequency is determined by business need as decided by leadership.

The full salary range for this position is $85,000 - $145,700. Annual salary range placement will depend on a variety of factors including, but not limited to, education, work experience, applicable certifications and/or licensure, the position's scope and responsibility, internal pay equity and external market salary data. In addition to compensation, Medica offers a generous total rewards package that includes competitive medical, dental, vision, PTO, Holidays, paid volunteer time off, 401K contributions, caregiver services and many other benefits to support our employees.

The compensation and benefits information is provided as of the date of this posting. Medica's compensation and benefits are subject to change at any time, with or without notice, subject to applicable law.

Medica's commitment to diversity, equity and inclusion (DEI) includes unifying our workforce through learning and development, recruitment and retention. We consistently communicate the importance of DEI, celebrate achievements, and seek out community partnerships and diverse suppliers that are representative of everyone in our community. We are developing sustainable programs and investing time, talent and resources to ensure that we are living our values. We are an Equal Opportunity/Affirmative Action employer, where all qualified candidates receive consideration for employment indiscriminate of race, religion, ethnicity, national origin, citizenship, gender, gender identity, sexual orientation, age, veteran status, disability, genetic information, or any other protected characteristic.