Job Description
• 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
• 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
💡 Quick Summary
Seeking a career-building opportunity? The MIS Analyst position is now open for candidates interested in the MIS Executive sector. This role in Bengaluru offers a professional environment and growth potential.
Requirement Snapshot: Candidates should possess basic communication skills, a proactive attitude, and the ability to work in a team. Experience in MIS Executive is a plus.