BI Developer

BI Developer

We are hiring a BI Developer! If you have 1–3 years of experience with SQL, Python, and a passion for data integration, we want you. This role offers great mentorship to grow your Snowflake and dbt skills. Apply today! #DataJobs #BIDeveloper #ETL #ELT

Position Summary

Anchor Point Management Group (APMG) is hiring a BI Developer (Business Integration Specialist) to join its Business Intelligence team. The role combines data integration and analytics partnership. The BI Developer works directly with business users across APMG’s portfolio of restaurant, hospitality, and retail brands to identify opportunities, automate processes, and deliver reliable data and reporting.

The position supports, maintains, and expands APMG’s reporting environment, contributing to ETL/ELT processes, medallion architecture, and data integrity in a Snowflake environment. This role is structured to grow with the BI function. The BI Developer will deepen their expertise in Snowflake, dbt, and modern data engineering practices over time, with support and mentorship from senior team members.

Primary Responsibilities

• Partner with business users to clarify requirements, identify reporting gaps and automation opportunities, and translate needs into technical solutions.
• Maintain, and optimize ETL/ELT pipelines that load and transform data into the Snowflake data warehouse, using Snowpipe for ingestion and dbt for transformation.
• Support, and expand reporting and visualization in Tableau, Streamlit, or a comparable tool. Integrate data from internal and third-party sources through APIs, webhooks, SFTP, web scraping, and file-based feeds.
• Manage and Maintain PowerShell and Python code through GitHub version control.
• Take ownership of assigned tasks end to end from intake and requirement clarification through development, validation, and delivery.
• Validate data against source systems and known benchmarks before publishing and resolve discrepancies in your own work before release.
• Ability to understand ETL/ELT pipeline issues and troubleshoot through error handling and debugging.
• Proactively communicate status, progress, and risks in tickets, Teams, or direct messages without waiting to be asked.
• Report downstream impact of changes to shared views, models, and dashboards before releasing them.
• Produce and maintain accurate technical documentation and operational reports.
• Track, prioritize, and resolve requests through the FreshService ticketing system, and follow team processes to deliver work that is on time, high quality, and highly available.

Technical Environment

Data Platform & Warehouse: Snowflake (AWS and Azure), Snowpipe

Transformation & Modeling: dbt, Python Databases Microsoft SQL Server, PostgreSQL

Development & Version Control: VS Code, GitHub, PowerShell

Data Integration: APIs, webhooks, SFTP, web scraping, file systems, Azure Blob

Reporting & Visualization: Tableau, Streamlit

Productivity & Analysis: Microsoft Excel, PowerPoint, SharePoint Service Management FreshService

Required Qualifications

• Bachelor’s degree in computer science, Management Information Systems (MIS), Data Science, Mathematics, or a related field.
• 1 - 3 years of experience in business intelligence, analytics, or data engineering (or equivalent internship/project experience).
• Working knowledge of GitHub, SQL and Python, and experience with or a willingness to learn PowerShell, Snowflake or a comparable cloud data warehouse.
• Strong written and verbal communication skills, with the ability to present clearly and concisely to business stakeholders.
• Ability to work independently with minimal supervision and to drive assigned work to completion.
• Ability to adapt and perform effectively in a fast-changing, high-demand environment.
• Strong organizational skills with a detail-oriented, task-oriented, and logical approach.

Preferred Qualifications

• Building data transformations and models with dbt and managing code in GitHub.
• Data ingestion using Snowpipe or a comparable tool.
• Restaurant, hospitality, or retail industry experience.
• Proficiency with Microsoft Excel and SharePoint.
• Knowledge of cloud data platforms on AWS and/or Azure.
• Familiarity with FreshService (or a comparable ticketing system), PowerShell, and PostgreSQL.