Business Intelligence Engineer

Apply Job Type Full-time Description Status: This is a full-time; salaried position Hours: Monday – Friday: 8am – 5pm Benefits Offered to Full-time Employees: Health, Dental, Optical, Medical FSA/HSA, Dependent Care (FSA), Basic Life Plan, Short Term Disability, Long Term Disability, 401K with Company Match, Profit Sharing (ROA), PTO (Vacation), Holidays, Jury Duty, and Funeral Leave JOB SUMMARY: The Business Intelligence Engineer is responsible for making Coldspring’s data usable by the business. Coldspring is building a medallion data architecture — a bronze layer of raw source data, a silver layer in our SQL data warehouse, and a gold layer of curated, business-facing data. This position is embedded in our cross-functional BI team, where a project manager handles intake and prioritization, and is responsible for the technical design and delivery of the gold layer, the certified data sources the company relies on, and the KPIs, dashboards, and reporting used to make business decisions. This position also owns our dbt environment and the transformation logic that moves data from bronze, to silver, to gold. Key skills for this position include SQL, dbt, dimensional data modeling, Tableau, and the ability to communicate effectively with non-technical business users. Coldspring has spent the past two years building the foundation for this role — a working data warehouse sourced from JD Edwards, with a dedicated developer maintaining the integration. The gold layer is greenfield. This is the first position dedicated to making that data usable across the company, so you would be establishing the patterns, the standards, and the certification practice rather than inheriting someone else’s. You would be working with people who know the business well and want better access to their data. WHAT YOU’LL BE DOING: Set up, configure, and maintain the dbt environment used to transform Coldspring data Build and maintain the dbt models that move data from the bronze layer, to silver, to gold, including data quality tests and monitoring Work with business users, alongside the BI team, to translate business questions into data requirements and deliver answers at the level each requester needs Design and build the gold layer: curated, business-facing data models, including conformed and pre-joined data sets spanning sales, production, shipping, and other domains Establish standards for naming, testing, documentation, and version control of transformation code Publish, certify, and manage the company’s certified data sources, including their names, descriptions, owners, refresh schedules, and the data dictionary and metric definitions behind them Own the certification standard: what qualifies as certified, how changes are handled, and when a source is retired Centralize business calculations and metric definitions in the data layer, not in individual reports Build KPIs, dashboards, and recurring reporting for teams that…