Under limited supervision, responsible for designing and constructing relational databases for data warehousing. Leads or mentors lower-level team members.
Knowledge, Skills and Abilities:
- Possesses and applies broad knowledge Data Warehousing principles, practices, and procedures to the completion of difficult assignments and complex situations.
- Expert knowledge and application in dimensional modeling, cube design and development using SQL Server Analysis Services (SSAS), SSIS and MS Analytics.
- Ability to analyze, compare and evaluate various courses of action and apply sound decisions making skills.
- Ability to work on projects or work groups, creating a collaborative and respectful team environment and improving workflows while meeting deadlines.
- Ability and willingness to help supervise and develop less experienced staff.
Job Duties:
- Develops data modeling to ensure data integrity and decision support databases.
- Responsible for data acquisition, access analysis and design.
- Responsible for data archive, recovery, load strategy design and implementation.
- Coordinates new data development ensuring consistency and integration with existing warehouse structure.
- Collaborates with administrative management on informational needs.
- Reviews business requests for data and data usage, researches data sources for new and enhanced data feeds.
- Assists in continuous improvement efforts in enhancing performance and increased functionality.
- Performs all other duties as assigned.
Education:
Bachelor's degree in Computer Science or related field is required.
Experience:
Five (5) years related experience is required.
Additional Licenses and Certifications:
None.