Vacancy expired!
Data Engineer
Our partner in the Manufacturing space is seeking a Data Engineer is seeking a passionate data practitioner to help the technical design and development of the enterprise data eco-system. This person will be responsible for helping design, development and implementation of robust and scalable enterprise data solutions to support Masonite's current & future initiatives. This individual will work hands on with the team to build solutions that proactively manage and monitor the data ecosystem of analytics, data lakes, warehouses, MDM platforms, and other tools.Responsibilities:- Deploy data architectures based on the standards set by the manager which drive Masonite's data strategy implementation and transform business strategies into information architectures.
- Follow & execute 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.
- Responsible for designing and developing ETL process for extracting data from multiple source systems, transforming the data into a usable fashion, and loading it into data platforms.
- Work with the manager to transform business requirements into appropriate schema and data models.
- Ensure design efficiency to minimize data refresh lags between systems to report timely data.
- Further develop current cloud data warehouse (Snowflake) with both structured and un-structured data.
- Use DBT to transform data within the data warehouse (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
- A bachelor's or master's degree in business administration, computer science, data science, information science or related field, or equivalent work experience.
- Five (5) or more years hands-on experience effectively managing data platforms and working with integration tools (e.g., Snowflake, MS SQL/Azure DB's, SSIS, DBT, Data Factory.)
- 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 experience required
- DBT experience required
- GIT Hub experience required
- Azure Data Factory Experience required
- Experience making data usable to the end users
- Experience working in a complex data environment.
- Agile Delivery Experience, a plus
Vacancy expired!