Senior Analyst

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 

We are seeking a highly analytical and detail-oriented Senior Data Analyst to lead data management, reporting, automation, and system development initiatives across the organization. The role focuses on transforming raw data into meaningful insights, designing and implementing automated systems, strengthening data structures, and supporting cross-functional teams with accurate, actionable intelligence to drive strategic and operational business decisions.

Key Responsibilities

1. Data Management & Reporting

• Collect, clean, validate, and consolidate data from multiple internal and external sources.
• Prepare and deliver daily, weekly, and monthly MIS reports for management and departments.
• Design, develop, and maintain dashboards to track KPIs, performance metrics, and operational trends.

2. Database & Data Accuracy Management

• Manage and regularly update internal databases, spreadsheets, and reporting systems.
• Ensure data accuracy, consistency, integrity, and confidentiality across all platforms.
• Implement best practices for data validation, version control, and audit checks.

3. Data Analysis & Business Insights

• Analyze large and complex datasets to identify trends, patterns, gaps, and anomalies.
• Translate data findings into clear, actionable insights and recommendations to support strategic and operational decision-making.

4. Reporting Automation, System Recommendation & Implementation

• Identify opportunities to replace manual or semi-manual processes with automated, data-driven systems.
• Design and implement automated reporting frameworks, dashboards, and data pipelines using Excel (Power Query, VBA, Macros), SQL, BI tools, and Python.
• Proactively suggest new automation tools, system enhancements, or integrations to improve efficiency, accuracy, and scalability.
• Lead the end-to-end implementation of approved automation initiatives, including requirement gathering, system design, testing, deployment, and stabilization.
• Continuously monitor and optimize automated systems in line with business growth and evolving data needs.

5. Cross-Functional Coordination & Support

• Collaborate with Sales, HR, Finance, Operations, and other departments to understand reporting and data requirements.
• Provide support for ad-hoc analysis, custom reports, and special data requests.
• Act as a data partner to department heads for decision support and performance tracking.

6. Documentation & Compliance

• Maintain complete and updated documentation for MIS processes, reports, data models, automation logic, and system changes.
• Ensure compliance with company data governance policies and applicable data protection standards.

System Development & Data Structuring Responsibilities

• Study and understand departmental workflows to evaluate how data is generated, processed, and utilized.
• Review existing manual and digital data systems to identify operational gaps, risks, and improvement opportunities.
• Recommend structured data models, reporting formats, and storage solutions aligned with business requirements.
• Coordinate with department heads to define data structures, access levels, and reporting standards.
• Implement new or upgraded data systems (Excel-based models, cloud platforms, ERP integrations) with minimal operational disruption.
• Design structured data formats and role-based access controls to ensure secure and organized data management.
• Train employees on newly implemented systems and provide post-implementation support.
• Monitor system performance, resolve issues, and continuously improve systems based on user feedback and organizational growth.

Qualifications & Experience

• Bachelor’s degree in Commerce, Statistics, Computer Applications, or a related field.
• 3–5 years of experience in data analytics, reporting, or system automation roles.
• Strong analytical thinking, logical reasoning, and problem-solving abilities.
• High attention to detail with excellent organizational and documentation skills.

Technical Skills (Must Have)

• Advanced Excel: Power Query, Power Pivot, VBA basics, Macros, Charts
• Python or R: Data cleaning, analysis, automation (Pandas, NumPy, etc.)
• BI Tools: Power BI or Tableau (DAX, data modeling, dashboard optimization)
• Data Warehousing Concepts: ETL processes, OLAP, Star/Snowflake schema
• Google Apps Script: Automation in Google Sheets, custom functions, triggers, API integrations, workflow optimization

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.

Job Description

We are looking for a senior resource with Analyst skills and knowledge of IT projects, to support delivery of risk mitigation activities and automation in Aviva’s Global Finance Data Office. The successful candidate will bring structure to this new role in a developing team, with excellent communication, organisational and analytical skills. The Candidate will play the primary role of supporting data governance project/change activities. Candidates should be comfortable with ambiguity in a fast-paced and ever-changing environment. Preferred skills include knowledge of Data Governance, Informatica Axon, SQL, AWS. In our team, success is measured by results and we encourage flexible working where possible.

Key Responsibilities

• Engage with stakeholders to drive delivery of the Finance Data Strategy
• Support data governance project/change activities in Aviva’s Finance function.
• Identify opportunities and implement Automations for enhanced performance of the Team

Required profile

• Relevant work experience in at least one of the following: business/project analyst, project/change management and data analytics.
• Proven track record of successful communication of analytical outcomes, including an ability to effectively communicate with both business and technical teams.
• Ability to manage multiple, competing priorities and hold the team and stakeholders to account on progress.
• Contribute, plan and execute end to end data governance framework.
• Basic knowledge of IT systems/projects and the development lifecycle.
• Experience gathering business requirements and reports.
• Advanced experience of MS Excel data processing (VBA Macros).
• Good communication

Additional Information

Degree in a quantitative or scientific field (e.g. Engineering, MBA Finance, Project Management) and/or experience in data governance/quality/privacy
Knowledge of Finance systems/processes
Experience in analysing large data sets using dedicated analytics tools

Designation – Assistant Manager TS

Location – Bangalore

• Relevant work experience as an Accountant
• Graduation is a must. Female candidates preferred
• Excellent communication skills
• Willingness to work 6 days a week
• Good knowledge and work experience in Tally
• Excellent in time management and critical thinking
• Candidate who can multitask and with an eye for detail    

• 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