Senior Analyst

Job Title : Cognos BI Developer

Experience : 6+ Years

Location : Bangalore / Hyderabad (Hybrid)

Notice Period : Immediate Joiners Preferred (Candidates serving notice with 10–15 days left can be considered)

Interview Mode : Virtual

Job Description :

We are seeking an experienced Cognos BI Developer with strong data modeling, dashboarding, and reporting expertise to join our growing team. The ideal candidate should have a solid background in business intelligence, data visualization, and performance analysis, and be comfortable working in a hybrid setup from Bangalore or Hyderabad.

Mandatory Skills :

Cognos BI, Framework Manager, Cognos Dashboarding, SQL, Data Modeling, Report Development (charts, lists, cross tabs, maps), ETL Concepts, KPIs, Drill-through, Macros, Prompts, Filters, Calculations.

Key Responsibilities :

1. Understand business requirements in the BI context and design data models using Framework Manager to transform raw data into meaningful insights.
2. Develop interactive dashboards and reports using Cognos Dashboard.
3. Identify and define KPIs and create reports to monitor them effectively.
4. Analyze data and present actionable insights to support business decision-making.
5. Translate business requirements into technical specifications and determine timelines for execution.
6. Design and develop models in Framework Manager, publish packages, manage security, and create reports based on these packages.
7. Develop various types of reports, including charts, lists, cross tabs, and maps, and design dashboards combining multiple reports.
8. Implement reports using macros, prompts, filters, and calculations.
9. Perform data warehouse development activities and ensure seamless data flow.
10. Write and optimize SQL queries to investigate data and resolve performance issues.
11. Utilize Cognos features such as master-detail reports, drill-throughs, bookmarks, and page sets.
12. Analyze and improve ETL processes to enhance data integration.
13. Apply technical enhancements to existing BI systems to improve their performance and usability.
14. Possess solid understanding of database fundamentals, including relational and multidimensional database design.
15. Hands-on experience with Cognos Data Modules (data modeling) and dashboarding.

An MIS Executive is responsible for managing data, generating reports, and supporting decision-making by maintaining accurate information systems—mostly using tools like Excel, databases, and reporting software.

🔹 Key Responsibilities

• Collect, clean, and manage large sets of data
• Prepare daily / weekly / monthly reports for management
• Create dashboards using tools like Excel, Google Sheets, or BI tools
• Analyze data trends to support business decisions
• Maintain and update databases regularly
• Coordinate with different departments for data requirements
• Ensure data accuracy and consistency
• Automate reports using formulas, macros, or scripts

🔹 Required Skills

• Strong knowledge of Microsoft Excel (VLOOKUP, Pivot Tables, Macros)
• Basic understanding of SQL (optional but valuable)
• Familiarity with reporting tools like Power BI or Tableau
• Good analytical and problem-solving skills
• Attention to detail
• Basic communication skills 

Education: BE / B.Tech- EEE/ECE/E&I/ Instrumentation and Control
Experience: 3-6 years in the graduates.
Minimum 3+ years of experience in Industrial Automation applications for manufacturing environment.

Domain knowledge: In areas of Industrial Automation technology tools – PLC/DCS/SCADA/HMI for Manufacturing in one or more of the following verticals: Chemicals, Glass, Construction products, Automotive, Abrasives, ceramics industries.

Requirements:

• To be part of Digital Manufacturing and Industry 4.0 projects across Saint Gobain group of companies
• Design and develop Industrial automation applications for discrete, process and hybrid Manufacturing
• Experience in working with various Automation OEM or systems Integrators- Rockwell/Siemens/Schneider
• Experience in providing the network architecture for connectivity of PLC/DCS/OPC/HMI for software integration
• Experience in Industrial automation tools- feature selection, product evaluation for cost effective solution
• Expertise in Industrial automation - Best Practices, Industry Standards and integration methodologies
• Experience in various SCADA platforms such as - GE Proficy, Wonderware, Siemens Win CC, RA Factory Talk
• Collaborate with multi-functional teams to provide Industrial Automation solutions for Digital Manufacturing
• Part of end to end project of automation right from design to delivery of the project.

1.       Core Responsibilities

·      Building feasible solutions/applications for our clients – this includes developing bots using Automation Anywhere new cloud-based platform A360, assisting in the design and development of Automation TaskBots to automate Business Processing involving various technologies including Web & Windows applications, Database, Image Recognition (OCR), PDF Integration, API, and Web Services

2.       Experience Requirements

·      5 plus years of Software Development experience in any RPA tool. Preferably Automation Anywhere

·      Providing guiding and training for customers around the application best practices

·      Assist with guidance for the application environment and helping to troubleshoot if necessary

