MIS Analyst
- Category: MIS Executive
- Location: Bengaluru, Karnataka
- Job Type: Full Time / Part Time
- Salary: Estimated: $ 15K to 29K
- Published on: 2025/09/20
• Good MS Excel skills (VLOOKUP, Pivot, Macros)
• MS Access (Data export, table creation and Queries)
• MS outlook
• Good communication skills
Microsoft Access Database Systems Analyst to develop, assess and analyze business and system database needs, exploring alternative options and provide consulting services to management.
Prepares high level and detailed technical specifications, ERD and work flow diagrams.
Works collaboratively with the management team to determine best mix of development, interfacing applications and solutions to meet business requirements and project objectives.
Typical project scope is small to large database development or maintenance database projects. Emphasis is on Microsoft Access Database experience, VBA/SQL knowledge and incorporating systems solutions that will benefit the business.
Skills and Competencies:
Microsoft (MS) Access experience
Experienced in MS Excel and spreadsheet development and analysis.
Relational database design (unique identifiers, relational table creation)
Understand and use data types
VBA knowledge and application
Advanced Form creation for adds, edits, deletions
Advanced reporting knowledge
Ability to create complicated IF statements and calculated fields
Knowledge of using multiple functions within fields such as datepart, min, max, avg,
Ability to create macros
Knowledge of importing and linking various sources of data such as Excel and Access.
SQL knowledge to create Select, Update, Delete, Union, Append queries. Outer joins, Equal joins
Ability to create emails and attach reports to them
Experience manipulating data within Excel or other files to the correct format for Access to read. Such as comma delimited files.
Key Accountabilities:
Technical skills and expertise to assess, research and analyse business and system needs
Organized with good time management skills - Business acumen
Strategic influencing - Can deal with ambiguity and manage change effectively
Comfortable in high pressure, deadline-oriented environment
Ability to adapt quickly; function independently
Creative thinker, breakthrough, innovative, out of the box thinker
Team player, cooperative with good interpersonal skills
Related jobs
-
MIS Executive
JOB DESCRIPTION Job description The sales MIS and Reporting executive will primarily focus on building various sales reports, across the corporate sales team, retail sales team with an eye for detail. This is an exciting opportunity to provide effect...
-
MIS Executive
Property and Asset Management What This Job Involves You will be performing the role of client finance and accounting at the site and will be responsible for the the financial services scope and responsibility defined in the Property Management Servi...
-
MIS Executive
Responsibilities: Oversee the availability and security of company computer systems Measure computer system performance and upgrade systems as necessary Recommend system-wise changes when appropriate Assist in the implementation of new hardware and s...