Senior Talent Acquisition Professional - Enriching Lives by Connecting Talent
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, 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
- Excellent written and oral communication skills
- Ability to identify problems and develop cost effective solutions
Seniority level
Mid-Senior level
Employment type
Full-time
Job function
Engineering, Information Technology, and Supply Chain
Industries
Transportation, Logistics, Supply Chain and Storage and IT Services and IT Consulting
#J-18808-Ljbffr