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

Req ID: J282676