Data Reporting Analyst (Mid-Level)

Company United Concordia Dental Job Summary MUST BE A US CITIZEN This job turns data into information, information into insight, and insight into business decisions. More specifically, this job drives and supports all activities related to collecting, analyzing, and reporting on the Organization's key performance indicators including developing dashboards, scorecards, forecasting, trending, tracking results, and executive presentations for the purpose of supporting operational excellence, management intelligence for effective decision-making, and overall tracking of organizational performance. Consults with cross-functional enterprise groups and levels to identify data and analytical needs, conduct analyses, review analyses and findings with leadership, facilitate related process/data improvement efforts and develop executive level presentations. Prepares similar intelligence for customers and interacts with customers as such. Specifically, this role is responsible for transforming complex operational, financial, and membership data into actionable insights that inform executive decision-making across Government Programs (TDP, ADDP, Medicaid, and emerging programs). The Analyst will go beyond producing reports – this role identifies performance drivers, qualifies risk and opportunities, and delivers clear, data-backed recommendations that improve program outcomes, financial performance, and strategic positioning. Essential Responsibilities Work with various internal departments to collect source data, on a regular basis and as needed. Design and build analyses/trending/forecasting reports using Excel or other technology. Publish metrics dashboards and executive presentations. Identify, analyze, and interpret trends or patterns in complex data sets. Analyzes membership, utilization, financial, and operational data to identify trends, root causes, and performance drivers. Translates findings into clear, actionable recommendations for leadership. Builds and maintaining forecasting models for membership, utilization, and financial performance. Develop processes, tools, and templates to enable efficient, accurate, and standardized data analyses and related deliverables. Leverages automation to greatest extent possible. Develop and implement data collection systems and other strategies that optimize statistical efficiency and data quality. Extracts clean, and integrated data from multiple sources (e.g. claims, enrollment, financial systems, and operational platforms). Ensure consistency and accuracy of information and reporting by identifying issues and fluctuations with core metrics/KPIs, facilitates changes, research questions, participate and/or lead process and data improvement efforts. Partners with IT and data engineering teams to improve data quality and accessibility. Contribute to ensuring that all changes to reporting, processes, and procedures are reflected, appropriately documented, and that consistency is maintained for team. Ensure the correct first time /quality review processes are utilized and that changes maintain data integrity control processes. Collaborate with cross-functional teams (operations, finance, network, compliance) to understand business needs and translate them into analytical solutions. Maintain effective communication with internal organizations, external vendors/partners and internal staff. Structure and present complex subjects in a meaningful and comprehensible manner. Develop work plans to meet deadlines, accurately estimate completion dates and communicate status. Work closely with management to prioritize business and information needs. Other duties as assigned or requested. Education Minimum: Bachelor’s Degree in Math, Computer Science, Quantitative Business Analysis, or closely related field Preferred: Master’s Degree in Information Technology, Mathematics/Statistics, or Operations Research. Experience Minimum: 3 - 5 years of relevant, progressive experience Preferred: Experience in project management; Experience in healthcare, insurance, or government programs (Medicaid, DoD, etc); Exposure to forecasting, or statistical modeling; Experienced working with large, complex datasets in a matrix organization. Licenses/Certifications Required: None Preferred: Lean Six Sigma Skills Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy Problem solving capabilities, critical thinker, able to investigate root causes and recommend solutions Proficient to master level with Microsoft Office products including Excel, Power Point, Word, and Access Basic understanding of SQL / querying capabilities Experience with BI tools such as Power BI or Tableau Experience with end-user reporting tools Familiarity with the Software Development Lifecycle Process Strong written and verbal communication skills Effective participation in team-based work Energetic: The ability to find solutions and deliver results within a rapid, fast changing, entrepreneurial, technology-driven culture; Passion for technology and a positive, can-do attitude is a must. Adaptability: Capable of adjusting to changing priorities, and possesses the ability to understand business needs to master new skills and technologies in a short period of time. Results-Oriented and Data Driven: Must be a data driven decision maker who loves impacting the bottom line and achieves goals with available resources and abilities. Communication (written & oral): Must have strong interpersonal skills and the ability to establish, develop and maintain cross-functional business relationships, as well as have excellent presentation and problem-solving skills Language (Other than English) None Travel Requirement 0% - 25% Physical and Mental Demands and Working Conditions Position Type: Office-Based Teaches/trains others regularly: Rarely Travel regularly from the office to various work sites or from site-to-site: Never Works primarily out-of-the office selling products/services (sales employees): Never Physical work site required: Yes Lifting: up to 10 pounds: Occasionally Lifting: 10 to 25 pounds: Rarely Lifting: 25 to 50 pounds: Never Disclaimer The job description has been designed to indicate the general nature and essential duties and responsibilities of work performed by employees within this job title. It may not contain a comprehensive inventory of all duties, responsibilities, and qualifications required of employees to do this job. Compliance Requirement This position adheres to the ethical and legal standards and behavioral expectations as set forth in the code of business conduct and company policies. As a component of job responsibilities, employees may have access to covered information, cardholder data, or other confidential customer information that must be protected at all times. In connection with this, all employees must comply with both the Health Insurance Portability Accountability Act of 1996 (HIPAA) as described in the Notice of Privacy Practices and Privacy Policies and Procedures as well as all data security guidelines established within the Company’s Handbook of Privacy Policies and Practices and Information Security Policy. Furthermore, it is every employee’s responsibility to comply with the company’s Code of Business Conduct. This includes but is not limited to adherence to applicable federal and state laws, rules, and regulations as well as company policies and training requirements. Pay Range Minimum: $62,700.00 Maximum: $97,200.00 Base pay is determined by a variety of factors including a candidate’s qualifications, experience, and expected contributions, as well as internal peer equity, market, and business considerations. The displayed salary range does not reflect any geographic differential Highmark may apply for certain locations based upon comparative markets. Equal Employment Opportunity Highmark Health and its affiliates prohibit discrimination against qualified individuals based on their status as protected veterans or individuals with disabilities and prohibit discrimination against all individuals based on any category protected by applicable federal, state, or local law. Accessibility and Accommodation We endeavor to make this site accessible to any and all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact the email below. For accommodation requests, please contact HR Services Online at View email address on click.appcast.io #J-18808-Ljbffr