Bachelor's degree from four-year College or University; or three to four years related experience within an IT Department, preferably within a Data Warehouse and/or equivalent combination of education and work experience
The ideal candidate will have experience in data analysis and creating data sets from multiple source systems
Exposure to and experience in data warehousing concepts
Strong SQL skills is a must.
Experience working with various data sources (structured, semi structured and unstructured)
Preferred Skills:
Experience with AWS (S3 , Athena) is highly desired
Experience with cloud based data warehouses – Redshift/Snowflake
Experience with Tableau
Responsibilities:
This person will be required to Client, analyze, profile and document findings on source data systems
Create source to target mappings using business rules to transform data
Assist development team during the development phase to resolve data issues and understand data constraints
The candidate will create and maintain data sets for Data Mining and Predictive Analytics
Once development activities are completed the candidate will drive the testing of the final data output
The ideal candidate will be a self-starting individual who is able to dive into details and quickly provide summary level readouts of the source data
The position requires very strong communication skills as the candidate will be required to interact regularly with all levels within the organization, including developers, architects, business users and management