Data Analyst
Data Analyst is needed to perform the following duties:
· - Collect and clean data from various sources, such as databases, spreadsheets, and external APIs.
· - Perform exploratory data analysis, create data visualizations, and identify trends and patterns within the data.
· - Prepare model development and research datasets for RDW (main data warehouse) retainment.
· - Update single family core models' estimation and development data creation process to accommodate for RDW to EDI transition using SQL.
· - Support the research team to update the research code. Running SAS programs and working with SAS datasets
· - Work as part of a team, manipulate data in excel to make it ready for transition to a new system
· - Construct SQL queries and ad hoc reports as needed.
· - Migrate the Relational Data Warehouse (RDW) data to EDI for the Enterprise Modeling & Analytics (EMA) group.
· - Manage and Analyze data solutions and data engineering, with Oracle and Netezza databases
· - Develop data models for applications, metadata tables, views or related database structure
· - Create physical data models from logical model and database schema based on the target database.
· - Participating with Design, development and Business teams on Data analysis and Creating reports.
· - Develop and implement databases, data collection systems, and data analytics using GSE data warehouse and EDI
· - Prepare data extraction scripts to extract data to the on-premise servers. Create and input the data to tables using SQL.
Bachelor Degree is required in Computer Science or Computer Engineering or Management Information Systems or Computer Information System or education + experience which is equivalent to a Bachelor’s Degree in Computer Science or Computer Engineering or Management Information Systems or Computer Information System