Data Analyst (Data Warehouse) | Day 1 HMO

2 to 4 Years
Open to Work From Home
With Business Certificates
Established in 2010
201-500 Employees
Total vacancies for this job title: 1
Posted On: September 29, 2022
Job ID: 413116

Video Profile


Are you a Data Analyst with extensive knowledge of Data Warehousing, ETL and BI Architectures, concepts and frameworks?

If so, check out this job!  

Our client is a US-based tech company with 15 years’ experience in Microsoft, Salesforce, BI, AI, and Cloud Computing. We have earned longstanding client relationships as trusted, long-term partners. Every day we inspire, innovate, and implement solutions that solve complex business problems using creativity and technologies that drive results. 


Critical Technical Skills (in order of level of need)

  • 5+ years of data warehouse experience 

  • 5 years P&C Insurance subject matter experience (Policy and Claims) 

  • Advanced SQL knowledge 

  • Extensive knowledge of Data Warehousing, ETL and BI Architectures, concepts and frameworks 

  • Capable of creating and tuning Semantic layer Reporting Views  

  • Capable of facilitating data discovery sessions involving business subject matter experts 

  • Knowledge of RDBMS platforms (e.g., SQL Server, DB2) with experience in generating DDL

What you’ll be doing 

  • Works with business stakeholders and IT teams to define data needs for the enterprise data warehouse 

  • Creates source to target mapping documents to capture application data elements for loading from source systems into the enterprise data warehouse 

  • Collaborates with ETL team to ensure that source to target mappings are correctly translated into ETL code 

  • Performs data validation to confirm data is moved into the data warehouse correctly 

  • Works with reporting teams to assist them in understanding the data warehouse model and optimal ways to use it

Soft Skills

  • Knowledge of Guidewire Policy Center, Guidewire Claims Center, SAP FS-RI & SAP FS-CD applications and their data is a huge plus 

  • Strong interpersonal skills and ability to work as part of a team

Education Requirements

  • BS in Computer Science, Information Management or Statistics

A genuine career opportunity with great benefits awaits!

  • Above average industry standard compensation package

  • HMO coverage including 1 dependent upon hire

  • 20 Leave credits per year consumed at your discretion with up to 5 days commutable to cash

  • Exposure to world-class, high-level management from foreign direct superiors

  • Employee engagement activities