Data Engineer & BI Developer (Hybrid Role)

Blum Construction

  • Winston-Salem, NC
  • Permanent
  • Full-time
  • 1 month ago
Blum Construction offers unparalleled stability in the construction industry. Founded in 1923, we have weathered tough economic storms for over a century and have emerged as a stronger organization with each challenge. With offices in Winston-Salem, Greensboro, Asheville, Charlotte, and Raleigh, we build structures that transform communities through our work in higher education, senior living, healthcare, non-profits and many other sectors.We understand, very clearly, that it is our people who will enable us to be even stronger in our second century.Position OverviewWe are looking for a highly versatile and self-driven Data Engineer & BI Developer to build the foundational data infrastructure that powers a unified, executive-level dashboard (“single pane of glass”) for real-time business performance visibility.This role would be responsible for:Building pipelines to integrate data from multiple departmentsStructuring a scalable and governed data modelDesigning and launching dashboards that align with strategic goalsKey ResponsibilitiesData EngineeringDesign and implement robust ETL/ELT pipelines from key data sources (ERP, CRM, project management, finance systems, etc.)Own and maintain the data warehouse architectureDevelop and manage data models that support consistent KPIs and reporting logicBI Dashboarding & VisualizationBuild intuitive and interactive dashboards in Power BI, Tableau, or LookerDevelop automated reporting and alert systems for business users and leadershipValidate data integrity and ensure dashboards reflect accurate performance metricsCross-Functional CollaborationPartner with leaders across 6 departments to gather data needs and define KPIsHelp design the initial “single pane of glass” executive dashboardServe as a thought partner to leadership for data strategy and tool selectionRequired Skills & Qualifications
  • 5+ years of relevant experience in data engineering, BI development, or analytics roles
  • Strong SQL skills and hands-on experience with cloud-based data warehouses (e.g., Snowflake, BigQuery, Redshift)
  • Experience building and managing data pipelines (Fivetran, Stitch, Airbyte, or custom Python-based ETL)
  • Proficient in one or more BI tools: Power BI (preferred), Tableau, Looker
  • Solid understanding of data modeling concepts (e.g., star/snowflake schema, dimensional modeling)
  • Strong business acumen and ability to collaborate with non-technical stakeholders
  • Comfortable in a fast-paced, build-from-scratch environment
  • Clear written and verbal communication
Preferred Qualifications
  • Familiarity with dbt or similar transformation frameworks
  • Experience working in a mid-market or growth-stage company environment
  • Exposure to SaaS tools like ACC, Oracle P6, Procore, or others (if applicable to your stack)
  • Background working across multiple departments such as finance, operations, and sales
What Success Looks Like (First 6–12 Months)
  • Design and deploy a centralized data warehouse integrating all key systems
  • Deliver a fully functioning executive dashboard that visualizes KPIs for all departments
  • Establish automated, scalable pipelines and a reliable data refresh cadence
  • Enable cross-functional stakeholders to access clean, real-time data on demand
Benefits:
  • Medical Insurance
  • Dental Insurance
  • Vision Insurance
  • Life Insurance
  • Short Term Disability
  • 401(K) matching
  • PTO
  • Gym Reimbursement
NOTE: Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions

Blum Construction