Analytics Ops Engineer – Data Visualization

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

Roles & Responsibilities 

Tableau & BI Platform:

• Install, configure, and maintain Tableau Server environments Multi node Architecture

• Manage Tableau users, groups, sites, projects, permissions, and security settings.

• Monitor server performance and conduct regular maintenance, backups, and upgrades.

• Automate server tasks using scripting tools (e.g., Tabcmd, Tableau REST API, PowerShell, Python).

• Lead version upgrades, patch management, and migration projects across multiple platforms.

• Experience on any performance monitoring tool

• Plan and execute capacity planning, resource scaling, and performance tuning for diverse BI tools.

• Integrate BI platforms with SSO/SAML/Active Directory for authentication and access control.

• Automate admin and deployment tasks using Python scripting and SQL queries for monitoring, reporting, and operational workflows.

• Develop and maintain disaster recovery and business continuity strategies for all BI tools.

• Monitor usage analytics and generate utilization reports for platform performance, user adoption, and resource optimization.

• Enforce compliance with data security and audit requirements.

• Mentor junior admins and lead cross-functional collaboration with IT, security, and BI teams.

• Establish standard operating procedures and documentation for platform administration.

• Recommend and implement system enhancements for scalability, performance, and operational efficiency.

• Strong problem-solving skills, with the ability to think critically and optimize complex data solutions. 

MS Fabric:

·         Strong hands-on expertise with Microsoft Fabric, Azure Data Factory, and related technologies.

·         Proficient in Fabric data ingestion from multiple sources, designing and maintaining data pipelines, and troubleshooting.

·         Monitoring and analysing pipeline execution logs to identify, diagnose, and resolve errors or performance bottlenecks.

·         Implementing automated alerts and error-handling mechanisms to proactively detect failures and ensure high availability.

·         Proficient in SQL, DAX, and other data query languages for analytics, administration, and automation.

·         Strong knowledge of ETL/ELT processes, data integration, and pipeline design.

·         Experienced with Microsoft Azure services including Azure Data Lake and Azure SQL Database.

·         Skilled in data governance, security, logs monitoring, and audit trail management to ensure compliance.

·         Manage installation, configuration, upgrades, and patching of Fabric and related services.

·         Monitor system health, usage metrics, and performance, providing optimization recommendations.

·         Conduct audit reviews of access, workspace activity, and dataset refresh history.

·         Adept at working in agile environments and collaborating with cross-functional teams.

·         Strong problem-solving and optimization skills for complex data solutions.

·         Expertise in data modelling and security configuration within Fabric and Power BI.

·         Understanding of Data Science concepts and experience handling large-scale datasets.

·         Collaborative mindset, working effectively with engineers, analysts, and business stakeholders

IBM Watson explorer:

·         Strong hands-on experience in installation, configuration, and optimization of Watson Explorer products, including Foundational Components and Analytical Components.

·         Lead and manage the full upgrade from Watson Explorer (12.03.xx)

·         Ensure compatibility, stability, and integration with existing enterprise systems.

·         Plan and coordinate upgrade timelines, dependencies, and deliverables with technical and business stakeholders.

·         Configure and enhance collections to ensure accurate indexing, search relevance, and optimized query performance.

·         Develop, modify, and troubleshoot REST API integrations for data ingestion, search queries, and external application connectivity.

·         Conduct comprehensive testing ( integration, regression, and performance) to validate system readiness.

·         Troubleshoot and resolve upgrade-related issues, ensuring data consistency, search accuracy, and performance tuning.

·         Monitor and analyse system logs, API error reports, and performance metrics to proactively address issues.

·         Implement security best practices for both collection data and API endpoints.

·         Prepare clear technical documentation covering migration steps, collection configurations, API endpoints, and operational guidelines

·         Work closely with application teams to troubleshoot and resolve issues such as slowness, incomplete data ingestion, or data mismatch.

·         Collaborate with infrastructure and network teams to identify, analyse, and resolve system connectivity, latency, and performance bottlenecks.

·         Take ownership of tasks, lead technical activities, and guide team members throughout project delivery.

Additional Information:

• Proficient in one of the above area or technology (fabric/powerBI/IBM Watson) is preferred.

• Availability to work flexible work hours is/may be required. This team will support continuous operations across two shifts and therefore, this role will require non-standard work hours, and some work on weekends and holidays.  Appropriate adjustments in benefits will be provided for employees working non-standard hours where applicable.

• This role is open across experience levels, and the final designation will be determined based on the interview and assessment outcomes.

Lilly is dedicated to helping individuals with disabilities to actively engage in the workforce, ensuring equal opportunities when vying for positions. If you require accommodation to submit a resume for a position at Lilly, please complete the accommodation request form (https://careers.lilly.com/us/en/workplace-accommodation) for further assistance. Please note this is for individuals to request an accommodation as part of the application process and 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.

#WeAreLilly