**FIND YOUR FUTURE** We're excited about the potential people bring to our organization. You can grow your career here while enjoying first-class perks, benefits and a culture that fosters growth, innovation and collaboration. **Overview** The Data & Reporting Analyst will be responsible for ensuring the on-going reporting needs of both internal and external clients are met. This will include but is not limited to design, build, test and validation of new or existing reports through data research and analysis. The Analyst will develop and maintain both ad-hoc and scheduled reports to support internal business functions and to satisfy client needs. The Analyst will use current client and potential client data to calculate performance and analyze trends. They will help to create internal reporting dashboards and reports using Power BI for use by the account management team and other internal stakeholders. **Qualifications** + High school diploma or GED required. Associates degree preferred. + Four (4) years of data or analysis experience, to include managing and coordinating processes required. Healthcare or pharmacy experience preferred. + Experience with Microsoft Power BI Power Query, DAX, M-Language, and SQL preferred. + Certifications in Power BI or other Power platforms preferred. Successful completion of certification titled “Analyzing and Visualizing Data with Microsoft Power BI” will be required within six (6) months of hire. + IBM iSeries or AS/400 Query experience preferred. + Experience with industry standard files such as, but not limited to, 834s, 835s, and NCPDP preferred. + Strong problem solving, analytical, and verbal/written communication skills. + Must possess a strong attention to detail and organizational skills. Ability to manage multiple priorities and meet deadlines. + Strong Microsoft Office skills, advanced Excel and Access required. + Ability to work with, manipulate and synthesize large datasets for analysis, performance measuring, key insights and presentation. + Effectively handle shifting assignment and priorities to meet deadlines. + Proven examples of displaying the PBD values: Trusted Advisor, Innovative, Excellence, Guardianship, Dedication and Caring. **Essential Accountabilities** Reporting + Determine reporting solutions for business objectives. + Understand reporting objectives and gather data requirements. + Utilize analytic methods and data manipulation skills, in conjunction with business understanding, to perform necessary reports for end users. + Performance monitoring of groups on a regular basis and as requested by the client. + Perform analysis and modeling of benefit changes to a plan. + Participate in the development and creation of client reports. + Support the members of the management team through unique and ad-hoc reporting, as necessary. + Develop and maintain data models, as well as analyze and report business, regulatory, contractual, and ad hoc requirements. File Generation + Create standard file extracts to support internal and external business needs. To include but not limited to rebates, vendor files, custom and standard client extracts. (internal and external clients) Quality Assurance + Perform testing, data validation, and user signoff to ensure reports are pulling the correct data and achieving customer requirements. + Understand reporting objectives and gather data requirements. Project Support + Perform complex tasks including research, data extraction and manipulation. + Work individually and as a team member on a variety of assignments, including cross functional team projects. + Assist with RFPs and implementations for current and potential clients to minimize disruption or develop cost saving alternatives. _I_ _mmigration or work visa sponsorship will not be provided for this position_ Hiring Compensation Range: $30 - $36 hourly _Compensation 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._