Senior BI Developer

Position Summary

The Senior BI Developer (Business Integration Specialist) is a senior individual contributor role that combines hands-on data engineering and analytics with technical leadership across the Business Intelligence function. This role partners directly with business and leadership stakeholders to gather requirements, design scalable data solutions, and deliver reliable reporting and analytics.

The position is responsible for owning and advancing the reporting environment, with a primary focus on ETL/ELT processes, medallion architecture, and data integrity within a Snowflake-based data platform. In addition to individual contributions, the role sets technical standards, mentors team members, leads coordinated changes across shared data models, and acts as a trusted advisor to ensure high analytical and engineering quality while enabling the BI function to scale.

Responsibilities

• Design scalable, well-structured data models and medallion/dimensional architectures that support current and future business needs.
• Build, maintain, and optimize complex ETL/ELT pipelines using Snowflake, Snowpipe, dbt, and Python.
• Integrate data from APIs, webhooks, SFTP, web scraping, and file-based sources.
• Establish and enforce development and validation standards across SQL, Snowflake, dbt, and Tableau.
• Align stakeholders on consistent business logic by identifying and addressing unclear or conflicting requirements prior to development.
• Lead coordinated releases for shared data models, including impact analysis, validation, communication, and rollback planning.
• Investigate and resolve complex, multi-system data issues by identifying root causes and driving fixes at the source.
• Mentor BI developers through code reviews, coaching, and knowledge sharing to improve data modeling, reconciliation, and performance optimization.
• Represent BI in stakeholder and leadership discussions, clearly communicating risks, trade-offs, and constraints.
• Define and maintain documentation, ticketing, and process standards across the BI team.
• Evaluate new tools, technologies, and features, recommending adoption when beneficial.
• Manage delivery across multiple concurrent projects, balancing scope, risk, and timelines.
• Ensure the BI platform and toolset remain aligned with evolving business objectives and future growth.

Required Skills

• Bachelor's degree in Computer Science, MIS, Data Science, Mathematics, or a related field.
• 5+ years of experience in business intelligence, analytics engineering, or data engineering.
• Strong hands-on expertise with Snowflake, dbt, Python, and advanced SQL (including window functions, query optimization, and aggregation logic).
• Experience designing data models using medallion or dimensional architecture in cloud data warehouses.
• Experience with data ingestion tools and methods such as Snowpipe, APIs, webhooks, SFTP, and file-based integration.
• Proficiency in version control using GitHub and developing Python-based solutions.
• Proven ability to establish technical standards, mentor developers, and lead delivery across multiple initiatives.
• Strong communication skills with the ability to engage both technical and executive audiences.
• Ability to work independently, exercise sound judgment, and drive high-impact initiatives in a fast-paced environment.

Preferred Skills

• Industry experience in restaurant, hospitality, or retail environments (especially with sales, labor, or POS data).
• Experience working across cloud platforms, particularly AWS and Azure.
• Familiarity with CI/CD pipelines, automated testing, and data engineering best practices.
• Experience defining and managing processes for ticketing, change management, and documentation.
• Advanced Tableau skills (including LOD expressions and performance optimization).
• Experience with Streamlit, PowerShell, and PostgreSQL.