Business Intelligence (BI) Developer

GCON — Data Team

About GCON

GCON is building the future of construction by combining decades of field expertise with modern analytics. We turn real project and operational data into insights that improve performance, drive smarter decisions, and support our teams where it matters most — on the jobsite and in the office.

About the Role

We're looking for a BI Developer to build the dashboards and reports our business relies on to make decisions and to make sure the numbers behind them are accurate, consistent, and trusted. Beyond day-to-day reporting, you'll help reshape how our data is structured behind the scenes so it stays reliable and scalable as we grow.

You'll start hands-on in Domo; building dashboards, transforming data, and writing SQL. As you grow, you'll help drive our evolution toward a modern data warehouse (Snowflake / dbt) and our early work with AI and automation. This is a role built to grow: we want someone technical who likes to build, not only visualize.

You'll thrive here if you like working as part of a team. You'll partner closely with our Analytics Engineer and collaborate across Finance, Operations, and Project teams — listening to what people need, clarifying definitions together, and delivering insights they can act on with confidence.

What You'll Do

Dashboard & report development

• Build, maintain, and enhance dashboards and reports in Domo
• Support reporting requests from stakeholders across the company
• Apply best practices for dashboard usability, performance, and consistency
• Test and validate dashboards before every release and update

Data modeling & transformation

• Clean, reshape, and model raw data from multiple sources into usable datasets
• Pull and integrate data from databases, files, and platform APIs
• Build and maintain repeatable ETL workflows that keep data flowing reliably from source to report
• Build standardized metrics and calculations in SQL, applied consistently across every report

Data quality & validation

• Run validation and quality checks across dashboards, datasets, and metrics
• Investigate inconsistencies and anomalies, and track down root causes
• Make sure reported numbers align with documented business logic

Documentation & change control

• Document dashboards, metrics, data sources, and reporting processes
• Maintain metric definitions and data logic documentation
• Track changes to dashboards and metrics to support transparency and controlled updates

AI & automation

• Use AI tools to streamline repetitive work — generating documentation, drafting and reviewing SQL, and speeding up validation
• Build simple AI-assisted workflows that keep metric definitions, data dictionaries, and process docs current as things change
• Look for opportunities to automate manual, repeatable tasks so the team can focus on higher-value work

Collaboration & stakeholder support

• Partner with Analytics, Finance, Operations, and Project teams to understand reporting needs
• Communicate clearly about data definitions, limitations, and updates
• Work independently on your own tasks while collaborating effectively across teams

What We're Looking For

This is not a dashboard-only role. If your experience is primarily building visualizations on data someone else prepared, this likely isn't the right fit. We want someone who works with the data itself — cleaning, modeling, and transforming it — not only charting finished data.

Required

• Hands-on ETL / data transformation experience — cleaning, reshaping, and modeling raw data
• Advanced SQL — comfortable writing joins, CTEs, and aggregations from scratch
• Hands-on experience with a major BI / data visualization tool (Power BI, Tableau, Looker, Domo, or similar)
• Comfort pulling data from source systems and APIs, or a clear aptitude and willingness to learn
• Data warehouse or semantic-layer exposure
• Comfort using AI tools to work faster and smarter — to streamline tasks, automate repetitive work, optimize processes, and solve problems
• Data warehouse or semantic-layer exposure
• Ability to explain data clearly to non-technical partners in Finance and Operations
• Strong attention to detail and a focus on data accuracy
• Natural curiosity — you dig into why a number looks off and chase down the root cause
• 2+ years of experience in business intelligence, analytics, reporting, or a related data role
• Bachelor's degree in Analytics, Information Systems, Business, Finance, Computer Science, or a related field — or equivalent practical experience

Preferred / strong plus

• Python for data transformation or automation
• Hands-on experience with dbt and modern data warehousing (Snowflake or similar), or building a semantic layer / data warehouse model
• Experience with data pipeline orchestration tools such as Airflow, Dagster, or Prefect
• Experience with data governance
• Construction or project-based industry experience; BlueprintOS or similar ERP exposure
• Direct Domo experience, including its newer AI / agent features

How We Work

In alignment with GCON's core values, our BI team approaches reporting with integrity, accountability, and a service-oriented mindset — making sure stakeholders have reliable information they can confidently use to guide business decisions. You'll operate effectively in a fast-paced, growing environment, stay comfortable with evolving requirements, and know when to work independently and when to escalate.

Physical Requirements

• Prolonged periods sitting at a desk and working on a computer
• Must be able to lift up to 25 pounds at times

GCON is an equal opportunity employer and considers all applicants for employment based on merit, competence, performance, and business needs. We do not discriminate on the basis of any status protected under federal, state, or local law, including race, color, sex, gender identity or expression, age, religion, creed, national origin, citizenship status, sexual orientation, genetic information, physical or mental disability, military status, or any other protected characteristic. In addition to complying with all applicable laws, GCON has a strong corporate commitment to inclusion.