RESOURCES
- DESPD Resource
The candidate(s) will work with internal stakeholders, as well as CAS team members, to create and execute large data mart and warehouse construction projects. The candidate(s) will manage project details, data collection, reporting and communication to successfully drive project efforts. Responsible for oversight of the core flow of the order through various boundary partner teams in completing a successful end-to-end deployment of services.
Responsibilities:
- Support ingesting data from multiple areas
- Manage the design and build out of a data mart
- Gather, document and analyze user requirements for new OLAP, data marts and/or reporting systems or system enhancements
- Design, organize, and implement module, perform system testing, plan and automate tasks to maintain existing data platform
- Maintain the existing data warehouses and Design subject area wise data marts / cubes to facilitate aggregation, slicing and dicing of data by reporting tools such as Micro Strategy/Power BI/Tableau
- Develop process for capturing and maintaining data from metadata and create meaningful Multidimensional Databases/datamarts
- Provide recommendations for data mart/data warehouse structure (Star/Cube/OLAP etc), design the solution and remain to coordinate build
Required Qualifications:
- Minimum of 5 years of experience in Data Modeling/Data Structure Design
- Experience in all major RDBMS like Oracle, SQL Server, Teradata Develop logical and physical models for the functional data mart, staging area, and operational data store
- Must have experience architecting, designing, and building out Data Mats/Warehouses
- Must be familiar with cubes, stars, and various architecture structures
- Must have the ability to understand business needs and design
Sub Heading:
Philadelphia, PA – Travel Allowed
Sub-heading 2:
- Data Mart/Warehouse Architecture Experience: 3-5 yrs
- Telephony Experience: 3 yrs
- Project Management Experience: 5-7 yrs
- Telecommunications Experience: 5-7 yrs
- SQL Server Experience: 3-5 yrs