26 days old

Commercial Enterprise Reporting - Technical Associate - Fixed Duration Employment

Greenfield, IN 46140
Commercial Enterprise Reporting - Technical Associate - Fixed Duration Employment
United States
North America
Elanco is a global animal health company that develops products and knowledge services to prevent and treat disease in food animals and pets in more than 90 countries. With a 64-year heritage, we rigorously innovate to improve the health of animals and benefit our customers, while fostering an inclusive, cause-driven culture for more than 5,800 employees. At Elanco, we’re driven by our vision of food and companionship enriching life – all to advance the health of animals, people and the planet. Learn more at www.elanco.com.
Position Description/Purpose:

Elanco is one of the largest global Animal Health companies. Until recently, Elanco was the Animal Health Division of Eli Lilly, but is now in the process of spinning off and become a standalone company. Elanco is a global, innovation-driven company that develops and markets products to improve animal health and protein production in more than 75 countries.

The Commercial Enterprise Reporting Associate will:
  • Help enable Elanco to maximize customer and company value through data insights and analytics.
  • Support our Commercial Excellence community by fully leveraging our Business Intelligence tool set, centered around Tableau.
  • Provide strong technical expertise and consulting in our data, data sources, reports and dashboards across the Elanco commercial organization.

Key Objectives/Deliverables:
  • Create, support, and maintain the semantic layer which provides data to the business report operations report developers
  • Create and support global level reports and dashboards using Tableau including SFE, Global Marketing, and Compliance reports
  • Work closely with and provide direction to the support team (both on-shore and off-shore) in determining best approach to meet reporting data source needs for business partners
  • Manage and administer Tableau developer licenses
  • Provide consultation to business partners on local report development needs
  • Help business partners analyze and troubleshoot dashboard performance issues
  • Perform data analysis to determine how data will be pulled into the reporting data source
  • Work with Business Integrator and Data Architect to determine best approach for obtaining and storing data in the database so that it can be reported on
  • Attend and participate in SFE related meetings. Provide guidance and direction around the data availability and feasibility of using that data for reporting purposes.
  • Work with the Enterprise Analytics team on Tableau server and/or performance issues
  • Monitor materialized views and Tableau Extracts for performance
  • Assist in the de-entanglement of the Tableau environment
  • Bachelor Degree
  • At least 1 year Enterprise reporting solution experience with Tableau
  • At least 1 year experience working with Structured Query Language (SQL)
  • Proven experience with Enterprise reporting solutions such as PowerBI, Qlik, Business Objects, etc.
  • Experience with Oracle database and PL/SQL
  • Excellent data analysis skills. Proven record as a problem solver
  • Business acumen: Ability to build and maintain business relationships at all levels of the organization. Ability to understand and build business process knowledge and communicate in business terms vs. IT.
  • Communication: Must be a strong communicator in a varied of areas / situations. Ability to communicate orally and written with business partners, leadership, peers, vendors.
  • Ability to provide creative solutions to complex reporting needs
  • Ability to create Tableau visualizations which are both user friendly and provide excellent insight into the data
  • Strong interpersonal skills/team player with a positive professional approach.
  • Experience with SFDC and/or Veeva
  • Experience with Sales and Marketing functions
  • A mindset which is both logical and creative
  • A creative flair for design
  • Independent worker; come with proposals instead of questions
  • This position is not permanent. It is for a fixed duration of two years with potential to extend annually for up to 4 years.
  • Lilly is an EEO/Affirmative Action Employer and does not discriminate on the basis of age, race, color, religion, gender, sexual orientation, gender identity, gender expression, national origin, protected veteran status, disability or any other legally protected status
  • Qualified candidates must be legally authorized to be employed in the United States. Lilly does not anticipate providing sponsorship for employment visa status (e.g., H-1B or TN status) for this employment position.


Posted: 2018-12-24 Expires: 2019-01-24

As one of the oldest continuously operating companies in the United States, we are proud of all the innovative work we’ve accomplished for the last 140 years to improve global health.

We are looking forward to an even more successful future in which continued innovation and contributions from top talent in all areas of our organization will be critical.

Are you looking for a way to make life better for people around the world? We have opportunities in many areas of our organization. Please use the search feature to see the wide scope of our positions.

Before you go...

Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

Share this job:

Commercial Enterprise Reporting - Technical Associate - Fixed Duration Employment

Greenfield, IN 46140
Facebook Share
Copy Job URL

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast