India Analyst VBA MACROS
Share
Job Location:
Monthly Salary:
Posted on:
30+ days ago
Vacancies:
1 Vacancy
Department:
Job Summary
Description
Essential Duties
- Develop process automation tools and processes using VBA Excel Macros Python SQL PowerBI and other tools as needed.
- Enhance and maintain existing VBA Excel Macros Python programs and other tools as needed.
- Work with stakeholders to uncover all requirements and develop iteratively towards a user accepted product.
- Develop tools that are easy to maintain and enhance over time.
- Address and find solutions to bugs and issues in VBA Macros Python programs SQL queries PowerBI dashboards a timely manner.
- Write documentation for new and existing process automation tools and processes.
- Assists in uncovering issues evaluates various courses of action and promotes the best option for resolution.
- Becomes aware on how to locate and define new process improvement opportunities
- Acquires data from primary and secondary data sources and assists in analyzing and interpreting trends or patterns in complex data sets.
- Effectively use data visualization in summaries and or dashboards to enhance translation of data and findings.
- Performs data profiling and root cause analysis to identify and understand anomalies
- Aids in preparing reports on data summaries changes and trends for use by management. Works collaboratively to provide assessment and recommendations to management.
- Works to help resolve issues arising from internal department functions or as brought forth by internal or external customers to assigned department.
- Tracks issues to resolution within department and in partnership with other groups.
- Monitors overall workflow to ensure timely completion of projects and daily work requirements.
- Assists with special projects within assigned department or as part of cross-functional teams as required or assigned.
- Works as part of a team to determine areas of risk as new or changed processes are implemented.
- Able to use a standard process to develop quality software from requirements to deployment. Use tracking software to log progress during each step.
Other Skills:
- Intermediate to Advanced development skill in VBA for Excel. Must be able to make moderately complex macros from start to finish using VBA including UI and backend.
- Must be able to make understandable code with good comments and design in a way that promotes future enhancements easy bug-fixing and code re-use.
- Requires intermediate to advanced skills in Microsoft Office Suite (Excel).
- Intermediate to Advanced skills in Python software development.
- Basic to intermediate skills in SQL query development.
- Experience with git or similar version control system.
- Able to test and debug code independently.
- Able to design and build from a user perspective.
- Able to develop software independently based on a set of requirements.
- Able to design and build iteratively (Agile development).
- Able to work with stakeholders to define clear requirements and test cases.
- Comfortable researching unknown topics and finding solutions to programming problems independently.
- Comfortable working independently and in a team environment.
- Inquisitive nature and unafraid to ask questions.
- Growth mindset (continuous learning).
- Strong time management skills.
- Strong analytical skills.
- Comfortable with written and spoken communication skills.
- Strong organizational and note-taking skills and a propensity for accuracy is crucial.
Required Experience:
IC
Key Skills
- ArcGIS
- Intelligence Community Experience
- GIS
- Python
- Computer Networking
- Data Collection
- Intelligence Experience
- R
- Relational Databases
- Analysis Skills
- Data Management
- Application Development
About Company
Rawmat International is subsidiary of M/S Global Enterprises, which has been registered as F.Z.C company in UAE to cater for business expansion and providing better service to valued customer in Middle East. GE was established in 2004 with a humble beginning, business has grown except ... View more
