Data Foundation Developer - Senior

FIND YOUR FUTUREWe're excited about the potential people bring to our organization. You can grow your career here while enjoying first-class perks, benefits and commitment to diversity and inclusion.OverviewThe Data Foundation Developer-Senior will create and maintain enterprise level foundational data solutions to support corporate wide reporting efforts. The Senior Developer will work as a lead to develop and enforce best practices for reporting, data modeling, and process development. They will play a lead role with business and technical stakeholders to define and deliver optimal data solutions and lead design, development, and implementation of data that feeds into corporate metrics reports and dashboards. The Developer will work with resources in Informatics and IT to develop best practice processes in support of the Information Development Life Cycle as related to the organizational strategy, in the most effective manner possible. The Developer will be a lead resource to the business in knowledge transfer and customer support assistance for understanding and use of data, systems and reports. They will maintain and support a culture of compliance, security and data integrity and knowledge of policies and procedures.By fostering a culture of data excellence, the Data Foundation Developer-Senior will play a pivotal role in transforming raw data into actionable insights that drive informed decision-making.Qualifications

Bachelor's degree required. An additional four (4) years of experience will be considered in lieu of degree.

Five (5) years of analytical experience using Business Intelligence tools to develop reporting solutions, interactive dashboards, and scorecards required. This shall include extensive experience in one of the Informatics development tools or an equivalent industry standard compatible tool.

Knowledge of Independent Health EDW, Health Rules, Carelon, EyeMed, Liberty Dental and Fee for Service data preferred.

Knowledge of healthcare concepts and healthcare data, for example CPT, HCPCS, DRG, ICD-10/ICD-9 Code, etc.

Experience integrating data into reports with at least one of the less-common data sources, unstructured or cloud-based data, which are inclusive of but not limited to ADT data, SNOWMED data, HL7 resources, LOINC coded base data, immunization data, JSON files, etc.

Extensive experience in the use of databases, data access and programming tools.

Advanced report development skills and ability to “sandbox” new report models.

Experience with OLAP, dimensional modeling, data warehouse development, implementation, and maintenance. Sound understanding and foundation of dimensional modeling.

Advanced knowledge of data mining and manipulation of data with SQL, SAS, and Python.

Experience with cloud-based data platforms (AWS and Azure) preferred. Strong attention to details.

Excellent analytical and problem-solving skills to identify and resolve data quality issues.

Strong communication and interpersonal skills to collaborate effectively with other resources in Informatics, business and technical stakeholders. Ability to communicate clearly in writing to document data requirements and translate into technical solutions that meet business objectives.

Ability to train and mentor end users and transfer knowledge with a customer-centric approach.

Ability to use sound judgment and decision-making, and the appropriate sense of urgency.

Strong dedication to customer service and appropriate follow-through with customers.

Ability to be productive with minimal supervision.

Proven examples of displaying the IH values: Passionate, Caring, Respectful, Trustworthy, Collaborative and Accountable.

Essential Accountabilities

Work directly with business units and end users to understand their business reporting needs and develop and maintain standardized data solutions, Informatics App, Quality Datamart, and other run the business processes. These solutions will support the downstream reports, dashboards and scorecards that utilize Informatics approved applications to deliver solutions.

Work directly with business units and end users to share data, application, and reporting knowledge; be proactive in identifying training needs.

Model potential reporting solutions and discuss with both technical and business community for shared understanding and optimal decision-making.

Collaborate with others in the organization to ensure successful implementation of chosen problem solutions.

Analyze information obtained from management to conceptualize and define operational problems.

Collaborate with senior managers and decision makers to identify and solve a variety of problems and to clarify management objectives.

Define data requirements and gather and validate information, applying judgment and statistical tests.

Study and analyze information about alternative courses of action to determine which plan will offer the best outcomes.

Develop and maintain appropriate documentation on reports throughout the development lifecycle.

Participate in integration, performance, and user acceptance testing for Data Foundation solutions.

Provide technical assistance with troubleshooting reports and/or cubes by responding to inquiries and questions.

Collaborate with Informatics team members to develop and maintain standards for Data Foundation solutions, along with appropriate processes and workflows.

Challenge the current process and create innovative ways to solve business problems with use of non-standard data sources such as EMR and Cloud data sources.

Support the users of the Data Foundation solutions and participate in on-call support role.

Build, maintain, and monitor automated jobs that process, transform, and report data.

Interact proactively with analysts and business users and communicate in appropriate and user-friendly formats and documents.

Contribute to an information reporting “library” or similar forum which promotes sharing of information with analysts and business users throughout the organization.

Immigration or work visa sponsorship will not be provided for this positionHiring Compensation Range: $85,000 - $95,000 annuallyCompensation may vary based on factors including but not limited to skills, education, location and experience.In addition to base compensation, associates may be eligible for a scorecard incentive, full range of benefits and generous paid time off. The base salary range is subject to change and may be modified in the future.As an Equal Opportunity / Affirmative Action Employer, Independent Health and its affiliates will not discriminate in its employment practices due to an applicant’s race, color, creed, religion, sex (including pregnancy, childbirth or related medical conditions), sexual orientation, gender identity or expression, transgender status, age, national origin, marital status, citizenship and immigration status, physical and mental disability, criminal record, genetic information, predisposition or carrier status, status with respect to receiving public assistance, domestic violence victim status, a disabled, special, recently separated, active duty wartime, campaign badge, Armed Forces service medal veteran, or any other characteristics protected under applicable law. Click here (http://www.independenthealth.com/about/careers/additional-eeo-aap-information) for additional EEO/AAP or Reasonable Accommodation information.Current Associates must apply internally via the Job Hub app.The Independent Health Family of Companies, headquartered in Buffalo, NY, serves nearly 400,000 members and provides innovative health care products and benefits designed to engage consumers in their health and well-being. Established in 1980, our comprehensive portfolio includes Pharmacy Benefit Dimensions, Reliance Rx, Nova Healthcare Administrators, Care for You and the Independent Health Foundation.Our culture sets us apart. Our core values drive who we are and the work we do. As a member of our family, you’re part of something special, in your work and in the community.We understand and appreciate that everyone has unique experiences, perspectives and identities which is why we pledge to create a safe space where all people and ideas are welcomed. We are here to continue learning and to generate important dialog.We are committed to doing what matters most - reaching out, working together, and caring for our community. A healthy community benefits everyone who lives in it. You too can be part of making difference in the lives of others, together we achieve so much more. Please click here (http://www.independenthealth.com/about/community-report) to view our Community Reports.Apply today and join us on the journey to a happier, healthier, and more inclusive community.We are a drug-free workplace. We are committed to providing reasonable accommodations for qualified individuals with disabilities and disabled veterans. An applicant for employment in need of an accommodation to participate in the application and recruitment process should contact Human Resources at: accommodations@independenthealth.com or Human Resources, 511 Farber Lakes Drive, Williamsville, NY 14221.Please note, we do not accept unsolicited resumes. We do not accept resumes from headhunters, placement agencies, or other suppliers that have not signed a formal agreement with us.