Reliance Matrix · 6 days ago

Business Intelligence Analyst

Philadelphia, PA

Full-time

Hybrid

Mid Level

3+ years exp

Wonder how qualified you are to the job?

Maximize your interview chances

Employee BenefitsFinancial Services

Insider Connection @Reliance Matrix

Discover valuable connections within the company who might provide insights and potential referrals, giving your job application an inside edge.

Responsibilities

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.

Analyzes business processes 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 units.

Rotates with team as on-call contact for production issues.

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.

Develops and supports ETL processes within the Enterprise Data Warehouse to support semantic layer tables/data products.

Troubleshoots data from reporting layer through Enterprise Data Platform to understand root cause.

Works with data engineers and data modelers to support semantic layer table design including enhancements needed to support new data points and efficiency challenges.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

Data WarehousingETLBusiness IntelligenceData StoriesData WarehouseBI ToolsDeadline ManagementActuate ReportingProblem-SolvingHard WorkingInterpersonal SkillsInsurance backgroundKimball Design Methodology