Alliance Animal Health Jobs (2)

Job Description Do you dream in SQL or think Tableau is a fun playground for reporting? Do you thrive in understanding the P&L drivers of the business and finding opportunities to create a material impact? Does a well-structured Redshift environment fill you with delight? Do you love animals? Then this is the role for you! This is a perfect opportunity for someone who is rising in their career and ready for the next chapter to lead our data insights and reporting for the organization. This is a new function, and our Sr. Data Analyst will be a critical to our continued growth and success. They will use their rich knowledge of data activation and our business strategies to provide sound business recommendations and share insights with across all departments. This individual will partner closely with stakeholders across the organization and through external vendors to develop our dashboards, ad hoc analysis, and multi-unit individual reporting for our 150+ practice fleet. Our ideal candidate is a detailed data excavator, expert communicator, and top-notch analyst. They will be wholly committed to the discovery and development of reporting and insights to drive material performance improvement for the business. The ideal candidate will thrive in a fast-paced, entrepreneurial environment with a no-job-too-big or small attitude. They will have a mix of inquisitiveness, learning agility, emotional intelligence, and drive for success. Key Responsibilities Extract data, create reports, monitor KPIs, share insights, create presentations, and make recommendations based on the findings Develop meaningful and lasting relationships with stakeholder teams across business units (i.e., finance, operations, marketing, people ops, business development) to develop reporting requirements, identify data source needs with our data engineer, and build the end reports, communicating effectively and efficiently with internal, external, and executive teams Proactively identify key business trends and opportunities for cross functional leaders Leverage the AAH database to produce reports, analytics and select campaigns leveraging SQL, Excel, and visualization tools to drive material improvements for the business Utilize the end BI tools to create reports, dashboards and visualizations and provide the insight analysis based on the business objective (Tableau) Work to identify and recommend prioritization for cross functional reporting and data sourcing required to deliver against the need Partner with outside partners to communicate data and reporting / analytics requirements and act as internal project manager to deliver projects Ensure appropriate data accessibility across internal, external and practice teams Partner with Email / Text / CRM vendors to cut audience segmentations from our warehouse and deliver campaign lists and create / deliver reports to analyze results (SQL required) Develop both automated, scheduled reporting and accessible dashboards based on user type and access need Structure large data sets to find usable information Ensure data quality assurance for all reporting and effectively resolve issues with clear communication along the way Maintain, unify, and update our data dictionary across departments Educate staff members through training and individual support Qualifications 3+ years of proven experience in an analytics role High proficiency in SQL, Excel, and database management (Redshift) Extensive experience with data visualization with Tableau Knowledge of relational databases Knowledge of marketing campaign selection and analysis (email / text / digital) required Ability to both manipulate and leverage data to produce reports and select campaign lists Deep understanding of P&L drivers Excellent communicator (written and verbal) with the ability to translate data into actionable insights Hands-on aptitude with a willingness to troubleshoot and solve complex problems Intellectual curiosity to discover new approaches, tools, and insights Ability to collaborate cross functionality and function effectively as an individual leader Excellent attention to detail Excellent time management skills and the ability to work towards meeting multiple deadlines simultaneously Knowledge of web analytics tools preferred knowledge of Python preferred Preferred prior experience in a startup environment or client-facing / consulting experience Additional Information WE ARE A DRUG-FREE & EQUAL OPPORTUNITY EMPLOYER. Company Policy Forbids Discrimination Because of Age, Color, Race, Religion, Sex, Disability, Marital Status, Sexual Orientation or National Origin.

Job Description Do you dream in SQL or think Tableau is a fun playground for reporting? Do you thrive in understanding the P&L drivers of the business and finding opportunities to create a material impact? Does a well-structured Redshift environment fill you with delight? Do you love animals? Then this is the role for you! This is a perfect opportunity for someone who is rising in their career and ready for the next chapter to lead our data insights and reporting for the organization. This is a new function, and our Sr. Data Analyst will be a critical to our continued growth and success. They will use their rich knowledge of data activation and our business strategies to provide sound business recommendations and share insights with across all departments. This individual will partner closely with stakeholders across the organization and through external vendors to develop our dashboards, ad hoc analysis, and multi-unit individual reporting for our 150+ practice fleet. Our ideal candidate is a detailed data excavator, expert communicator, and top-notch analyst. They will be wholly committed to the discovery and development of reporting and insights to drive material performance improvement for the business. The ideal candidate will thrive in a fast-paced, entrepreneurial environment with a no-job-too-big or small attitude. They will have a mix of inquisitiveness, learning agility, emotional intelligence, and drive for success. Key Responsibilities Extract data, create reports, monitor KPIs, share insights, create presentations, and make recommendations based on the findings Develop meaningful and lasting relationships with stakeholder teams across business units (i.e., finance, operations, marketing, people ops, business development) to develop reporting requirements, identify data source needs with our data engineer, and build the end reports, communicating effectively and efficiently with internal, external, and executive teams Proactively identify key business trends and opportunities for cross functional leaders Leverage the AAH database to produce reports, analytics and select campaigns leveraging SQL, Excel, and visualization tools to drive material improvements for the business Utilize the end BI tools to create reports, dashboards and visualizations and provide the insight analysis based on the business objective (Tableau) Work to identify and recommend prioritization for cross functional reporting and data sourcing required to deliver against the need Partner with outside partners to communicate data and reporting / analytics requirements and act as internal project manager to deliver projects Ensure appropriate data accessibility across internal, external and practice teams Partner with Email / Text / CRM vendors to cut audience segmentations from our warehouse and deliver campaign lists and create / deliver reports to analyze results (SQL required) Develop both automated, scheduled reporting and accessible dashboards based on user type and access need Structure large data sets to find usable information Ensure data quality assurance for all reporting and effectively resolve issues with clear communication along the way Maintain, unify, and update our data dictionary across departments Educate staff members through training and individual support Qualifications 3+ years of proven experience in an analytics role High proficiency in SQL, Excel, and database management (Redshift) Extensive experience with data visualization with Tableau Knowledge of relational databases Knowledge of marketing campaign selection and analysis (email / text / digital) required Ability to both manipulate and leverage data to produce reports and select campaign lists Deep understanding of P&L drivers Excellent communicator (written and verbal) with the ability to translate data into actionable insights Hands-on aptitude with a willingness to troubleshoot and solve complex problems Intellectual curiosity to discover new approaches, tools, and insights Ability to collaborate cross functionality and function effectively as an individual leader Excellent attention to detail Excellent time management skills and the ability to work towards meeting multiple deadlines simultaneously Knowledge of web analytics tools preferred knowledge of Python preferred Preferred prior experience in a startup environment or client-facing / consulting experience Additional Information WE ARE A DRUG-FREE & EQUAL OPPORTUNITY EMPLOYER. Company Policy Forbids Discrimination Because of Age, Color, Race, Religion, Sex, Disability, Marital Status, Sexual Orientation or National Origin.