Mis Executive - Adyar, Chennai, Tamil Nadu, India - SITARAM JEWELS

SITARAM JEWELS

Verified Company

Adyar, Chennai, Tamil Nadu, India

3 weeks ago

Posted by:

Deepika Kaur

beBee Recuiter

Description

Job description

Develop and maintain advanced Excel spreadsheets, templates, and dashboards for data analysis and reporting purposes.
Design, develop, and manage databases using MS Access, ensuring data integrity and accessibility.
Write SQL queries to retrieve, manipulate, and analyse data from relational databases efficiently.
Collaborate with crossfunctional teams to identify data requirements and develop solutions to meet business needs.
Create and automate reports, data visualizations, and executive summaries to communicate insights effectively.
Develop VBA macros to automate repetitive tasks, improve efficiency, and enhance data analysis capabilities.
Perform data cleaning, validation, and data transformation activities to ensure data accuracy and consistency.
Conduct data analysis to identify trends, patterns, and anomalies, providing valuable insights to stakeholders.
Monitor data quality, identify data discrepancies, and implement corrective measures as necessary.
Stay uptodate with industry trends, best practices, and emerging technologies related to data analysis and MIS.

-
Must_ _
Have_ _:_

-
MS Access Query Design Experience
-
VBA Programming In Excel Experience
-
Excel Fluency
-
English (Written/Spoken) Fluency
-
Requirements:_

Bachelor's degree in Computer Science, Information Systems, or a related field.
Proven work experience as an MIS Analyst or similar role.
Strong proficiency in advanced Excel functions, formulas, pivot tables, and data visualization techniques.
Proficiency in MS Access for database development, management, and data manipulation.
Solid understanding of SQL query formation and experience working with relational databases.
Experience in developing VBA macros to automate tasks and enhance data analysis processes.
Strong analytical and problemsolving skills with a keen eye for detail.
Excellent communication and presentation skills, with the ability to convey complex information to nontechnical stakeholders.
Ability to work independently and as part of a team, managing multiple priorities and meeting deadlines.
Familiarity with data analysis tools and techniques, such as data modeling, data mining, and statistical analysis, is a plus.
Experience in business intelligence tools and reporting platforms is desirable.