Data Systems Analyst
About The Position
The Data Systems Analyst is responsible for developing, maintaining, and optimizing SQL scripts, stored procedures, and database queries. This role supports SQL Server and IBM AS/400 databases, designs and maintains data import/export/validation processes, and creates ad hoc reports and data extracts. The analyst will also develop and support system integrations, automate business processes, and troubleshoot data synchronization issues. Key responsibilities include coordinating software installations and upgrades, analyzing business requirements, investigating application issues, collaborating with vendors and internal departments, participating in testing, and creating technical documentation. Additionally, the role involves providing end-user support and training, maintaining system documentation, and ensuring compliance with company policies for data protection, security, and change management.
Requirements
- Five or more years of experience supporting enterprise business systems.
- Five or more years of experience writing SQL scripts and queries.
- Experience working with Microsoft SQL Server and/or IBM AS/400 (DB2) databases.
- Strong analytical and troubleshooting skills.
- Experience importing, exporting, and validating large datasets.
- Excellent written and verbal communication skills.
- Ability to manage multiple priorities while working independently and as part of a team.
Nice To Haves
- Experience with dealership management systems such as IntelliDealer, CDK Drive, Procede Excede, Softbase, or similar DMS platforms.
- Experience in the commercial vehicle, construction equipment, agricultural equipment, or equipment rental industries.
- Experience with SSIS, Informatica, ETL processes, REST APIs, XML/JSON, or systems integration.
- Familiarity with reporting tools like PowerBI, Tableau, and Microsoft Excel.
- Bachelor's degree in Computer Information Systems, Computer Science, Information Technology, or a related field.
- Relevant SQL Server, database, or Microsoft certifications.
Responsibilities
- Develop, maintain, and optimize SQL scripts, stored procedures, and database queries.
- Support SQL Server and IBM AS/400 databases used by the company's business applications.
- Design and maintain processes for importing, exporting, and validating large volumes of business data.
- Create and maintain ad hoc reports and data extracts to support business operations.
- Develop and support integrations between internal systems and third-party applications.
- Automate recurring business processes using database tools, scripting, and integration technologies.
- Troubleshoot data synchronization and integration issues.
- Coordinate software installations, upgrades, testing, and ongoing system maintenance.
- Analyze business requirements and translate them into technical solutions.
- Investigate application issues, identify root causes, and implement corrective actions.
- Collaborate with software vendors and internal departments to resolve technical issues.
- Participate in testing of new functionality, upgrades, and system enhancements.
- Create technical documentation, user guides, and implementation procedures.
- Provide technical support and training to end users as needed.
- Maintain documentation for system configurations and business processes.
- Ensure business systems comply with company policies for protecting employee and customer information.
- Follow established security and change management procedures.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
