Business Systems Analyst

Position overview

Required experience and qualifications

• Must know SQL and have excellent oral and written communication skills.
• Five years creating source-to-target documentation and serving as a business-technical liaison for data integration.
• Five years developing complex SQL.
• Five years gathering requirements and developing user stories.
• Five years translating business requirements into technical specifications.
• Five years conducting systems root cause analysis and analyzing complex datasets for patterns, trends, and insights.
• Two years planning and executing testing, reconciling results, conducting UAT, and collaborating to resolve defects.
• Strong analytical, problem-solving, and critical-thinking skills.

Responsibilities

• Liaise between business and technical staff to design and implement data integration processes.
• Create and maintain source-to-target documentation.
• Develop complex SQL and gather requirements into user stories.
• Translate business needs into technical specifications.
• Conduct root cause and complex data analysis.
• Plan and execute system testing, reconcile results, and conduct user acceptance testing.
• Work with stakeholders to resolve issues and defects.

Client technologies

• Listed client technologies include Jira, SharePoint, Teams, Alteryx, SSIS, SSRS, SSMS, Squirrel, SQL Server, Tableau, Semarchy, Git, and GitHub.

Preferred skills and experience

• Preferred: gap analysis, cost-benefit analysis, user mentoring and training, data quality tools and frameworks, business intelligence platforms, and data governance including security and privacy policies.
• Preferred: dashboard requirements, data modeling, comprehensive systems documentation, user manuals, end-user training, managing concurrent projects, and interpersonal collaboration skills.