BI Engineer (Snowflake Developer)
Company: Raising Cane's
Posted on: March 17, 2023
At Raising Cane's Chicken Fingers - , our concept is focused and unique. We have only ONE LOVE - - quality chicken finger meals! Every talented Crewmember in our Restaurant Support Office (RSO) is integral to our success and a value to our rapidly growing company.
The Business Intelligence (BI) Engineer develops, maintains, and supports Raising Cane's BI data warehouse and data analytics systems, business and ETL/ELT reports, including active involvement in administration, documentation, support, and troubleshooting these systems. This position participates in all phases of the software development lifecycle, including requirements analysis, functional design, technical design, coding, testing, implementation, and post-implementation support. We seek a hands-on engineer and problem-solver with deep database development and administration experience. The role includes design, creation, ETL/ELT, implementation, and monitoring jobs and tables to ensure optimal performance. Expert ad hoc analysis skills along with solid report development experience are essential. Working under moderate supervision, this person will contribute to efforts to ensure the business intelligence platform and tools meet the Company's current and future goals. They will develop processes and solutions to maximize security, resiliency, sc ability, availability, and supportability. Must be highly collaborative with internal IT team members, business partners, and external consultants to implement BI solutions that deliver operational excellence. Proactively seek to make improvements to the BI environment, applying the continuous process improvement model. This person must possess excellent soft skills, including communication, critical thinking, superb work ethic, motivation, enthusiasm, eager to join a highly efficient BI department.
--- Create solutions using Snowflake, SnapLogic, and Tableau. -- Create/enhance ETL/ELT packages/processes using SnapLogic for data ingestion and transformation. -- Use semantic layer tools to position data for business self-serve analytics --- Prepare development estimates, create specifications, testing, and user documentation in collaboration with your team members. --- Collaborate in team processes and procedures to ensure a timely, high-quality delivery and highly available systems. --- Provide operational support for daily ETL/ELT processing, ensuring timely and complete data is available for reports, and analytics. --- Collaborate with your IT peers and business partners to focus on production support, service requests, and roadmap initiatives to ensure a balanced delivery of services and solutions aligned with business objectives. --- Proactively research and implement courses of action to prevent system/security problems. --- Provide technical application support to the non-technical user community. --- Communicate project and task status to the BI Director and Manager.
--- Development (must have cloud-based analytics database technology experience, Snowflake): -- Deep knowledge of database concepts with real-world experience implementing data warehouse, data lakes, and data marts in a production environment. -- Experienced ETL/ELT developer, including data flow, data extraction, data consolidation, change data capture, and transformation. -- SnapLogic experience desired, alternative extract tools (Matillion, Fivetran, dbt, etc.) acceptable. -- Ability to monitor and maintain production environment, assess performance issues, and respond to job failures. -- Excellent diagnostic skills and problem-solving with the ability to articulate the issues and steps needed to resolve quickly, both verbally and written. -- Skilled at complex SQL coding, including views, joins, and stored procedures development. -- Ability to understand and update existing SQL quickly to provide insights. -- Creation of analytics data resources, preferably using a semantic layer product such as AtScale or Kyvos.
--- Testing, Troubleshooting, and Support: -- Recognize data trends and correct data quality issues quickly, completely, and permanently. -- Unit test ETL/ELT packages. -- Participate in design reviews. -- Troubleshoot data warehouse ETL/ELT and query performance / accuracy problems.
--- Engagement: -- Have a solid aptitude for our business and the role IT & BI play in it. -- Learn new technologies and products quickly. -- Have solid organizational skills and the ability to multi-task in a fast-paced environment. -- Develop clear, effective, and business-user-oriented written documentation. -- Ability to see each task through to the end, producing quality deliverables. -- Excellent communication skills and critical thinking. -- Highly motivated, enthusiastic individual looking for an exciting opportunity. -- Able to shift attention from development to support and back quickly and effectively.
--- Attitude / Style: Accountability and Responsiveness: -- See It: Recognize and acknowledge the reality of situations and be flexible and adaptive. -- Own It: Accept responsibility for the realities you create for yourself and others, and project a sense of quality through expertise, responsiveness, sense of urgency, and action-orientation. -- Solve It: Create new solutions to problems and change reality through agile innovation.
-- Do It: Demonstrate commitment, courage, follow-through, empathy, collaboration, and consultation.
Education & Experience:
--- Must have -- Bachelor's Degree in computer science or related technical discipline. -- Five to seven years of IT software development experience. -- Minimum two years of Snowflake development.
Minimum 3-4 years data warehouse development experience on cloud platforms desirable.
Cloud data analytics development experience. -- Minimum four years of experience with each of the following: -Data warehousing practices and software development.
-Data modeling, data validation, and error reporting.
-Developing BI ETL/ELT. SnapLogic experience is a desirable. -- Minimum two years of experience developing analytics data resources.
--- Desirable -- Restaurant and/or retail IT experience.
The intellectual and physical demands described below are representative of what must be met by a Crewmember to perform the essential functions of this job successfully. Reasonable accommodations may be made to enable Crewmembers with disabilities to perform the essential functions.
--- Judgment - Applies knowledge and experience when addressing complex issues. --- Sense of Urgency - Prioritization should be flexible, as you may need to interrupt lower-priority tasks for urgent must-dos or production problems. --- Inspiring Trust - Earns the confidence and trust of others. Shows consistency between words and actions, delivers on commitments, produces high-quality work, demonstrates high standards of ethical conduct, protects confidential information and does not omit controversial information or change information to suit others. --- Drive for Stakeholder Success - Pursues goals aggressively; drives for results; demonstrate a strong commitment to organizational success; works to do what is best for all stakeholders (customers, equity holders, crewmembers, etc.). --- Communicate Openly - Proactively shares information in a timely and high-quality manner with others; participate in the open expression of ideas and opinions. --- Professionalism - Consistently treats individuals with dignity and respect, recognizing the importance of cultural differences. Has and maintains a positive sense of humor and uses humor appropriately. Embraces and demonstrates company values and ethics. Maintains reasonable expectations of self when balancing time and performance demands with personal and professional needs. --- Constructive Conflict - Ability to work through conflict to resolve issues in ways that encourage compromise and creativity, helping push groups to become more than the sum of their individual members
Keywords: Raising Cane's, Plano , BI Engineer (Snowflake Developer), IT / Software / Systems , Plano, Texas
here to apply!