• Job Description

  Req#: DATAW002160

  Morton Salt is an iconic company with a strong heritage and a bright future. Since 1848, we have been improving lives and enhancing everyday moments – at home, at work and virtually everywhere in between. We help unlock the flavors in food, make roads and sidewalks safer, improve the water in baths, pools, and homes, and keep businesses and industries running. We are a dedicated team who constantly strives to do better together, and we are passionate about building a sustainable future for our company, the communities in which we operate, and the world around us. By joining our team, you will contribute to producing and delivering every form of salt that enhances everyday life.

  Job Summary

  We are seeking a detail-oriented Data Warehouse Engineer with expertise in ETL processes, SQL, Azure Data Factory, and Power Queries to join our growing Data & Analytics team. In this role, you will be responsible for designing, developing, and maintaining data pipelines, ensuring high-quality data integration and transformation to support business reporting and analytics. You will collaborate with cross-functional teams to understand data requirements, troubleshoot data issues, and continuously optimize our data infrastructure.

  Duties and Responsibilities

  • ETL Development & Maintenance:
  • Design, build, and maintain ETL pipelines using SSIS and Azure Data Factory to extract, transform, and load data from various sources into our data warehouse and analytics platforms.
  • Create and maintain SQL queries to extract and transform data form various data sources.
  • Data Integration & Quality:
  • Work closely with data engineers, business analysts, and stakeholders to gather requirements and implement robust data solutions.
  • Monitor data quality and ensure data integrity throughout the ETL processes.
  • Identify and resolve data discrepancies, performance issues, and bottlenecks.
  • Reporting & Analysis:
  • Support business intelligence initiatives by preparing data extracts and performing ad hoc data analysis.
  • Collaborate with BI developers to design dashboards and reports that meet business needs.
  • Process Improvement:
  • Continuously review and improve ETL processes for scalability, efficiency, and reliability.
  • Stay current with industry trends and best practices in data integration, cloud data services, and analytics.
  • Documentation & Collaboration:
  • Document ETL processes, data mappings, and technical specifications.
  • Communicate effectively with team members and stakeholders to ensure alignment on project goals and timelines.

  Knowledge, Skills and Abilities

  • 5+ years of experience in data warehousing with on-premise or cloud technologies.
  • Experience with Azure Data Factory and Microsoft Azure data services (e.g., Azure SQL Database, Azure Blob Storage).
  • ETL experience utilizing SQL Server Integration Server (SSIS).
  • Experience with database management and SQL query optimization.
  • Experience building data models from scratch.
  • Experience with Power Queries, Power BI Dataflows, and Semantic Models.
  • Bachelor’s degree in Computer Science, Information Systems, Data Analytics, or a related field preferred.
  • Experience with MS Fabric components preferred.
  • Experience with C#, VB, and scripting languages (e.g., JavaScript, Python) for data manipulation preferred.
  • Experience implementing Medallion Architecture for data processing preferred.

  At Morton Salt, we work best when we work as a team, when we treat one another with dignity and respect, and value the unique contributions of others. We are committed to equal employment opportunity and prohibit discrimination and harassment based on race, national origin, sex, religion, color, disability, marital status, protected veteran status, sexual orientation, gender identity, gender expression, genetic information, citizenship, or any other characteristic protected by law.

  Equal Opportunity Employer
  This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.

• About the company

  Morton Salt is an American food company producing salt for food, water conditioning, industrial, agricultural, and road/highway use.

Notice