SAP Business Warehouse Solution Architect

E-Talent Network; Regina; On-site; CAD 80,000 - 120,000; Full time

Job summary

A leading company in analytics solutions is seeking a Senior Analytics Developer to work closely with data analysts and team leads in Regina. The role involves building and deploying analytics solutions, managing data services, and requires a strong background in SAP and Azure technologies. Ideal candidates will possess a University Degree and have experience in data modeling and transformation.

Qualifications

• Experience with SAP Business Warehouse and data extraction from SAP modules.
• University Degree in relevant field is mandatory.
• Experience with Azure technologies is a plus.

Responsibilities

• Build and deploy analytics solutions using chosen technology.
• Extract, transform, and load data into visualization layers.
• Design and manage large-scale data services.

Skills

Data modeling

Data transformation

Data acquisition

Problem resolution

Collaboration

Education

University Degree in Administration, Computer Science, System Analysis, or related field

Tools

SAP Business Warehouse

Power BI

Azure Data Lake Storage

Azure Databricks

Azure Data Factory

Job description

Availability to work on site in Regina, Saskatchewan office considered an asset.

After hours support of technology releases may be required.

Position and / or Project Description :

The Analytics Developer works closely with data analysts & team leads to build and deploy analytics solutions utilizing the chosen technology. The developer is responsible for extracting data from source systems, transforming it to be fit for purpose, and loading the data model into the visualization layer. The role requires experience in designing, deploying, and managing large-scale data services.

Seniority :

Senior

Mandatory Education / Certifications :

University Degree in Administration, Computer Science, System Analysis, or related field.

Mandatory Experience :

SAP Analytics Solution Architect (1)

• Experience developing and supporting SAP Business Warehouse (version 7.5), extracting data from SAP modules (MM, FI, PS, SuccessFactors, CRM), modeling data, and supporting reporting into Business Objects (4.3), Power BI direct query, HANA DB, and Azure Data Lake Storage.
• Creating and maintaining development standards across the SAP analytics platform, planning upgrade paths, and aligning product roadmaps with future business capabilities. Advising on project designs, integration, and data modeling. Ensuring data models are reusable and accessible for developers and citizen developers.

Desired Experience :

Experience with Azure Databricks, Azure Data Factory, Event Hub, Azure Synapse, Azure DevOps is considered an asset.

• Designing, automating, and managing high-volume data acquisition, transformation, and loading processes.
• Managing data pipelines and repositories, troubleshooting failures.
• Architecting and implementing advanced data analytics architectures.
• Providing production support and immediate problem resolution.
• Analyzing customer and support team information needs to determine technical solutions.
• Collaborating with business and technical partners to understand data requirements.
• Working with the Solution Architect to define data storage and transformation architectures.
• Mentoring staff in service delivery and problem resolution.
• Performing unit testing and documenting technical specifications.
• Incorporating security requirements into designs.
• Implementing data storage and retention policies.
• Delivering solutions using agile methodologies and participating in daily stand-ups.

Additional Questions:

Please confirm the following:

• Does the proposed resource have working status within Canada?
• Is the resource available to work overtime?
• If not, what date can the resource start?
• How much notice is required to meet the start date?