Sr Data Analyst

Job Title: Sr. Data Analyst

Locations: 100% Remote

Type of hire: Fulltime

Job Description:

Works with business stakeholders and IT teams to analyze and resolve data issues for the enterprise data warehouse

When necessary will creates source to target mapping documents to capture additional 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 and that ETL code operates in line with STM requirements

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

Works with reporting teams to assist them in understanding any reported variances between the data warehouse and source system applications

TECHNICAL QUALIFICATIONS

3 years of data analysis experience for a data warehouse

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