Skip to main content
Search Jobs

BU - Datawarehouse analyst

Bengaluru, India

Apply NowApply Later
Req ID R-10411 Title BU - Datawarehouse analyst City Bangalore State / Province Karnataka Country India

At Lilly, we unite caring with discovery to make life better for people around the world. We are a global healthcare leader headquartered in Indianapolis, Indiana. Our 35,000 employees around the world work to discover and bring life-changing medicines to those who need them, improve the understanding and management of disease, and give back to our communities through philanthropy and volunteerism. We give our best effort to our work, and we put people first. We’re looking for people who are determined to make life better for people around the world.

Job Description:

At Lilly, we unite caring with discovery to make life better for people around the world. We are a global healthcare leader headquartered in Indianapolis, Indiana. Our 39,000 global employees work to discover and bring life-changing medicines to those who need them, improve the understanding and management of disease, and give back to our communities through philanthropy and volunteerism. We give our best effort to our work, and we put people first. We’re looking for people who are determined to improve the quality of life for patients around the globe.

Basic Qualifications:

  • Bachelor’s degree or equivalent experience
  • 3+ years ETL and/or Business Intelligence tools
  • Familiar with the technical architecture associated with databases and analytics environments
  • A high level of intellectual curiosity, external perspective, and innovation interest
  • Strong analytical, problem solving and investigative skills
  • Solid background in Information Technology with demonstrated ability to quickly learn new technology and business process
  • Demonstrated interpersonal skills, teamwork and people development
  • Ability to communicate proactively and effectively with IT and business stakeholders
  • Experience in applying quality and compliance requirements

Additional Information:

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

Travel Percentage :

0-10%

Responsibilities :

Lilly USA IT Solution and Insights Services is responsible for driving technology innovation for the US Affiliate. You will primarily focus on data integration and analytic solution delivery. This position will report to the IT manager primarily responsible for solution delivery and innovation.

In this role, you will:

  • Develop data-centric solutions to be advance our business teams within the US Sales and Marketing Affiliate
  • Consult with internal customers (e.g. Brand teams) to develop analyses that lead to actionable insights
  • Work with data from multiple data sources to build integrated views that will drive decisions
  • Required technical proficiency in the core tools used by the solution services team (e.g. SQL, SSAS, Tableau, AWS Glue, Athena, Redshift, Python)
  • Required Ansi SQL,  Postgress SQL, Extract Transform and Load
  • Work in Agile Sprints with business facing project teams
  • Learn business processes and data used by business functions

Key Responsibilities:

  • Partner with and influence team members to drive solution delivery
  • Collaborate with both internal and external technical teams to understand the appropriate menu of technologies and tools, and then incorporate knowledge to improve solution delivery efforts
  • Design and build data visualizations (Tableau, PowerBI)
  • Develop proof of concepts
  • Understand the key elements of the project related data and business usage
  • Ensure design and development adheres to quality and compliance requirements
  • Responsible for the solution system performance and user experience (UX/UI)
  • Partner with vendor resources on solution development to ensure understanding of data and technical direction for solutions
  • Develop technical requirements and solution designs
  • Responsible for system testing, ensuring effective resolution of defects
  • Stay abreast of tools and technologies to deliver the best solutions to business
  • Ensure adherence to appropriate quality standards and risk-based decision-making for all delivery efforts
  • Ensure successful transition of applications to service management team through planning and knowledge transfer

Additional Skills/Preferences :

  • Experience with analytics and business intelligence solutions
  • Familiar with the technical architecture associated with databases and analytics environments
  • A high level of intellectual curiosity, external perspective, and innovation interest
  • Strong analytical, problem solving and investigative skills
  • Proven background in Information Technology with demonstrated ability to quickly learn new technology and business process
  • Proven interpersonal skills, teamwork and people development
  • Ability to communicate dedicatedly and effectively with IT and business partners
  • Experience in applying quality and compliance requirements
  • Superb interpersonal skills, both verbal and written
  • Positive, customer-focused, and ambitious attitude
  • Strong customer orientation and collaboration
  • Detail oriented, creative, and innovative approach to problem solving
  • Broad technical skills
  • Ability to adapt quickly in a constantly changing environment
  • Expertise with IT environment to be able to match business needs with available IT solutions
  • Self-management and ability to work autonomously and with ambiguity
  • Technical curiosity and desire to innovate
  • Experience with Sales & Marketing Business processes & systems
  • Skilled in user experience
  • Vendor resource project oversight
  • Business Intelligence Certifications
  • Data Modeler/Architect experience
  • Agile Methodology

Eli Lilly and Company, Lilly USA, LLC and our wholly owned subsidiaries (collectively “Lilly”) are committed to help individuals with disabilities to participate in the workforce and ensure equal opportunity to compete for jobs. If you require an accommodation to submit a resume for positions at Lilly, please email Lilly Human Resources ( Lilly_Recruiting_Compliance@lists.lilly.com ) for further assistance. Please note This email address is intended for use only to request an accommodation as part of the application process. Any other correspondence will not receive a response.

Lilly 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.

To submit resume, visit https://www.lilly.com/careers and apply to Req ID R-10411.

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.

Apply NowApply Later

About Science

Our scientists and researchers are developing the breakthrough medicines of tomorrow. Join us and become a creative innovator and thinker who can improve the lives of millions.

Recruiting Events

We’d love to meet you to discuss career opportunities. Check our calendar now to see when we’ll be in your area.

View All Events

Stay Connected

Job Alerts

By signing up for job alerts, you’ll be the first to learn about opportunities that could be a great fit for you via periodic email updates.

Sign Up

Join Our Talent Community

Share a bit about yourself, such as the career area you are interested in. We will then reach out to you when the perfect position is available!

Sign Up

Sign Up

Areas of InterestSearch for a category, location, or category/location pair, select a term from the suggestions, and click "Add.”