What are the responsibilities and job description for the Data Analyst II position at Artech Infosystem Private Limited?
Job Title: Data Analyst II
Job location: North Chicago, IL
Job Duration: 12 Months (Possible Extension)
Responsibilities
Job Summary:
The Operations Manager with Advanced Excel Skills will be responsible for developing sophisticated reports and dashboards using Excel. The ideal candidate will have extensive experience in operations management and demonstrate expertise in excel and various visualization and dashboard tools.
Key Responsibilities:
• Create a mechanism for a comprehensive invoice logging system to track incoming invoices and pending payments, facilitating the determination of year-end accruals
• Develop a framework for advanced budget tracking systems to effectively monitor and manage expenses including reconciliation of data from financial reports monthly
• Create sophisticated reports, dashboards, and data visualizations for leadership budget update and various planning cycles
• Create a template for meeting minutes for a Charitable Donations Review Committee that provides a summary of decisions made and records action items
• Conduct a thorough review of the monthly donations report provided by Finance to identify any inaccuracies or discrepancies, ensuring compliance execution of transactions for the organization
• Provide support during Foundation audit ensuring all required documentation is readily available. Assist in gathering and organizing financial data and records for audit purposes
• Collaborate with CRGP SMEs to reconcile data for various reporting requirements
• Assist with administrative tasks for updates to various policies and procedures across Corporate Affairs
• Ad Hoc project requests as needed
* Create process documents for work being done; talking with individuals who perform the processes and creating an SOP; process document.
Requirements:
• Bachelor's degree in business, operations management, or a related field
• 3-5 years of experience in operations management, data analysis, or a similar role
• Expert-level proficiency in Excel, including advanced formulas, pivot tables, and macros and data visualization techniques
• Strong analytical and problem-solving skills
• Excellent communication and interpersonal skills
• Ability to manage multiple tasks simultaneously
• Knowledge of operations management methodologies and tools
• Experience with data analysis software and tools (e.g., SQL, Tableau, Power BI) is a plus
Job description for following responsibilities:
- Respond to and triage various inquiries from external organizations for CRGP function
- Logging of invoices to track what has come in and what’s pending to help determine accruals at year-end
- Budget trackers sophistication
- Analytical support for donations report for review committee
- Foundation audit support
- Reconciliation of data with SMEs for various reporting
- Reporting sophistication for leadership budget reports