Sr. Data Warehouse Engineer

About Beaver Street Fisheries: Beaver Street Fisheries™ is a leading importer, manufacturer and distributor of quality frozen seafood products from the USA and around the world. For nearly 75 years, the Jacksonville-based company has provided premium products to the food-service industry and retail market. The company’s flagship brand, Sea Best®, is sold in retailers nationwide. More information about Beaver Street Fisheries™ can be found at beaverstreetfisheries.com. Job Summary: We are seeking a highly skilled Senior Data Warehouse Engineer to join our team. The ideal candidate will have experience in designing, developing, and maintaining enterprise data warehouse and ETL/ELT workloads in the Microsoft Azure platform, and supporting and transitioning SQL Server Integration Services (SSIS) workloads to the cloud platform. The ideal candidate will have strong expertise with SSIS, Azure Data Factory (ADF), Azure Synapse Analytics and Data Modeling to build scalable and high-performance data solutions. They will collaborate with Data Architects, Data Engineers, and other IT teams. Key Responsibilities: · Design, develop and maintain robust and scalable data warehouse solutions in the Microsoft Azure platform. · Create, optimize and manage ETL/ELT data pipelines using ADF to ingest data from diverse sources, to include on-premises, cloud and API sources in multiple formats. · Maintain and deploy SSIS packages that handle data integration and transformation, including migrating existing on-premises SSIS packages to Azure. · Design and create tables, views, queries, stored procedures for optimized performance, ensuring data integrity and security. · Rewrite Legacy SSIS packages using ADF and Fabric services. · Leverage Azure Synapse Analytics for data storage, processing and serving. This includes building and managing dedicated SQL pools, serverless SQL and Spark pools. · Design and implement data models (e.g. star schema, snowflake schema) that are optimized for performance and reporting. · Ensure data quality, integrity and security by implementing validation rules and quality checks, as well as access controls within the data pipelines and data warehouse. · Monitor, troubleshoot and tune data loads and query performance to ensure the efficiency and reliability of the DW environment. · Work with CI/CD pipelines and version control (e.g., Azure DevOps, Git) for continuous integration and automated deployment of data solutions. · Document data warehouse architecture, ETL processes, and data models to maintain a clear and up-to-date knowledge base. · Monitor Azure resources and implement logging, alerting, and incident response mechanisms. · Stay updated with emerging technologies and trends to continuously improve data architecture, engineering and analytics capabilities. · Collaborate with cross-functional teams (DevOps, Security, Networking, Applications) to ensure smooth cloud transitions. · Adhere to established database standards. · Ensure compliance with corporate and industry security policies. Required Qualifications: ·Bachelor’s or Master’s degreein Computer Science, Information Technology or related field or equivalent experience. ·7+ years of hands-on experiencein data modeling/data warehouse design. ·5+ years of experience with Microsoft Azure, including deployments, administration, and migrations. ·SSIS Expertise:Proven hands-on experience designing, developing, and deploying SSIS packages in a Microsoft SQL Server environment. ·Azure Data Factory (ADF):Extensive experience building and managing complex data pipelines in ADF, including linked services, datasets, activities, and triggers. ·Azure Synapse Analytics:Strong experience with Azure Synapse for data warehousing, including serverless and dedicated SQL pools. ·T-SQL:Advanced proficiency in T-SQL for querying, stored procedures, functions, and performance optimization. ·Data Modeling:Expertise in dimensional modeling, schema design (star, snowflake), and creating fact and dimension tables. ·Cloud Services:Strong understanding of the Azure data ecosystem, including services like Azure Data Lake Storage (ADLS), Azure SQL Database, and Azure Logic Apps. ·Problem-Solving:Excellent analytical and problem-solving skills with the ability to troubleshoot complex data issues. Preferred Qualifications: · Industry certifications related to Microsoft Azure Data and Data Engineering. · Experience with scripting languages like Python. · Experience with other Azure data services, such as Azure Databricks or Power BI. Soft Skills: · Strong analytical and problem-solving skills. · Excellent communication and interpersonal skills. · Ability to manage multiple projects and stakeholders effectively. · Team player with a proactive and collaborative mindset. Job Type: Full-time Pay: $115,000.00 - $130,000.00 per year Benefits: • 401(k) • 401(k) matching • Dental insurance • Employee assistance program • Employee discount • Flexible spending account • Health insurance • Life insurance • Paid time off • Parental leave • Professional development assistance • Tuition reimbursement • Vision insurance Work Location: In person