IT Business Systems Analyst

We are seeking an IT Business Systems Analyst to join our team based in Kings Park, New York. In this role, you will focus on data analysis, system integration, process improvement, and data governance in the transport industry. This role offers an exciting opportunity for those proficient in Microsoft Power BI, Microsoft SSRS, Microsoft SQL Server, and Microsoft Azure.

Responsibilities:

• Develop and optimize SQL queries and stored procedures to facilitate reporting and data analysis.
• Design and manage reports using SQL Server Reporting Services (SSRS) for accurate business insights.
• Create interactive dashboards and visualizations in Power BI to support data-driven decision-making.
• Lead ERP migration projects, ensuring seamless data integration and maintaining data consistency across systems.
• Analyze existing business processes, identifying areas for improvement and automation.
• Collaborate with cross-functional teams to gather data requirements and perform data validation during migration projects.
• Maintain high data quality standards through regular audits, validations, and continuous monitoring.
• Document data flows, technical specifications, and reporting requirements for stakeholders.
• Implement data governance practices to ensure data accuracy, accessibility, and compliance with security protocols.
• Troubleshoot data inconsistencies and system issues, providing prompt resolution to stakeholders. • Possess a minimum of 3 years of experience in a similar role within the Transport industry
• Demonstrated proficiency in Microsoft Power BI, Microsoft SSRS, Microsoft SQL Server, and Microsoft Azure
• Strong understanding of IT business systems analysis principles
• Excellent problem-solving skills and ability to think critically
• Ability to communicate complex technical information clearly to non-technical stakeholders
• Proven experience in managing multiple projects simultaneously
• Exceptional attention to detail and accuracy
• Proven ability to work effectively both independently and in a team-based environment
• Strong written and verbal communication skills
• Bachelor's degree in Computer Science, Information Technology, or a related field is preferred.