Sr Data Analyst
Job ID : 35618
Job Title : Sr Data Analyst
Location : Manchester, MI
Comapny Name : VISART
Job Type : Full-Time, Part-Time, Contract, Training
Industry : Information Technology
Salary : $17600 - $18200 per year
Work Authorization : ["OPT","CPT","Entry Level","F1","H4","L1","H1 Visa","TN Permit Holder","Green Card Holder","Canadian Citizen","All EAD","US Citizen"]
No. of Positions : I have ongoing need to fill this role
Posted on : 12-20-2023
Required Skills : Statistics, mathematics, Data management.
Benefits : Medical Insurance, Dental Insurance, Vision Insurance, 401K, Life Insurance
Job Description :
Responsiblties:
- Works with business stakeholders and IT application 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.
Qualification:
- 5 years P&C Insurance subject matter experience.
- 10 years of data analysis experience extracting OLTP data specifically for a data warehouse.
- Advanced SQL knowledge working with extracting data from OLTP applications.
- 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 with experience in generating DDL.
Key Skills:
- Statistics and mathematics.
- Data management and infrastructure.
- Critical thinking.
- Verbal and written communication.
- Problem solving.
- Programming and coding.
Company Details :
Company Information hidden please Login to view details