Business Intelligence Developer

Chicken Salad Chick - Atlanta, GA

Full-time

Atlanta, GA

Food Services and Drinking Places

About the position

The position involves designing and managing a centralized data architecture solution that is crucial for the organization’s data management strategy. The successful candidate will be responsible for reviewing and analyzing the existing data infrastructure, planning future databases, and implementing effective solutions to store and manage data efficiently. Collaboration with stakeholders is essential to understand business intelligence (BI) requirements, design needs, and implementation strategies, ensuring that the data architecture aligns with the organization's goals. In this role, the individual will translate business needs into technical specifications, which will guide the development and implementation of data solutions. The candidate will also evaluate and improve existing BI visualization and analytics tools, such as Tableau, to enhance data reporting and insights. Managing current data storage tools, particularly Snowflake, is a key responsibility, along with collaborating with teams to integrate third-party system data into the organization’s environment. The role requires the development and execution of database queries and conducting analyses to support various projects. Implementing and executing data governance best practices is also a critical aspect of the job. The candidate will create visualizations and reports for requested projects and will be responsible for developing and updating technical documentation to ensure clarity and consistency in data management practices.

Responsibilities

• Design and manage a centralized data architecture solution.
• Review and analyze data infrastructure, planning future databases, and implementing solutions to store and manage data.
• Collaborate with stakeholders to understand BI requirements, design needs, and implementation strategies.
• Translate business needs to technical specifications.
• Evaluate and improve existing BI Visualization and analytics tools (e.g. Tableau).
• Manage current data storage tools (e.g. Snowflake).
• Collaborate with teams to integrate third-party system data into our environment.
• Develop and execute database queries and conduct analyses.
• Implement and execute data governance best practices.
• Create visualizations and reports for requested projects.
• Develop and update technical documentation.

Requirements

• Proven experience as a BI Developer or Data Analyst.
• Industry experience is preferred.
• Proficiency in designing and implementing data models, including conceptual, logical, and physical schemas (data modeling).
• General knowledge of DBMS platforms (e.g., Snowflake).
• In-depth understanding of ETL (Extract, transform, load) framework (e.g. Matillion), DBMS (e.g. Snowflake), and online analytical processing and visualization (e.g. Tableau) and their administration.
• Understanding of or experience with cloud providers (e.g. Azure, Google Cloud) and their data services.
• Knowledge of data privacy regulations, security protocols, and best practices.
• Proficiency in languages like SQL or Python for data manipulation and scripting.
• Proven abilities to take initiative and be innovative.
• Analytical mindset to troubleshoot issues, optimize queries, and improve data performance.
• Ability to work with cross-functional teams, communicate complex ideas, and translate business requirements into technical solutions.
• Understanding of project lifecycles, agile methodologies, and project management tools.
• Working knowledge of Microsoft Office, Power Point, Excel and Outlook is required.

Nice-to-haves

• Knowledge of restaurant industry (operations, management) preferred.
• Previous experience in a similar role strongly preferred.