We are seeking a proactive and versatile Systems Analyst to join our team. This role is ideal for a junior-to-mid-level professional who is eager to work across the full spectrum of data integration. You will play a pivotal role in maintaining our existing, mission-critical legacy integrations while simultaneously contributing to our strategic migration toward modern cloud analytics platforms like Microsoft Fabric. The successful candidate will be a bridge builder, ensuring data integrity across complex environments while helping us design and deploy new, agile solutions that support our growing business needs.
Duties and Responsibilities:
- Integration Maintenance & Support: Monitor, troubleshoot, and optimize existing data integration workflows, including those connecting IBM iSeries/DB2 systems with modern SQL Server environments.
- Cloud Transformation: Assist in the architectural transition from legacy EDI and data platforms to event-driven, cloud-native integration solutions.
- Analytics Enablement: Support the migration of data reporting workflows from legacy Power BI Dataflow Gen1 to Gen2 and the Microsoft Fabric ecosystem.
- Development & Automation: Develop and maintain automation scripts (PowerShell, Python) to streamline system administration, data movement, and cloud resource management.
- Collaboration: Partner with senior team members to design robust, scalable interfaces that ensure high availability and data consistency between staging and production environments.
- Documentation: Maintain clear documentation of integration logic, system configurations, and standard operating procedures to ensure team-wide knowledge share.
Requirements, Education and Experience:
- Database Proficiency: Strong working knowledge of SQL (specifically MSSQL). Experience writing complex queries, triggers, and stored procedures.
- Scripting & Automation: Proven ability to automate tasks and manage infrastructure components using Python and PowerShell.
- Integration Experience: Familiarity with ETL processes, data synchronization strategies, and general integration patterns.
- Data Analytics Tools: Experience with Power BI and Power Query; familiarity with data modeling or cloud data platforms is a significant plus.
- Problem-Solving: Ability to debug and resolve complex connection issues between legacy and modern systems.
- Adaptability: A strong desire to work in a hybrid environment, balancing the stability requirements of legacy systems with the agility of modern cloud services.
Education and Experience:
- Education: Bachelor's degree in Computer Science, Information Systems, or a related technical field (or equivalent professional experience).
- Experience: 2-4 years of experience in a systems analysis, data integration, or backend support role.
Working Conditions:
General business office environment with open work areas.
Other Information:
The statements herein are intended to describe the general nature and level of work being performed by employees, and are not to be construed, as an exhaustive list of responsibilities, duties and skills required of personnel so classified. Furthermore, they do not establish a contract for employment and are subject to change at the discretion of the employer.