Sr. Data Warehouse Engineer

Leeds Professional Resources; Miami (FL); On-site; USD 115,000 - 155,000; Full time

Job summary

Leeds Professional Resources is seeking a Senior Talent Acquisition Professional focused on data management and warehouse development in Miami. You will oversee production databases, ETL processes, and data modeling while coordinating with IS teams to ensure data quality and performance.

The role requires a four-year degree and extensive AWS/Data Warehouse experience, including Redshift, S3, Python, and BI tooling like Tableau or Power BI. Strong collaboration and communication are essential.

Qualifications

• A four-year degree is required, preferably in MIS, Business or Computer Science.
• 3+ years’ AWS experience across key platforms.
• Experience designing, architecting and deploying data repositories on AWS (Redshift, S3, MongoDB).
• Solid database/data warehouse experience: ETL/ELT, BI tools (Tableau, MicroStrategy, Power BI).
• Strong database development and management experience in a complex DW environment (5+ years).
• 5+ years of SQL experience with complex queries.
• 3+ years of experience in cloud platforms, preferably AWS, in production.
• Self-motivated; able to work independently and in teams.

Responsibilities

• Own architecture, development, and maintenance of production databases with IS teams.
• Design, develop, and support database objects for reporting and integrations.
• Design, develop, and support ETL processes.
• Perform relational and multidimensional modeling and schema creation.
• Analyze data and ensure transformation handles anomalies.
• Implement data quality processes across databases.
• Focus on performance tuning, optimization and DW scalability.
• Collaborate with architects, BI designers, data stewards, and DB teams through the DW lifecycle.
• Build and maintain DW environments with best-practice schemas (Star/Dimensional vs Snowflake).

Skills

AWS

SQL

Data Modeling

ETL/ELT

Data Warehousing

Python

Analytical skills

Communication

Education

Bachelor's degree in MIS, Business or Computer Science

Tools

Tableau

MicroStrategy

Power BI

Redshift

S3

MongoDB

Job description

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