BI Developer

Senior Bi Developer

Software Guidance & Assistance, Inc., (SGA), is searching for a Senior BI Developer for a full time role with one of our premier restaurant industry clients in Dallas, TX.

The BI Developer (Business Integration Specialist) is a hands-on role that combines data integration, analytics, and business partnership. This role works directly with business users to identify reporting needs, automate processes, and deliver reliable data solutions and insights.

The position supports, maintains, and expands the reporting environment, contributing to ETL/ELT processes, medallion architecture, and data integrity within a Snowflake-based platform. This role is designed for growth, with opportunities to build expertise in modern data engineering tools and practices such as Snowflake, dbt, and Python, supported by mentorship from senior team members.

Responsibilities

• Partner with business users to gather requirements, identify reporting gaps, and translate needs into technical data solutions.
• Build, maintain, and optimize ETL/ELT pipelines for data ingestion and transformation using Snowflake, Snowpipe, dbt, and Python.
• Develop and enhance dashboards and reporting solutions using Tableau, Streamlit, or similar tools.
• Integrate data from internal and external sources, including APIs, webhooks, SFTP, web scraping, and file-based feeds.
• Develop and manage Python code using GitHub for version control.
• Own assigned tasks end-to-end, from requirement intake through development, validation, and delivery.
• Validate data accuracy against source systems and benchmarks prior to release, resolving discrepancies independently.
• Diagnose and resolve pipeline and data issues through structured debugging and error handling.
• Communicate progress, risks, and updates proactively through ticketing systems and collaboration tools.
• Assess downstream impacts of changes to shared data models, views, and dashboards.
• Create and maintain clear technical documentation and operational reports.
• Track, prioritize, and resolve work items through a ticketing system while adhering to team processes and delivery standards.

Required Skills

• Bachelor's degree in Computer Science, MIS, Data Science, Mathematics, or a related field.
• 1–3 years of experience in business intelligence, analytics, or data engineering (or equivalent hands-on project/internship experience).
• Working knowledge of SQL and Python.
• Familiarity with, or willingness to learn, Snowflake or comparable cloud data platforms.
• Strong written and verbal communication skills, with the ability to communicate effectively with business stakeholders.
• Ability to work independently and drive tasks to completion with minimal supervision.
• Adaptability in fast-paced, evolving environments.
• Strong organizational, analytical, and detail-oriented problem-solving skills.

Preferred Skills

• Experience building data models and transformations using dbt and managing code in GitHub.
• Experience with data ingestion tools such as Snowpipe or similar technologies.
• Industry experience in restaurant, hospitality, or retail environments.
• Proficiency with Microsoft Excel and SharePoint.
• Familiarity with cloud platforms such as AWS and/or Azure.
• Experience with ticketing systems (e.g., FreshService or similar).
• Exposure to 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.