Data Analyst

Job Title: Data Analyst
Job Function: Consultant
Job Type: Contract (40 hours per week)
Location: The chosen candidate will be required to work in one of the following client offices at the time of onboarding for a minimum of three days per week (other days can be remote):
Boston, MA; Charlotte, NC; Colorado Springs, CO; Conshohocken, PA; Dallas, TX; Fargo, ND; Florham Park, NJ; Garden City, NY ; Houston, TX; Jacksonville, IL; Lenexa, KS; Los Angeles, CA; Lubbock, TX; Mt Juliet, TN; New York, NY; Purchase, NY; Topeka, KS.
If the candidate is not already local, they must complete their relocation within a few weeks after onboarding. RCM's client will not consider remote candidates for this role.
BOUT RCM:
RCM Technologies is a leading provider of IT Business Solutions and Engineering Services to over 1,000 clients in the commercial and government sectors. RCM partners with clients to define, implement and manage a broad range of technologies across multiple platforms, systems, and networks. Our broad geographic presence ensures that a proven and reliable tactical and strategic capability is available and deployable virtually everywhere in North America.
BOUT RCM's CLIENT:
RCM's client is a global specialty provider of property and casualty insurance and reinsurance, was established in March 2017 as the result of the acquisition of two smaller firms and has an extensive global footprint with nearly 80,000 employees in 228 cities in 30 countries. Its core business encompasses one of the largest property and casualty (P&C) insurance groups in the Asia-Pacific (APAC) domestic market. RCM's client is looking to expand its current IT capacity with several key hires to take advantage of rapid growth and current market opportunities.
SPECIFIC ROLE:
The Data Analyst is a 'hands-on' position with a focus on defining the data needs for the enterprise data warehouse. The position will work within IT to help our client create an industry-leading data warehouse architecture. Furthermore, this data warehouse architecture will measure performance in all aspects of the organization's operations.
ROLE RESPONSIBILITIES:
The chosen candidate will be responsible for the following:

• Work with business stakeholders and IT teams to analyze and resolve data issues for the enterprise data warehouse.
• Create source (OLTP applications) to target (DWH) mapping documents to capture additional application data elements.
• Load the source-to-target mapping documents from source systems into the enterprise data warehouse.
• Collaborate with the ETL team to ensure the source-to-target mapping documents are in correct ETL code.
• Ensure the ETL code align with STM requirements.
• Perform data validation, to insure correct data movement into the enterprise data warehouse architecture.
• Consult with reporting teams to develop a general understanding for the data warehouse model / optimal ways to use it for maximum value.

TECHNICAL QUALIFICATIONS:

• Proven 5+ years' experience of data analysis extraction of OLTP data within an enterprise data warehouse.
• Possess 5+ years of Policy & Claims Insurance subject-matter expertise.
• Candidate has advanced level SQL knowledge.
• Possess optimal knowledge for concepts and frameworks for Data Warehousing, ETL, and BI Architectures.
• Candidate is capable of creating and tuning Semantic layer Reporting Views.
• Able to facilitate data discovery sessions, which will include an audience of business subject-matter experts.
• Proven knowledge of RDBMS platforms (e.g., SQL Server, DB2), with experience in generating DDL.
• Possess knowledge of Guidewire Policy Center, Guidewire Claims Center, SAP FS-RI & SAP FS-CD applications with their data is considered a 'plus'.

GENERAL QUALIFICATIONS:

• Candidate has strong interpersonal skills, including both written and verbal communication skills.
• Possess the ability to work as part of a team.
• Candidate has strong organizational skills and analysis skills.

EDUCATION REQUIREMENTS:
B.S. Degree in Computer Information Science, Information Management, or Statistics is required.
EQUAL OPPORTUNITY STATEMENT:
RCM is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.
DISCLAIMER:
This job description is intended to describe the general nature and the level of the work being performed by the people assigned to this position. It is not intended to include every job duty and responsibility specific to the position. RCM reserves the right to amend and change responsibilities to meet business and organizational needs as necessary.