Senior Data Warehouse Architect

EVI Industries, Inc.; Miami (FL); On-site; USD 90,000 - 120,000; Full time

Job summary

A leading industry firm located in Miami is seeking a skilled Data Engineer to design, build, and maintain high-performance data warehouses. The candidate will utilize extensive experience in database administration and SQL to optimize data integration from multiple platforms including Microsoft Dynamics and Salesforce. The role also involves developing ETL pipelines and ensuring data governance. Ideal applicants should hold a relevant degree and possess strong problem-solving skills, aimed at fostering a data-driven approach.

Qualifications

• 7+ years of experience in database administration and data warehouse development.
• Strong SQL expertise with experience in query optimization, indexing, partitioning, and replication.
• Proficient with ETL tools such as Azure Data Factory, SSIS, or equivalent.
• Familiarity with cloud-based data platforms like Azure Synapse, AWS Redshift, or Snowflake.
• Understanding of data modeling principles like star/snowflake schema.
• Excellent problem-solving skills, attention to detail, and communication abilities.

Responsibilities

• Design and develop robust and scalable data warehouse architectures to support business goals and analytics.
• Administer and tune database systems to ensure high availability and performance.
• Integrate disparate data sources into a centralized warehouse using ETL best practices.
• Develop ETL pipelines using Azure Data Factory, SSIS, or similar.
• Establish and enforce data governance, quality, and security protocols.
• Support business users with optimized queries, views, and datasets for reporting.
• Monitor and troubleshoot database performance issues.

Skills

Database administration

SQL expertise

Data warehouse development

ETL tools proficiency

Query optimization

Data governance

Problem-solving skills

Attention to detail

Communication abilities

Education

Bachelor’s degree in computer science, Information Systems, or a related field

Tools

Azure Data Factory

SSIS

SQL Server

Azure SQL

Job description

A leading industry firm located in Miami is seeking a skilled Data Engineer to design, build, and maintain high-performance data warehouses. The candidate will utilize extensive experience in database administration and SQL to optimize data integration from multiple platforms including Microsoft Dynamics and Salesforce. The role also involves developing ETL pipelines and ensuring data governance. Ideal applicants should hold a relevant degree and possess strong problem-solving skills, aimed at fostering a data-driven approach.