Data Management/Data Warehouse Development

• Overall architecture, development, and maintenance of production databases by working closely with the entire IS Technical teams.
• Design, develop and support database objects required for reporting and integrations.
• Design, develop and support extraction and integration processes (ETL).
• Perform relational and multidimensional modeling and schema creation.
• Perform data analysis and propose and ensure transformation covers all data possibilities including managing data anomalies.
• Implement processes to ensure data quality in the database systems.
• Focus on performance tuning, optimization and scalability to ensure efficiency in the data warehouse.
• Troubleshoot and assist in resolving errors and performance issues including production support.
• Work closely and coordinate activities with Technical Architects, Business Intelligence Architects, BI/Report Designers, Data Stewards, Database Developers, Database Administrators, QA and support staff throughout the full data warehouse life cycle.
• Build and maintain strong peer relationships within the team and across the organization.
• Design, develop and maintain our data warehouse environments by working closely with the Senior Manager, Big Data Architect. - Balance the overall design and architecture of the data warehouse to ensure fast access to data, while providing optimal load processes. - Maintain data warehousing environments to perform well, utilizing schema (Star/Dimensional vs. Snowflake) best practices when applicable.

EDUCATION & EXPERIENCE:

A four-year degree is required, preferably in Management Information Systems, Business or Computer Science. The following experience is required:

• 3+ Years’ Experience working in AWS across many of the key platforms.
• AWS Solutions Architect would be preferred. • 3+ years of experience designing, architecting and deploying data repositories on AWS’ platforms – Redshift, S3 --- including MongoDB
• Solid Database / Data Warehouse experience - Extraction, transformation and loading systems (Python Scripts) - Business Intelligence (BI) tools and platforms (Tableau, MicroStrategy, Power BI etc.) - Monitoring, Backup and Performance Management tools
• Strong database development experience in a dynamic and complex data warehouse environment, 5+ years
• Strong database management experience (Microsoft and/or AWS) , 5+ years • Strong SQL experience, working with complex queries and ETL/ELT processes, 5+ years. • 3+ years of experience in Cloud platforms, preferably on AWS in a production environment

OTHER QUALIFICATIONS:

• Self-motivated
• Ability to work independently and as a member of a team
• Strong analytical skills • Team player with strong interpersonal skills
• Strong project management skills
• Excellent written and oral communication skills
• Ability to identify problems and develop cost effective solutions