Sr. Data Warehouse Engineer

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. 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, Micro Strategy, 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
• Excellent written and oral communication skills
• Ability to identify problems and develop cost effective solutions

Mid-Senior level

Full-time

Engineering, Information Technology, and Supply Chain

Transportation, Logistics, Supply Chain and Storage and IT Services and IT Consulting