Technical Business Systems Analyst (BSA) – ODH

Serverless Guru LLC.; Caledon; On-site; CAD 85,000 - 120,000; Full time

Job summary

A leading company is seeking a highly skilled Technical Business Systems Analyst to enhance API and data integration processes. The role involves collaboration with technical teams to optimize solutions, ensuring seamless integration across enterprise systems. The ideal candidate will have robust experience in API design, data interfaces, and possess strong analytical skills.

Benefits

Opportunity to work on cutting-edge API and data integration projects.

Collaborative and innovative work environment.

Qualifications

• 5+ years of experience as a BSA or similar role focused on APIs.
• Bachelor’s degree in Computer Science or a related field is required.
• Strong knowledge of RESTful APIs, JSON, XML, and SQL for data validation.

Responsibilities

• Collaborate with stakeholders to gather and analyze requirements.
• Define RESTful and SOAP API specifications for integration projects.
• Assist in the implementation of API-based integrations and validate data transformations.

Skills

RESTful APIs

SOAP APIs

JSON

XML

OAuth/OpenID

SQL

Data integration technologies

ETL

Mulesoft

AWS services

Microservices architecture

Analytical skills

Communication

Problem-solving

Agile methodologies

Education

Bachelor’s degree in Computer Science or Information Systems

Tools

API management tools

JIRA

Confluence

Data pipelines

Job description

Job Summary

We are seeking a highly skilled Technical Business Systems Analyst (BSA) with expertise in data interfaces, API integrations, and system analysis. The ideal candidate will work closely with business and technical teams to define, design, and optimize data-driven solutions, ensuring seamless integration across various enterprise systems.

Key Responsibilities

Requirements Gathering & Analysis

• Collaborate with stakeholders to understand business needs and translate them into technical requirements.

• Document API and data interface specifications, including authentication methods, payload structures, and response handling.

API & Data Interface Design

• Define and validate RESTful and SOAP API specifications, ensuring alignment with business processes.

• Work with developers to ensure APIs meet security, performance, and scalability standards.

• Design and document data flow diagrams, data mapping, and transformation rules.

System Integration & Implementation

• Assist in the implementation of API-based integrations between internal and third-party systems.

• Validate data transformations and ETL processes for accuracy and efficiency.

• Support middleware and API gateway configurations where necessary.

Testing & Quality Assurance

• Develop and execute test plans, including API testing using Postman or SoapUI, and perform data validation.

• Troubleshoot and resolve API-related issues by working closely with developers and system architects.

Documentation & Compliance

• Maintain comprehensive technical documentation, including API catalogs, data dictionaries, and system diagrams.

• Ensure compliance with data governance, security policies, and regulatory standards.

Required Skills & Qualifications

Education & Experience

• Bachelor’s degree in Computer Science, Information Systems, or a related field.

• 5+ years of experience as a BSA, Systems Analyst, or a similar role with a focus on APIs and data interfaces.

Technical Skills

• Strong knowledge of RESTful and SOAP APIs, JSON, XML, and OAuth/OpenID authentication.

• Experience with API management tools (e.g., Mulesoft, AWS API Gateway).

• Familiarity with data integration technologies (ETL, data pipelines, middleware solutions).

• Proficiency in SQL for data analysis and validation.

• Experience with recommending appropriate AWS services and microservices.

• Experience with Serverless and microservices architectures on AWS.

• Experience with Multi-tier application design in AWS environments.

• Experience with AWS architectural patterns and reference architectures.

• Experience with querying and working with relational databases, particularly MySQL, for data analysis and validation.

Soft Skills

• Strong analytical and problem-solving skills.

• Excellent communication and documentation skills.

• Ability to work independently and as part of a cross-functional team.

Preferred Qualifications

• Experience with cloud-based integrations (AWS is required; Azure and Google Cloud are a plus).

• Familiarity with Agile methodologies and tools (e.g., JIRA, Confluence).

• Understanding of microservices architecture and event-driven systems.

Why Join Us?

• Opportunity to work on cutting-edge API and data integration projects.

• Collaborative and innovative work environment.