Join our Talent Network
Skip to main content

Senior Programmer - OLAP & BI Developer

Job ID: 1007842
Date Posted: Aug 16, 2022
Department ID: TS0845 IT - Data Warehouse
Company: TMNA Services LLC

Save Job Saved

Job Description

Marketing Statement

Tokio Marine North America Services (TMNAS) provides professional support services to Tokio Marine Group companies in the United States, including Tokio Marine America, First Insurance Company of Hawaii, and Philadelphia Insurance Companies. Customer service is our focus and our passion! TMNAS adds value in all that we do, providing the best professional service to our business partners, allowing them to achieve their goals. Our talented team delivers actuarial, audit, corporate communications, financial and investment, human capital services, information technology, legal, and payroll expertise to our customers.

Duties

Job Summary

As a member of our information management team, the OLAP Developer is responsible for the design, development, and support of new and existing OLAP Cubes. This position utilizes industry standards and best practices to facilitate dissemination of data to our business partners and the use, analysis, and consumption of information from various data repositories.

Essential Duties:   The OLAP Developer will work with multiple groups within IT and the business to interpret requirements and develop creative solutions to assist in the use of information assets. Through project participation, assisting in evaluating the proper methods for publication of information, and providing insight into the evolution of OLAP technology within the industry, the OLAP developer plays a pivotal role in information delivery to the organization.

Job Responsibilities

  • Work with business partners and technical teams; plan, design, and implement effective and scalable Business Intelligence (BI) solutions utilizing MS SSAS
  • Champion the use of Business Intelligence (BI) solutions within the organization. Provide education for staff on use, best practices, and self-service
  • Provide support for user facing analytical tools such as Excel, SSAS, Cognos, and Power BI
  • Assist in the development and maintenance of conceptual, logical, physical data models as well as supplemental documentation for the enterprise data warehouse and OLAP environments
  • Develop, implement, and tune complex queries constructed with SQL/MDX / DMX
  • Cube maintenance including partitioning and performance optimization
  • Provide input on and adhere to standards, guidelines and best practices for business groups and technical teams as it pertains to OLAP toolsets and usage
  • Work with other IT Teams to incorporate new data elements from source databases into the data warehouse as needed
  • Work with the data warehouse systems to insure data integrity, quality, and accuracy and suggest opportunities for improvement
  • Understand in theory and apply in practice all phases of SDLC from system analysis and design thru development and test to deployment and support
  • Explore and evaluate emerging OLAP and Data technologies for applicability in our environment
  • Comply with proper internal controls as necessary to conduct job functions and/or carry out responsibilities and/or administrative activities at the Company
  • Establish and build strong working relations and partnerships with Business Units and Senior Management

Qualifications

Degree / Licenses and Professional Certifications

  • Bachelor’s Degree (preferably in Mathematics, Statistics, Computer Science, MIS, or Software Engineering) preferred
  • Master’s Degree (preferably in Business Administration, Predictive Analytics, or Data Science) a plus
  • CBIP certification or equivalent a plus

Experience

  • 7+ Years of experience overall working in data management, including 2+ years focused on OLAP cube design and MDX query development

Competencies

  • Proficient in SQL / MDX / DMX
  • MSSAS or other OLAP toolset development experience. Understanding of structuring dimension hierarchies and attribute relationships, cube perspectives and partitioning
  • Tabular SSAS experience is desired
  • Experience with Cognos and / or PowerBI is desired
  • Experience with data management, governance, and control within a financial services setting preferably within the P&C insurance industry
  • Advanced abilities in relational and dimensional data architecture, modeling, extraction, transformation, and loading, data management, data governance, and related disciplines
  • Advanced SQL language skills
  • Adept in tracing and resolving data integrity issues

Knowledge

  • Knowledge of approaches, tools, techniques for recognizing, anticipating, and resolving organizational, operational, or process problems, ability to apply this knowledge appropriately to diverse situations
  • Knowledge of tools and methodologies used for data discovery, data preparation, prediction, and data analysis
  • Knowledge of activities, tasks, practices, and deliverables associated with eliciting and clearly defining and documenting required business functionality as well as nonfunctional requirements
  • Knowledge of standard concepts, practices, and procedures in Business Intelligence and Data Warehousing
  • Knowledge of each part of the data life cycle from discovery, loading, cleaning, transforming, managing, analyzing, and making such data easily accessible to all members of the company
  • Knowledge of database designing, developing and implementing databases of multiple types including relational, network, hierarchical, and/or others

EEO Statement

Tokio Marine Group of Companies (including, but not limited to the Philadelphia Insurance Companies, Tokio Marine America, Inc., TMNA Services, LLC, TM Claims Service, Inc. and First Insurance Company of Hawaii, Ltd.) is an Equal Opportunity Employer.  In order to remain competitive we must attract, develop, motivate, and retain the most qualified employees regardless of age, color, race, religion, gender, disability, national or ethnic origin, family circumstances, life experiences, marital status, military status,  sexual orientation and/or any other status protected by law. 

Share: mail

Similar Jobs

Sr. System Analyst

Bala Cynwyd, PA, United States
TMNA Services LLC

HR Generalist I

Bala Cynwyd, PA, United States
TMNA Services LLC

Manager & Corporate Actuary

Bala Cynwyd, PA, United States
TMNA Services LLC

Actuarial Intern

Bala Cynwyd, PA, United States
TMNA Services LLC

Actuarial Analyst I

Bala Cynwyd, PA, United States
TMNA Services LLC

TBM Vendor Analyst

Bala Cynwyd, PA, United States
TMNA Services LLC

Security Architect

Bala Cynwyd, PA, United States
TMNA Services LLC

Senior Programmer - OLAP & BI Developer

Bala Cynwyd, PA, United States
TMNA Services LLC

Programmer III - Digital Development

Bala Cynwyd, PA, United States
TMNA Services LLC

IT AVP- Applications Modernization

Bala Cynwyd, PA, United States
TMNA Services LLC

Duck Creek Tech Lead/ Manager

Bala Cynwyd, PA, United States
TMNA Services LLC

Senior Programmer - Azure Developer

Bala Cynwyd, PA, United States
TMNA Services LLC

Software Engineer

Bala Cynwyd, PA, United States
TMNA Services LLC

Senior Azure Integration Architect

Bala Cynwyd, PA, United States
TMNA Services LLC

Interested in working for FICOH?
Take the first step by joining our Talent Network today!

Join our Talent Network