Business Intelligence Developer

About This Role

Developing, maintaining, and supporting the company's business intelligence and analytics environment is the core of this hands-on role. The Senior BI Developer will translate business requirements into accurate, scalable, and well-governed reporting and data solutions, working with Sigma, Power BI, Snowflake, SQL, and dbt. The role combines BI development, data modeling, production support, validation, documentation, and close collaboration with business stakeholders.

Responsibilities

• Design, develop, test, deploy, and maintain dashboards, reports, datasets, and semantic models using Sigma and Power BI
• Translate business requirements into intuitive and scalable BI solutions supported by consistent measures, dimensions, and business definitions
• Develop and maintain SQL-based transformations and analytical models in Snowflake
• Contribute to dbt models, testing, documentation, and development standards
• Monitor critical reports, datasets, refreshes, gateways, and related processes
• Troubleshoot reporting failures, performance concerns, access problems, and data-quality issues across reporting and data layers
• Assess Alteryx workflows and migrate appropriate business logic into maintainable SQL and dbt models
• Validate and reconcile new or migrated solutions against source systems, existing results, and approved business rules
• Use Git, GitHub, and AI-assisted development tools such as Codex or Claude Code to support version control, code review, testing, documentation, troubleshooting, and controlled deployment
• Apply appropriate judgment when using AI tools and protect confidential, proprietary, and sensitive information in accordance with company policies
• Maintain documentation covering data models, business rules, dependencies, ownership, lineage, and support procedures
• Partner with Finance, Sales and Marketing, Supply Chain, Operations, and other functions on requirements, testing, training, deployment, and adoption
• Identify opportunities to consolidate redundant reporting, reduce technical debt, and improve performance, reliability, and maintainability

Requirements

• Strong SQL skills and the ability to work with complex relational datasets
• Hands-on experience developing and supporting dashboards, reports, semantic models, or governed analytical datasets using Sigma, Power BI, or another modern BI platform
• Experience working with Snowflake or a comparable cloud data platform
• Knowledge of dbt or another SQL-based data transformation framework
• Practical understanding of dimensional modeling, fact and dimension tables, data warehousing, and ETL or ELT concepts
• Experience validating and reconciling data across source systems, transformations, and reports