Business Intelligence Analyst Ii
BANGALORE, KA, IN, 560048
TE Connectivity
At TE, you will unleash your potential working with people from diverse backgrounds and industries to create a safer, sustainable and more connected world.
Job Overview
TE Connectivity’s Business Intelligence Teams are responsible for the processing, mining and delivery of data to their customer community through repositories, tools and services.
The Business Intelligence Analyst will focus on Design, Develop and Maintaining Data driven solutions to support business reporting and analytics needs. This position requires expertise in advanced Excel, Advanced SQL Querying, Tableau dashboard development and automation of reporting processes. The candidate will play a critical role in Integrating data from multiple systems, analyzing it and delivering actionable insights.
To enhance data integration, reporting and analysis by developing automated and scalable solutions ensuring seamless data integration, BI tools and scripting to support meeting the Organization requirements efficiently improving operational efficiency.
Responsibilities:
Database Querying and Analysis:
• Write, Optimize and maintain complex SQL queries, stored procedures and views for data extraction and transformation from relational databases
• Analyze and troubleshoot database performance issues to ensure efficient querying
• Colloborate with database administrators to maintain data integrity and optimize query performance
• Ensure accuracy, timeliness and consistency of the data used in reporting.
• Extract, transform and load (ETL) data from diverse data sources, including ERP systems, flat files and cloud platforms.
• Design robust data models to support advanced analytics and predictive modelling
• Integrate data from multiple systems to create a unified view for business reporting
Tableau Dashboard Development and Report Automation:
• Design and develop Interactive visually appealing Tableau dashboards to provide actionable insights with a good User Experience feel
• Automate data extraction, and reporting processes using Tableau Prep and Scripting languages (Python, VBA, or R)
• Work with stakeholders to identify KPIs and translate business requirements into intuitive dashboards.
• Optimize dashboards for performance and ensure alignment with end-user needs and organizational objectives.
Report Automation and Process Optimization:
• Automate repetitive tasks and workflows using tools like Power Automate, Python, or VBA
• Identify opportunities for streamlining data collection, integration and reporting processes
• Develop reusable scripts and tools to enhance reporting efficiency and reduce manual efforts.
• Document processes and create user guides for automated solutions.
• Evaluate and implement industry best practices to continuously improve data and business intelligence processes.
Collaboration and Stakeholder Engagement:
• Collaborate with stakeholders to understand reporting requirements and deliver solutions that meet their needs.
• Act as a key resource for resolving data-related issues and ensuring data accuracy.
• Stay updated with emerging BI tools, data integration techniques and analytics trends
• Ability to quickly understand and navigate in TE digital database architecture and TE digital toolset
• Develop and maintain weekly / monthly global reporting dashboard for Engineering related KPI’s, maintain reporting accuracy, participate in data related projects such as system migration, customization projects.
Desired Candidate Profile:
• Bachelor’s degree in computer science engineering or information science or equivalent) or related technical field
• 3 to 5 years of Experience in Business Intelligence, Data Analysis and Report Automation
• SQL and Advanced Excel Expertise: Advanced Proficiency in SQL, including query optimization, joins and subqueries, Python, Power Query, Dynamic SQL Query, MYSQL, stored procedures, database optimization
• BI Tools: Strong expertise in Tableau (including Tableau Prep) and dashboard development and knowledge of Power BI is a plus.
• Automation: Hands-on experience with Python, VBA, Scripting languages for automation
• Database Integration: Hands on experience with ETL tools, data modeling.
• Strong aptitude to Problem Solving, Self-Motivated and Organized with the ability to work effectively under pressure in a fast-paced environment and Exposure to Product Development environment is an added advantage
• Knowledge of AI Driven Solutions, Machine Learning and Predictive Analytics is preferred
• Values that need to be demonstrated: Integrity, Accountability, Teamwork, Innovation mindset, Strategy Execution
Competencies
Values: Integrity, Accountability, Inclusion, Innovation, TeamworkABOUT TE CONNECTIVITY
TE Connectivity is a global industrial technology leader creating a safer, sustainable, productive, and connected future. Our broad range of connectivity and sensor solutions enable the distribution of power, signal and data to advance next-generation transportation, renewable energy, automated factories, data centers, medical technology and more. With more than 85,000 employees, including 8,000 engineers, working alongside customers in approximately 140 countries. TE ensures that EVERY CONNECTION COUNTS. Learn more at www.te.com and on LinkedIn, Facebook, WeChat, Instagram and X (formerly Twitter).
WHAT TE CONNECTIVITY OFFERS:
We are pleased to offer you an exciting total package that can also be flexibly adapted to changing life situations - the well-being of our employees is our top priority!
• Competitive Salary Package
• Performance-Based Bonus Plans
• Health and Wellness Incentives
• Employee Stock Purchase Program
• Community Outreach Programs / Charity Events
• Employee Resource Group
Across our global sites and business units, we put together packages of benefits that are either supported by TE itself or provided by external service providers. In principle, the benefits offered can vary from site to site.
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Architecture Business Intelligence Computer Science Data analysis Engineering ETL Excel Industrial KPIs Machine Learning MySQL Power BI Python R RDBMS SQL Tableau
Perks/benefits: Career development Competitive pay Equity / stock options Health care Salary bonus Wellness
More jobs like this
Explore more career opportunities
Find even more open roles below ordered by popularity of job title or skills/products/technologies used.