Business Intelligence Analyst

$70,700 - $94,200/Yr

Proximo Spirits - Jersey City, NJ

Full-time - Mid Level

Jersey City, NJ

Merchant Wholesalers, Nondurable Goods

About the position

Proximo Spirits is a leading and innovative supplier in the Spirits industry, known for its portfolio of iconic Premium and Super Premium brands. The company has experienced significant growth in recent years and is well-positioned for future success, aiming to continue increasing its market share. The Business Intelligence Analyst plays a crucial role within Proximo Spirits and the Business Intelligence and Analytics division, providing essential support on data analytics to drive customer and brand growth. This position involves collaborating with internal stakeholders to understand their challenges and designing datasets that deliver actionable insights in a scalable and sustainable manner. The analyst will communicate findings and implications to stakeholders across various functions, ensuring that insights are effectively translated into strategic actions. The Business Intelligence Analyst will be responsible for delivering and maintaining a robust portfolio of analytics solutions that assist Proximo in achieving its objectives and improving performance. This includes assisting with qualitative and quantitative custom research projects throughout all stages, from design to execution, analysis, and recommendations. The analyst will provide reports through Tableau and Excel to enhance business processes, create and edit SQL queries within Snowflake/Tableau, and manage data quality checks to ensure high-quality analytics. Additionally, the analyst will support data-driven strategic thinking, monitor and improve BI operations, and collaborate with other analysts to identify data sources and build scalable data models. The role requires effective communication with both technical and non-technical audiences and the ability to support ad-hoc requests as needed.

Responsibilities

• Collaborate with internal stakeholders to deliver and maintain a robust portfolio of analytics solutions that assist Proximo in achieving its objectives and improving performance.
• Assist with qualitative and quantitative custom research projects throughout all stages including design, execution, analysis, and recommendation.
• Provide reports through Tableau & Excel to improve business processes.
• Create and edit SQL queries within Snowflake/Tableau to build calculated fields.
• Create interactive filters, parameters, and calculations for preparing dashboards and worksheets in Tableau.
• Manage inclusive data quality checks to ensure high quality and build trust in the dashboards and analytics.
• Support data-driven strategic thinking to frame complex questions into analytical problems and provide meaningful insights.
• Provide deliverables grounded in consumer/shopper understanding and brand building fundamentals.
• Monitor and improve BI operations, automating processes where possible and identifying and correcting issues proactively.
• Collaborate with other analysts and stakeholders to identify data sources, build scalable data models, and operationalize the data analytics.
• Communicate with technical and non-technical audiences.
• Support ad-hoc requests as needed, including administrative tasks such as pricing inputs, program templates, and price reconciliation.

Requirements

• Bachelor's Degree or Master's degree in Computer Science (or related field) and 3 years of experience.
• Experience handling sensitive data, exercising judgment and discretion.
• Experience in working with ETL Tools, Tableau, SQL (JOINS, SUB-Categories), Python 3 Programming.
• Experience managing, manipulating, and validating large data sets from multiple systems, tools, and reports using statistical software or other methods.
• Experience building and maintaining data pipelines and architecture.
• 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.
• Experience in UI, UX space, demonstrable with evidence of using a combination of user interface tools such as wire frames, prototypes, mock-ups, or white boarding to illustrate product usability.
• Proficient with data exploration and data visualization tools like Tableau (Cloud/Desktop/Server, Prep), Looker, Chartio, Micro Strategy, PowerBI, and syndicated 3rd party data.
• Extensive Coding Language Background such as Python, R, SQL, JavaScript, HTML, CSS, C++.
• Experience importing libraries like Seaborn, Pandas.
• Expert Microsoft Office Proficiency - Excel to include advanced functions and logic (IF Statement, VLOOKUPS, RANDBETWEEN, PIVOT TABLES, SORTER).

Benefits

• Base salary range of $70,700 - $94,200 along with an annual bonus.
• 401K match.
• Medical and wellness benefits.