What are the responsibilities and job description for the IT System Analyst position at Light Efficient Design?
IT Systems Analyst
The Systems Analyst will be responsible for integrating, enhancing and maintaining business systems and reporting. The Systems Analyst will work with each department and Business Analysts to gather requirements, design solutions, and streamline implementation. Additionally, the Systems Analyst will be responsible for analyzing current processes and recommend opportunities for process optimization. The Systems Analyst will report to the Director of IT.
Primary Responsibilities
- Maintain existing company reporting platform, using SQL databases, Excel, Excel PowerPivot, PowerBI/Power Query, and Crystal Reports
- Simultaneously improve and consolidate company reporting platform into a consistent, easy-to navigate format
- Implement cross-departmental reports, eliminating overlap
- Assist in ERP system troubleshooting and maintenance as needed
- Maintain data integrity, interpret and analyze data, checking for data integrity and address issues when found
- Train users on leveraging reports and tools, tailoring training for both power users and novices
- Provide front-line assistance to users experiencing hardware and software troubles
- Help team members with System issues
- SQL/Power BI Training
Education
- Bachelors Degree in Computer Science or Business related field
- Minimum of 2 years experience in a similar or related role
Required Skills/Experience
- Thorough understanding of SQL language, queries, and constructs
- Strong analytical skills, ability to interpret data as it applies to the company’s needs.
- Excel, PowerBI, PowerPivot, and related Microsoft reporting tools
- Ability to establish and maintain positive working relationships with co-workers and to communicate and interact effectively with management, users and team members at all levels through both verbal and written means.
- Experience with Syspro ERP system preferred
Location
- Cary IL
Job Type
- Full time, Exempt
Benefits
- Medical, Dental, Vision, Short Term Disability, Long Term Disability, Life Insurance, Accident Advantage, Critical Care Protection, Cancer Protection, Hospital Confinement, 401k – with a 3% company contribution
Business Analyst
360 IT Professionals -
Oak Brook, IL
Principal Engineer - IT System
United Airlines -
Chicago, IL
Eagle Tech Analyst
360 IT Professionals -
Chicago, IL