Business Intelligence Analyst

Company :

HM Insurance Group

*** 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.

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.

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.

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.

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.

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.

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…