Business Intelligence Analyst

Company : HM Insurance Group Job Description : ***CANDIDATE MUST BE US Citizen (due to contractual/access requirements)*** The Business Intelligence Analyst plays a critical role in bridging the gap between business needs and technical solutions. This position requires a strong analytical skillset to understand, document, and improve business processes, coupled with the ability to leverage data and light programming skills to support data-driven decision-making and system enhancements. The ideal candidate will be proficient in gathering requirements, creating process flows, and using Salesforce, Python, and SQL to analyze data, build reports, and automate tasks. Business Analysis & Requirements Gathering: Elicit, analyze, document, and validate business requirements through interviews, workshops, and existing documentation. Create detailed process flows, use cases, and user stories to clearly define system and process changes. Collaborate with stakeholders to prioritize requirements and ensure alignment with business goals. Identify opportunities for process improvement and automation. Data Analysis & Reporting: Extract, transform, and load (ETL) data from various sources, including Salesforce. Perform data analysis to identify trends, patterns, and insights that support business decisions. Develop and maintain reports and dashboards using data visualization tools. Ensure data quality and accuracy. System Configuration & Development: Customize and configure Salesforce to meet specific business needs (e.g., workflows, validation rules, custom objects). Develop simple scripts in Python to automate data processing, system integration, or reporting tasks. Write and execute SQL queries to extract, manipulate, and analyze data from databases. Participate in testing and deployment of system changes. Collaboration & Communication: Serve as a liaison between business users and technical teams. Communicate effectively with stakeholders at all levels of the organization. Present findings and recommendations in a clear and concise manner. Collaborate with developers and other IT professionals to implement solutions. Documentation & Training: Create and maintain technical documentation, including system configurations, data dictionaries, and process flows Develop and deliver training materials to end-users on new systems and processes Sales Operational Support: Provide operational support to the Sales Team, encompassing a range of administrative and process-oriented duties. ESSENTIAL RESPONSIBILITIES: Lead process improvement or regular (annual) business processes. Work with business and technical organizations to assemble project teams. Lead project team members in the development and maintenance of comprehensive plans for a defined program. Work with Executive Sponsor and Business Owner of a Program, and other management as required, to deliver business intelligence solutions. Projects managed at this level are typically moderately complex and may be cross-functional. On a regular basis and as needed, work with various departments to understand business objectives; design and build analytics using Oracle Cloud; publish metrics dashboards and executive presentations. Identify, analyze, and interpret trends or patterns in complex data sets. Ensure consistency and accuracy of information and reporting by monitoring performance and usage of Oracle Cloud. Research fluctuations to core metrics/key performance indicators (KPIs), participate and/or lead process and data improvement efforts. Develop processes, tools, and templates to enable efficient, accurate and standardized data analyses and related deliverables; leverage automation to greatest extent possible. Design and implement analytical solutions and other strategies that optimize statistical efficiency and data quality. Develop work plans to meet deadlines, accurately estimate completion dates, and communicate status to leadership. Ensure 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. Work closely with management to prioritize business and information needs. Other duties as assigned or requested. Education Required Bachelor's Degree in Math, Computer Science, Analytics, Engineering, Information Science or related field Preferred None Experience Minimum 3 years Directly related work experience Preferred 1 year Project Management LICENSES or CERTIFICATIONS Required None Preferred None SKILLS Proficient to master level with Microsoft Office products including Excel, Power Point, Word, and Access Basic understanding of SQL / querying capabilities Experience with Oracle Cloud Business Intelligence, OTBI, BI Publisher, OACs, FRS, Smartview Familiarity with the Software Development Lifecycle Process and Project Management Lifecycle Strong written and verbal communication skills Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy Effective participation in team-based work Ability to find solutions and deliver results within a rapid, fast changing, entrepreneurial, technology-driven culture Ability to understand business needs, maintain strong cross-functional relationships and provide optimal customer service through Analytics Language (Other than English) None Travel Requirement 0% - 25% PHYSICAL, MENTAL DEMANDS and WORKING CONDITIONS Position Type Office-Based Teaches/trains other regularly Occasionally Travel regularly from the office to various work sites or from site-to-site Rarely Works primarily out-of-the-office selling products/services (sales employees) Never Physical work site required Yes Lifting: up to 10 pounds Frequently Lifting: 10 to 25 pounds Occasionally 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: $68,400.00 Pay Range Maximum: $105,900.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. 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. 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 California Consumer Privacy Act Employees, Contractors, and Applicants Notice Highmark Health is a national, blended health organization that includes one of America’s largest Blue Cross Blue Shield insurers and a growing regional hospital and physician network. Based in Pittsburgh, Pa., Highmark Health’s 35,000 employees serve millions of customers nationwide through the nonprofit organization’s affiliated businesses, which include Highmark Inc., Allegheny Health Network, HM Insurance Group, United Concordia Dental, HM Health Solutions and HM Home & Community Services. Highmark Health’s businesses proudly serve a broad spectrum of health-related needs including health insurance, health care delivery, population health management, dental solutions, reinsurance solutions, and innovative, technology solutions.