Lead Data Warehouse Developer

The Technical Lead developer is responsible for leading development on Strategic Data initiatives across the enterprise. This position is responsible for the technical execution like design, development, testing, and deployment of IT solutions. In addition to that focus on the end to end delivery of portfolio / program and projects by leading the People, Process and Technology.

Responsibilities:

• Provide high level technical direction for the development, design, integration.
• Balance short-term versus long-term actions, strategic versus tactical requirements.
• Manage creation of technical artifacts including data and ETL design. Involve in architecture, design (data and ETL) review and provide feedback for continuous improvement.
• Understand the environment, development practice and standards adopted within the team and suggest changes wherever possible.
• Ensure delivery of artifacts for the tasks analysis, development, peer reviews and testing.
• Follow policies set for governance, compliance, security & infrastructure and change management.
• Partner with Business and formulate, own and practice and advocate data governance policies and standards to ensure accuracy, validity, reusability and consistent definitions of Medica data.
• Develop standards, process flows and tools that promote and facilitate the mapping of data sources, documenting interfaces and data movement across the enterprise.

Required:

• BS in Computer Science or related field or equivalent experience
• 7+ years of experience in Data Management / Data Integration / ETL development with considerable experience with Informatica ETL.

Preferred Qualifications:

• Experience managing and delivering complex data development initiatives and managing small development team.
• Strong implementation experience and deep knowledge in any one of the following three areas and knowledge of the other 2 areas at a minimum. Implementation experience in all the 3 areas preferred: ETL, Data Integration, Data Governance and Data Quality
• Deep knowledge of the strategic business drivers and operational process requirements within at least one industry such as Health Insurance, Financial services, High Tech, Pharmaceuticals, Insurance, or similar industry. Must be able to link industry specific business requirements to EDM capability requirements.
• Experience with conceptualization, design and assistance in the implementation of new and existing systems, middleware, MDM, metadata, data quality, data warehouse and production architectures
• Proficiency in SQL and Oracle PL/SQL is required. 5+ years preferred.
• Experience in healthcare environment 2-5 years preferred.
• Informatica (5-8 years) or other ETL (DataStage, Ab Initio, open source) experience (8-10) years is required.
• Business Intelligence / Data Warehousing methodology is required (5-8 years).
• Knowledge in SAS programming is a plus.
• In depth experience and knowledge in ETL / ELT, performance tuning and designing optimized integration systems.
• Extensive experience in creating integration process for Enterprise Data Warehouse.
• Advanced knowledge of SQL, database performance, RDBMS, and Query tools.
• Extensive experience with Health Care Data domain knowledge and process preferred.
• In depth experience in running data initiatives using agile methodology preferred.
• Certification in Agile methodology and ITIL foundations is a plus.

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

The full salary range for this position is $96,000 -$164,500. 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 base compensation, this position may be eligible for incentive plan compensation in addition to base salary. 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.