Design logical and physical models across multiple Data Warehouses, organize working sessions with business operations team, and have experience with database technologies, data design, and performance optimization.
Requirements
- Design logical and physical models across multiple Data Warehouses
- Strong experience in SSIS
- Organize working sessions with business operations team to understand sources of data and expected output
- 1-2 years of experience in database technologies, data design and performance optimization for large OLAP & Data Warehouse solutions
- Expert in relational and dimensional structures for large (multi-terabyte) operational, analytical, warehouse and BI systems
- Skilled in data profiling, business domain modeling, logical data modeling, physical relational data modeling and design
- Strong skills in Entity Relationship Modeling (ERWin modeling software preferred)
- Excellent written and verbal communication skills with strong relationship building skills
- Ability to work in a large, complex business and technical environment
- Experience with Insurance domain preferable
- Experience with Erwin or similar data modeling tool
- Strong Oracle/SQL expertise
Benefits
- Health insurance
- Dental insurance
- Vision insurance
- Life insurance
- Retirement plan
- Paid time off
- Sick leave