Sr. Business Intelligence Analyst ELT

Position Summary

Who we are

Proximo Spirits is a leading and innovative supplier in the Spirits industry with a portfolio of iconic Premium and Super Premium brands. Due to the strong offerings in our portfolio and great collection of people, we have experienced significant growth in the last few years. We are well positioned for future success and our goal is to continue increasing share in the industry.

What you will work on

The Sr. Business Intelligence Analyst ELT plays a key role within Proximo Spirits and the Business Intelligence and Analytics division championing the use of data analysis to drive Customer and Brand growth.

This person will lead key projects to bring and improve insight into key enterprise metrics and drive action based on the resulting insights. They will partner closely with teams across the company to understand their problems and design datasets that can deliver concrete insights in a scalable and sustainable way. They will communicate findings and implications for stakeholders from various functions. This person will report to the Manager of Analytics.

Key Responsibilities

• Design and Develop ETL Processes: Create and maintain efficient ETL pipelines to extract data from various sources, transform it to meet business requirements, and load it into data warehouses and other storage solutions.
• AWS Integration: Leverage AWS services such as S3, Redshift, Glue, Lambda, and RDS to design and implement scalable and secure data integration solutions.
• Develop and maintain new analytical capabilities and reporting utilizing Tableau, SQL and other tools that will help drive insights for Sales and Marketing.
• Python Scripting: Utilize Python for scripting and automation tasks within the ETL processes, ensuring data accuracy and reliability.
• Performance Optimization: Monitor and optimize ETL processes for performance and efficiency, identifying and resolving bottlenecks and issues.
• Documentation: Maintain comprehensive documentation of ETL processes, data flow diagrams, and data mappings.
• Apply data-driven strategic thinking to frame complex questions into analytical problems and provide meaningful insights
• Monitor and improve BI operations, automating processes where possible and identifying and correcting issues proactively

What you bring

• Initiative: Takes responsibility to get work done efficiently and effectively
• Analytical Mindset: Organizes and thinks through large amounts of information, arriving at a succinct conclusion
• Strategic thinking and problem solving: Understands category strategy and how to use analyses to deliver actionable findings for risks and opportunities
• Accountability: High level of accountability, flexibility, and self-direction to work autonomously
• Effective storyteller: Consistently goes beyond the data and translates the data into meaningful strategic stories bringing the data to life and driving insights-based business decisions
• Intellectual curiosity: Approaches business questions with curiosity to understand, build insights, and ultimately solve for the right action
• Passion for success, including the success of others: Track record of positive impact that includes a significant component of working with and through others to achieve the goal
• Proficient project manager: Able to prioritize team-level tasks and manage schedule to complete work on time and within deliverable expectations
• Detail oriented: Consistently delivers quality, error-free work with close attention to detail
• Strong interpersonal skills: Able to work well with others and collaborate productively with other team members and other divisions
• Communicate effectively: Demonstrates ability to effectively express ideas and opinions
• Developed Presentation Skills: Effective presentation acumen towards developing decks for audiences of various sizes and management level

Key Relationships

• Internal: Business Intelligence, Commercial Strategy, Field Sales, Marketing

Desired Experience, Knowledge, and Characteristics

• Bachelor's Degree or Master's degree in Computer Science (or related field) and 5+ years of experience.
• Experience leveraging technologies/tools such as Snowflake & Tableau.
• Experience building and maintaining data pipelines and architecture using SQL, Alteryx, and/or Matillion.
• Relational database modelling and implementation using SQL.
• Strong knowledge of data manipulation, database design, foundational data analytics and data platform structures; ability to manage large data sets & databases
• Expert Microsoft Office Proficiency

The salary range for this role is a base salary of $73,500 - $122,500 along with an annual bonus, 401K match, and medical and wellness benefits. The range will vary if outside of this location. Base salaries are determined during our interview process, by assessing a candidate’s experience and skill set against internal peers and against the scope and responsibilities of the position.