Leeds Professional Resources
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
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