Job description
Project- in the middle of large project around redefining and re-evaluating their data structure. They are dealing with a lot of consolidations and new products. Team is dedicated to CSIW project- consumer servicing information warehouse= this project is taking current reporting environment and bringing it up to current. (they currently have a lot of variation around their processes and reporting) they are creating a data warehouse and migrating all of the reporting into this data warehouse **Goal- for the data to fit into more of a star schema model.
6+ month contract
Remote - EST hours
Skills:
- 2+ years of experience as a data modeler- convert this into start schema so it aligns with the enterprise in future as well as allow dev team to build out and adapt in the future to solve systems quickly.
- SQL skills- will need to write advanced stored procedures, change dimesons and merge statements, ability to build out relationship keys
- Documentation and Data Mapping
- Financial exp
- Communicate and collaborate well within group settings to understand what the end goal is that they are looking to build out for the model. Understand the Architect knowledge of building out the star schema
- Any knowledge of PowerBI or reporting is helpful
Required Skills
• 2+ years of experience as a data modeler- convert this into start schema so it aligns with the enterprise in future as well as allow dev team to build out and adapt in the future to solve systems quickly.
• SQL skills- will need to write advanced stored procedures, change dimesons and merge statements, ability to build out relationship keys • Documentation and Data Mapping • Financial exp • Communicate and collaborate well within group settings to understand what the end goal is that they are looking to build out for the model. Understand the Architect knowledge of building out the star schema
Basic Qualification :
Additional Skills :
Background Check :Yes
Notes
Selling points for candidate :
Project Verification Info
Exclusive to Apex :No
Face to face interview required :No
Candidate must be local :No
Candidate must be authorized to work without sponsorship ::No
Interview times set : :No
Type of project :Architecture/Design
Master Job Title :Dev: SQL Server Reporting
Branch Code :Charlotte
Interested in this role?
