Business Intelligence (BI) Developer
GCON - Data Team
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