23 days old

Global Commercial Business Intelligence IT Consultant - FDE

Greenfield, IN 46140
Global Commercial Business Intelligence IT Consultant - FDE
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:

This is an exciting opportunity to join Elanco from the ground floor and become a valued member of the Global Commercial IT team supporting the company’s global commercial business. The focus of this role will be to drive development of the semantic layer for global reporting and work with key stakeholders to maximize business effectiveness through reporting, helping to make Elanco the “Best Run Animal Health Company”.

The Commercial Enterprise Reporting Associate will:
  • Encounter opportunities to build professional relationships and help influence business decisions
  • Be empowered to take action and drive results
  • Drive their own career

Key Objectives/Deliverables:
  • Use technical skills and creativity to develop, support, and maintain the semantic layer which provides data to the business report developers
  • 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
  • Work with key SFE (Sales Force Effectiveness) stakeholders to help drive efficiency and adoption of our CRM too
  • 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 of SQL development experience
  • Proven experience with Tableau
  • 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 and visualizing data
  • 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. As Elanco is constantly looking for talent, there is a possibility that this role becomes a permanent position
  • 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.
Apply to job Apply Later


Posted: 2019-01-25 Expires: 2019-02-28

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:

Global Commercial Business Intelligence IT Consultant - FDE

Greenfield, IN 46140
Facebook Share
Copy Job URL

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast