US LBM Data Engineer

US LBM is one of the leading distributors of specialty building materials in the United States, seeking a Data Engineer to enhance data-driven decision-making across the organization. The role involves developing data pipelines, collaborating with stakeholders, and ensuring data quality and governance.

Responsibilities:

• Partner with business stakeholders to gather requirements and translate them into technical specifications and process documentation for IT counterparts (on-prem and offshore)
• Work with business and technical teams to solve problems and assist management by practically applying data-based decisions
• Design, build and manage data pipelines for data structures encompassing data transformation, data models, schemas, metadata, and workload management
• Develop a deep understanding of operations, data, data sources, and data integration with a view to creating deep and meaningful insights that drive business value
• Work with the Data Product team to identify and import data from a variety of ERP sources into our cloud-based environment to support future analytics needs
• Develop and ensure adherence to published system architectural decisions and development standards
• Multi-task across several ongoing projects and daily duties of varying priorities as required
• Interact with technical teams to communicate business requirements and collaboratively build data solutions
• Understand the basics of data science and data science platforms to work with data science teams in refining and optimizing data science and machine learning models and algorithms
• Implement, manage, troubleshoot and resolve any Oracle Cloud GL issues
• Work with data governance and data security teams when moving data pipelines into production with appropriate data quality, governance and security standards and certification
• Assist in the development and implementation of process improvements in the areas of data analysis, reporting and communication
• Adheres to Company’s commitment to workplace safety
• Perform other duties as assigned
• Comply with all policies and standards
• Adheres to Company’s commitment to workplace safety

Requirements:

• Bachelor's Degree in a quantitative field with 7 years of experience or Master's Degree with 5 years of experience
• 7+ years of experience working in ETL positions in operational environments or business consulting organizations
• ETL/ELT, data replication/CDC, message-oriented data movement, API design and access
• Hands on experience in Matillion as the ETL tool
• Experience with Snowflake cloud data platform including Snowflake utilities like Snow SQL, Snow Pipe
• Strong expertise in data modeling and building Logical Data Model (LDM), and Physical Data Model (PDM), Star/Snowflake Schema to assist in fast reporting and BI dashboards
• Must have exposure with development, configuration, and deployment on Azure Cloud technologies
• Experience with programming languages, including Python, R and Java, SQL, PL/SQL for relational databases
• Exposure to reporting tools using Tableau or MicroStrategy
• Experience in automation the test cases for regression testing, integrating testing as part of the automation / DevOps pipeline
• Understanding of financial processes and accounting principles
• Excellent communication skills with a track record of successfully advocating to turn insights into action
• Working knowledge of maintaining and reconciling general ledger accounts ensuring accuracy and completeness to financial data is preferred based on project needs
• Any experience in Oracle data integrator is a plus, but not a must
• Snowflake certification is a huge plus