Business Intelligence Analyst

Job Responsibilities and Requirements

The Business Intelligence Analyst will play a critical role in driving the transformation of RSLI's Data Management and Analytics vision, and a connected data strategy to deliver common, secure and consistent data capabilities across the enterprise.

This role will engage in strategic initiatives and support day-to-day activities.

NEXTGEN ANALYTICS

• Key member of development team for RSLI's nextgen data architecture, which incorporates a mix of cloud and on-prem systems along with big data and rdbms technologies.
• Owns, creates and enhances reports and dashboards within nextgen technologies - Oracle Analytics Cloud (OAC)
• Analyzes, develops and supports reporting datasets within the semantic layer of the database and propagates those to the reporting layer for self-service reporting

CUSTOMER SERVICE

• Analyzes business processes in order to determine and develop technical solutions to meet business objectives.
• Interacts with Business Analysts and staff within business units to determine options for addressing business requirements.
• Executes ad hoc requests in legacy and nextgen tools
• Administers user access within legacy and nextgen tools
• Assists users with user acceptance testing
• Actively involved in CoE to drive adoption of new tools and grow knowledge in IS and Business unites
• Rotates with team as on-call contact for production issues.

ANALYSIS & REPORTING

• Analyzes, designs and develops new reports in existing legacy systems (Actuate) from any necessary data source
• Unit tests development to verify compliance with specifications
• Writes technical specifications and determines time estimates
• Assists team members with design, technical, and training issues
• Ensures reporting is delivered within agreed SLA commitments
• Reports status regularly to management

DATA ENGINEERING

• Develop and support ETL processes within the Enterprise Data Warehouse to support semantic layer tables / data products
• Troubleshoot data from reporting layer through Enterprise Data Platform to understand root cause
• Work with data engineers and data modelers to support semantic layer table design including enhancements needed to support new data points and efficiency challenges

Required Knowledge, Skills, Abilities and / or Related Experience

• Bachelor's Degree in Computer Science or related field
• 3+ years of related experience
• Desire / curiosity to learn, grow and make an organization data driven
• Experience developing reports, dashboards and overall data stories for internal and external customers
• Experience developing and deploying data warehouse / data mart / ETL / BI deliverables to in support of reporting
• Experience should include :
• Oracle Analytics Cloud (OAC)
• Oracle
• PL / SQL
• ETL Development in Data Warehouse
• Data Modeling - Relational & Star Schema
• Indexes, Views
• Solid understanding of Business Intelligence and Data Warehousing processes and tools
• Experience supporting semantic layer and metadata layer data products used for BI self-service
• Must have disciplined organizational skills and the ability to multi-task, organize, prioritize and meet deadlines as needed
• Strong interpersonal skills and communication skills in order to develop relationships for attainment of mutual goals
• Experience with Actuate reporting tool preferred
• Insurance background (e.g., claims, underwriting, sales, billing, or finance) preferred
• Experience with the Kimball Design Methodology including star schemas, bridge tables, staging tables, work tables preferred

Ability to Travel : Up to 10%

Work location may be flexible if approved by the Company.

What We Offer

At Reliance Matrix, we believe that creating a more diverse, equitable and inclusive culture allows us to realize more of our potential.

And we can't do this without our most important asset-you.

That is why we offer a competitive pay package and a range of benefits to help team members thrive in their financial, physical, and mental wellbeing.

Our Benefits :

• An annual performance bonus for all team members
• Generous 401(k) company match that is immediately vested
• A choice of three medical plans (that include prescription drug coverage) to suit your unique needs. For High Deductible Health Plan enrollees, a company contribution to your Health Savings Account
• Multiple options for dental and vision coverage
• Company provided Life & Disability Insurance to ensure financial protection when you need it most
• Family friendly benefits including Paid Parental Leave & Adoption Assistance
• Hybrid work arrangements for eligible roles
• Tuition Reimbursement and Continuing Professional Education
• Paid Time Off, volunteer days, community partnerships, and Employee Assistance Program
• Ability to connect with colleagues around the country through our Employee Resource Group program and our Diversity Equity & Inclusion Council
Our Values :
• Integrity
• Integrity
• Empowerment
• Compassion
• Collaboration

EEO Statement

Reliance Matrix is an equal opportunity employer. We adhere to a policy of making employment decisions without regard to race, color, religion, sex, national origin, citizenship, age or disability, or any other classification or characteristic protected by federal or state law or regulation.

We assure you that your opportunity for employment depends solely on your qualifications.

LI-Hybrid #LI-LN1