·      Understand the technological pain areas of prospective customers and helping create a Proof of Concept that aligns to their needs and budget

·      Knowledge Requirements

·      Experience with Automation Anywhere, or related robotic process automation software

·      Programming or development experience (Java, .Net, C#, Visual Basic, VB.net, R, etc.)

·      Scripting knowledge or experience (Python, Perl, VB Script, Shell script, PowerShell, etc.)

·      Experience creating macros

·      Ability to understand and create business process workflow diagrams or procedural documentation

·      Understanding of SDLC, Waterfall, and Agile Development Methodologies

·      Exposure to performance measurement and continuous improvement methodologies

·      Strong problem solving and troubleshooting skills

Task:

• Make documentations with formatting and in proper detailing
• Basic knowledge on Excel working with formula handling & reporting.
• Need to do multitasking, able to deliver tasks on time with expected quality
• Candidate should have thinking out of the box which supports the department to deliver good results in the pre-defined processes.
• Needs to be quick learner and able to come up with own thoughts on the tasks explained/shared to deliver good results
• Work closely with German team for operative processes/execution/deliverables.
• Flexible to adopt the changes in terms of processes/task handling.
• Knowledge on order fulfillment processes, managing support content on the website, inputs on support handling processes are added advantage.

We wish:

• At least bachelor in any stream or equivalent experience
• At least 1 year of experience in MS-Excel or similar office tools – is preferred
• Knowledge on VB script, macros is preferred
• Documentation skills
• Good Communication skills, at least speaking in English is required
• Good analytical skills
• Eager to know/experiment new technology and tools
• Web Browsing , ability to search quick results from web
• Experience on process documentation & presentation is preferred
• Ability to work independently with little or no daily supervision
• Out of box thinking and quick learner with willingness to learn new things

We Offer:

• Freedom to realise your own ideas & individual career & development opportunity.
• A motivating work environment, flat hierarchical structure, numerous company events which cannot be forgotten and fun at work place with flexibilities.
• Professional challenges and career development opportunities.

• Experience in developing and validating diagnostics (UDS Protocol)
• Excellent knowledge of UDS Protocol (ISO 14229)
• Expertise in VBA / C# or Python Scripting
• Experience with Vector Toolchain - Candela Studio, CANoe + DIVA, CANape
• Experience in handling various Automotive diagnostic – Flashing, parameter changes, etc.
• Preferred experience in Matlab / Simulink
• Preferred experience ECU SW Development and architecture
• Fair communication interpersonal skills.
• Interpersonal skills.
• Good to have ISTQB certification

• 5 to 8 years of hands on experience in automating MS Office applications like Excel, Word, PPT and Outlook using VBA 
• 5 plus years of experience in the design, development, and implementation of programming code
• Experience in database development
• VBA - Should have good experience in developing efficient logic/algorithms using VBA
• Solid understanding of SDLC concepts 
• Solid experience in MS Excel (2003, 2007, 2010, 2013,2016)
• Must be good at all excel features and excel formulas 
• Well versed with complete MS Office package (Excel, Word, Outlook, PPT)
• Work both independently and as part of a team 
• Experience in requirements gathering, effort estimate, designing and implementation and creating mock-up screens 
• Experience in databases like MS SQL Server (2005 to 2012,2014), MySQL and MS Access 
• Must have strong database concepts and DB designing skills 
• SQL - must be good at writing efficient, fine-tuned queries using joins and aggregates 
• Experience in writing Stored procedures, Triggers and T-SQL
• Nice to have programming knowledge in C# 

• VBA, SQL 

• Strong analytical and problem-solving skills 
• Excellent interpersonal and communication skills 
• Should be able to take complete ownership of the project from requirements gathering to delivery and maintenance 
• Should be able to work independently 
• Must be Proactive and Self-motivated
• Must have the ability to prioritize the work, execute tasks and meet the deadline without fail 
• Effective time management skills 
• Customer Focus, Willing to learn and self- teach any new technology 
• Strong business and collaboration skills, and responsive to service needs and operational demands.

Job Description

Create intelligent dashboards and analytics for business team using advanced excel/access and powerpoint

Understand the sales and leadership metrics and create business reports with insights and recommendation

Maintain documentation related to reports/procedures and personal tasks

Collaborate with internal team for required inputs within deadline

Perform quality checks for data correctness and execute with fine attention to details

2-5 years of industry experience in MIS reports

Proficiency in advanced excel including Macros

High attention to details with ability to keep track of the assigned tasks

Willingness to work on flexible hours, ability to plan, estimate deadlines, prioritize workload

Skills required:

1. Advanced excel knowledge

2. Practical knowledge of Macros

3. Graduation is necessary

4. Min. experience of 2-3 years