Sr. Data Engineer

We heard you knock! The Masonite Data & Analytics Team is seeking a passionate Senior Data Engineer to lead the technical design and development of the enterprise data eco-system. This person will be responsible for scoping new architecture, leading and guiding data engineers in development and implementation of robust and scalable enterprise data solutions to support Masonite’s current & future initiatives. This individual will not only work hands on with the data engineering team, but will also be responsible for the designing and implementation of solutions that proactively manage and monitor the data ecosystem of analytics, data lakes, warehouses, MDM platforms, and other tools. Review requirements and design data architectures based on the standards set by the manager which drive Masonite’s data strategy implementation and transform business strategies into information architectures. Design, implement, and train the data engineering team members on strong and measurable processes, tools and engineered data management solutions to support all data platforms – such as data warehouse, lakes, visualization tools, master data management, and advanced analytics tools. Developing, deploying, scheduling, and maintaining the data pipeline workflows to move data from multiple source systems to the cloud data warehouse. Review business requirements and provide appropriate levels of effort to leadership that provide guidance on capacity planning and concise tasks to the team on how to implement appropriate schema and data models. Creating the data ingestion framework for Snowflake for both full and incremental data loading from different source systems. Further develop current cloud data warehouse (Snowflake) with both structured and un-structured data. Developing dbt models and macros using SQL and Jinja languages with best practices to extract, load, and transform the data for medium to large enterprises using Snowflake. Tune ETL for maximum performance. Data Profiling, Data Cleansing, and Data Auditing. Loading large volumes of data. Decoding and writing complex SQL queries. Performance tuning of queries and data loading process. Modeling normalized and de-normalized data structures. Ensure best practices are established and built into SOPS. Qualifications A bachelor’s or master’s degree in business administration, computer science, data science, information science or related field, or equivalent work experience. Programming (SQL) – 8 or more years Data Management Concepts (Data Extraction, Cleansing, Transformation, loading, Validation, Migration, Modelling, RDBMS concepts) – 8 or more years Snowflake – 4 or more years ETL (dbt, SSIS) – 4 or more years Azure Architecture & Services (Blob Storage, Data Factory, Data Lake, DevOps) – 4 or more years Git Hub – 4 or more years Data Visualization Tools (Power BI, Tableau) - 4 or more years Manufacturing industry experience, a plus Experience pulling and merging data from multi-ERPs/source systems, required SSIS Experience, required Extensive design and development experience in Data warehouse and data marts Snowflake SnowPro Core Certified required DBT experience required GIT Hub experience required Azure Data Factory Experience required Microsoft Azure Data Fundamentals Certified Experience making data usable to the end users Experience working in a complex data environment. Agile Delivery Experience, a plus #LI-JO2 We Help People Walk Through Walls We respect the privacy of candidates for employment. Our Masonite Applicant Privacy Policy sets forth in more detail our privacy practices, including, without limitation, our collection and usage practices, of your personal information when you apply for a position with a Masonite entity. At Masonite, our Purpose is to Help People Walk Through Walls – literal walls, digital walls, cultural walls, and any wall that limits what a door can do. For 5,000 years doors have done their thing, but we’re on a mission to make life and living better by designing and producing Doors That Do More™. Our workforce spans the globe and is made up of 10,000 artisans, designers, makers and experts all guided by the Cultural Pillars that are at the foundation of how we do business and activate our Purpose. These Cultural Pillars reflect the environment we create where people are empowered, collaborative and focused on doing the right thing for our customers, teammates, shareholders, suppliers and communities in which we work. A place where our teams can realize their full potential within a safe, rewarding environment. At Masonite, we are committed to building an equitable workforce. Our shared values reflect the diverse communities we live in and serve. Through environmental, social and governance initiatives and inclusive programs like employee affinity groups and leadership transparency, we embrace an intentional approach to respect and belonging. Learn more about Diversity, Equity & Inclusion and the Masonite advantage.