BI & Data Warehouse Developer

Fiore & Sons, Inc. is an employee-owned civil construction company with over 70 years of experience serving Colorado and the surrounding states. As an industry leader known for innovation, environmental stewardship, and a people-first culture, we believe in sharing success with our team. We offer stability, career growth, and exceptional benefits—including 100% employer-paid health and dental premiums. At Fiore, every team member is valued, respected, and empowered to make an impact. Build your future with Fiore!

The BI & Data Warehouse Developer plays a key role in developing and maintaining the company’s enterprise data architecture and business intelligence environment. This role is responsible for designing data pipelines, building reports and dashboards, and supporting data governance practices. With full ownership over BI and warehouse development projects, this position enables data-driven decision-making across departments by ensuring data is reliable, accessible, and actionable.

TOTAL COMPENSATION

$89,300.00 to $130,700.00 annually

ESSENTIAL DUTIES AND RESPONSIBILITIES

Data Pipeline & Warehouse Development

Design, develop, and maintain ETL/ELT processes to integrate data from multiple internal and cloud-based systems.

Build and maintain data warehouse tables, views, and staging areas to support analytics and reporting.

Ensure performance tuning and optimization of queries, datasets, and storage architecture.

Data Governance & Stewardship

Establish and enforce data governance policies, standards, and procedures.

Collaborate with business and IT stakeholders to define data definitions, ownership, and usage standards.

Implement data quality controls and monitoring solutions to identify and resolve data issues.

Collaboration & Support

Partner with data analyst to ensure data solutions meet business requirements.

Provide technical expertise and support for data-related projects, including integrations, migrations, and platform upgrades.

Support user training and documentation for data access and interpretation.

Compliance & Security

Ensure compliance with data privacy regulations (e.g., GDPR, HIPAA, CCPA) and internal security protocols.

Manage data classification, access controls, and audit trails in the data warehouse environment.

Business Intelligence Development & Analytics

Build BI dashboards, visualizations, and data models using tools like Power BI or Tableau.

Translate business requirements into functional data structures and self-service reporting solutions.

Implement reusable datasets, KPIs, and calculated fields in BI platforms for operational teams.

Responsible for continuous development and improvement of reported data.

Other reporting and analysis as required.

QUALIFICATIONS

Analytical Thinking & Problem Solving

Demonstrates strong logical reasoning and the ability to synthesize complex datasets to identify trends, inconsistencies, or potential areas for improvement.

Applies root cause analysis techniques to investigate data anomalies or system failures.

Leverages data to develop actionable recommendations and scalable solutions that support business goals and strategic decision-making.

Data Architecture & Design

Demonstrates working knowledge of dimensional modeling, star/snowflake schemas, and best practices in data warehouse design.

Builds intuitive and high-performing data structures for reporting and visualization.

Understands best practices in designing for scalability, data lineage, and long-term maintenance.

Quality Assurance & Attention to Detail

Maintains a high standard of accuracy and precision in data handling, reporting, and documentation.

Develops automated testing and data validation routines to ensure completeness, consistency, and accuracy across data pipelines.

Monitors for data drift, duplication, and corruption, and proactively mitigates risks through governance policies.

Cross-functional Collaboration

Collaborate with business users to understand reporting and analytics needs and develop automated solutions that reduce manual effort.

Communicates effectively with both technical and non-technical stakeholders to gather requirements, explain findings, and align priorities.

Builds trust with data stewards, business units, and leadership by ensuring data reliability and transparency.

Acts as a liaison between IT teams, analysts, and business functions to ensure shared ownership and accountability for data assets.

BI Tools & Development (New subheading or integrate into existing sections)

Proficient in business intelligence tools such as Power BI, Tableau, or similar platforms.

Ability to develop dashboards, reports, DAX/MDX queries, and publish content for stakeholders.

Adaptability & Continuous Learning

Stays up to date on evolving data technologies, governance regulations, and industry best practices.

Adapts to new tools, environments, and organizational changes with agility and a growth mindset.

Seeks feedback and opportunities to continuously improve processes, skills, and system performance.

Preferred:

Bachelor’s degree in Computer Science, Information Systems, Data Science, or a related field.

3+ years of experience with data warehousing, ETL/SQL processes, and data governance practices.

Experience building interactive dashboards and data models in a cloud-based BI environment.

Familiarity with version control systems and collaborative development practices (e.g., Git, DevOps for BI).

PHYSICAL DEMANDS

Ability to sit, stand, or walk for extended periods of time, including uneven terrain on work sites when needed. Ability to bend, kneel, crouch, reach, twist, list, carry, push, and/or pull 25 lbs. occasionally for filing and storage access, etc. Ability to maneuver paperwork and use a computer screen for extended durations.

WORK ENVIRONMENT

A potential mix of office-based and mobile-office-trailer-based work, with far more time generally spent in the office, with varying temperatures and extended screen time.

Confidentiality Disclaimer

Confidential information about customers, pricing, equipment, and/or employees may become available to the Job Cost Controller & Systems Analyst. This information is to remain confidential, and is not to given to, or discussed, with other employees, customers, or anyone else, without explicit permission from management.

We Offer an Outstanding Benefit Package:

Health

100% Employee and 80% Dependent Premium paid

Platinum Plus grade plan w/$0 Deductible and Low Out of Pocket Max

Dental – 100% Employee and Family Level Premium paid

Employer paid Short Term Disability

Employer paid Long Term Disability

Voluntary Vision Plan paired with Hearing Care – optional

Accident, Critical Illness, Hospital Indemnity, and Limited Medical Gap Plans – optional

Identity Protection and Pet Insurance – optional

Accident, Critical Illness, Hospital Indemnity, and Limited Medical Gap Plans – optional

Identity Protection and Pet Insurance – optional

FSA Account – optional

HSA Account - with HDHP

Paid Holidays, Vacation, & Wellness Time Off

401(k) Retirement Savings Plan with employer match contributions.

$25,000.00 Employer paid Basic Life and AD&D Insurance – with additional voluntary options

To Apply

Apply online at

Equal Opportunity Employer

Fiore & Sons is an Equal Opportunity and Affirmative Action Employer and prohibits discrimination of any kind. All employment decisions at Fiore & Sons are based on business needs, job requirements, and individual qualifications, without regard to race or ethnicity, color, religion or belief, sex, age, disability, sexual orientation, gender identity or expression, national origin, status as a protected veteran, or any other status protected by the law. Applicants that require reasonable accommodation to complete the application process should contact Human Resources at .