Senior BI Developer

Software Guidance & Assistance, Inc., (SGA), is searching for an Senior BI Developer for a Full Time role with one of our premier Restaurant Industry clients in Dallas, TX .


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.
• lign 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.
• bility 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.
• dvanced Tableau skills (including LOD expressions and performance optimization).
• Experience with Streamlit, PowerShell, and PostgreSQL.

SGA is a technology and resource solutions provider driven to stand out. We are a women-owned business. Our mission: to solve big IT problems with a more personal, boutique approach. Each year, we match consultants like you to more than 1,000 engagements. When we say let's work better together, we mean it. You'll join a diverse team built on these core values: customer service, employee development, and quality and integrity in everything we do. Be yourself, love what you do and find your passion at work. Please find us at .


SGA is an Equal Opportunity Employer and does not discriminate on the basis of Race, Color, Sex, Sexual Orientation, Gender Identity, Religion, National Origin, Disability, Veteran Status, Age, Marital Status, Pregnancy, Genetic Information, or Other Legally Protected Status. We are committed to providing access, equal opportunity, and reasonable accommodation for individuals with disabilities in employment, and our services, programs, and activities. Please visit our company EEO page to request an accommodation or assistance regarding our policy.