Data Analytics Analyst: Dashboards, Python & SQL

About Us

Eat Well, Live Well. At Ajinomoto Cambrooke, we build careers grounded in helping improve people’s health through nutritional therapies.

Ajinomoto Cambrooke (ACI) was founded by parents looking to develop better solutions for their children with PKU. Over the subsequent 25 years, we have expanded into additional therapeutic areas with a focus on enjoyable nutrition as a core part of normalizing the life for people living with medical conditions.

Joining ACI means becoming part of a diverse team of talented people who want to build their careers while contributing back to society in a positive way. We seek individuals who bring an entrepreneurial mindset with a bias for action and finding solutions. We provide an environment based in mutual respect and collaboration to support you and give you opportunities to learn and develop.

Join us to find a rewarding work experience that lets you be at your best and have an impact on our patient communities.

The Business Data Analyst role requires an inquisitive, analytical, and self-motivated professional to act as key liaison to the Commercial and Executive Leadership Team in planning and executing business strategy based on data driven results. Core responsibilities include gathering, cleaning, analyzing, interpreting and presenting data to identify trends, patterns, and insights that help shape future business decisions. The position focuses on financial and commercial data models but will provide support across the organization.

The Business Data Analyst reports to the VP Finance/Treasurer and will interface with sales, marketing, client services, reimbursement, finance, and senior leadership.

EDUCATION, CERTIFICATIONS AND

EXPERIENCE:

• Bachelor’s Degree required preferably in Data Analytics, Business or Finance related fields.

• 1-2 years’ experience in analytics or consulting analyst role.

• 1-2 years’ experience with data visualization tools like Power BI (Preferred), Tableau, etc.

KNOWLEDGE, SKILLS AND ABILITIES:

• Must be able to independently write scripts/code using Python/Pandas (Preferred), SQL (Preferred), or other analytical coding language.

• Expert Level knowledge with Microsoft Applications including Excel and PowerPoint. Must know pivot tables, joins (VLOOKUP and SQL), dynamic cell references, charts/graphs, and workflow diagrams. Working knowledge of Power Query, Power Pivot, DAX Calculations.

• Able to programmatically connect data sources via APIs or other automated methods

• Excellent analytical skills required. Ability to analyze/reconcile large amounts of data (in memory) and see gaps or trends that may impact anticipated results or identify that a change or new solution is required.

• Proven problem solving, critical thinking and evaluation skills. Ability to teach themselves new analytical skills without much manager oversight.

• Superior interpersonal abilities. Ability to work with diverse personalities at all organizational levels in pursuit of the company’s goals; tactful, mature and flexible.

• Strong communication and presentation skills. Must be able to facilitate working meetings, ask questions and apply active listening skills, and convey data driven results. Must demonstrate ability to design dashboards with complex information in a clean user-friendly manner

• Passionate about documentation. Ability to create clear and concise documentation that is reusable and reproduceable.

• Ability to work independently with minimal direction, take initiative within scope of work responsibilities

• Ability to prioritize and organize in order to manage multiple projects, analyze multiple data sets simultaneously:
Analysts may face competing workflows, managing multiple projects at once, or analyzing multiple data sets simultaneously.

WORKING CONDITIONS:

• Fast paced environment.

• Majority of work is completed in an office setting working inside a temperature-controlled environment.

• Occasional work outside may be required to support employee events.

• May perform activities in an environment containing hazardous elements and requiring safety awareness and adherence to all…