About Job

CTC Undisclosed Job Location Canada Experience 7 - 10 yrs

Description

The People - From our humble origins in our founders basement, to our industry leading position today, SOTI has worked hard to foster a company culture that we can all believe in. A culture that emphasizes personal growth, continuous innovation and fun.

The Growth - Our environment fosters new ideas, fresh perspectives, and the ability to take them over the goal line. SOTI is a fast-paced environment with a global reach that encourages you to make your mark and be part of something big!

The Technology - Youll get the chance to work with leading edge technologies and take on complex and interesting projects, as part of highly collaborative and agile teams. You will work alongside SOTIs partners which include leading tech giants that will keep you on the cusp of emerging technologies.

What Youll Do

Ability to translate and document business requirements into technical documentation, supporting document management and knowledge sharing

Ensure assigned deliverables are within business / audit control requirements

Take ownership of end to end design and all aspects related to development and ensure design and development standards and followed

Create project documentation (Detailed design, Source-to-target mappings, Implementation plans, etc.)

Develop data and database-oriented solutions in order to solve complex business problems leading to data driven decision making

Develop data integration processes to integrate disparate data sets into a cohesive data model in support of BI and analytical requirements

Works closely with data architecture to ensure proper adherence to architectural guidelines and principles

Experience Youll Bring:

7 years of hands-on advanced experience designing and developing BI Solutions and providing technical expertise

7 years hands-on advanced experience using MS SQL

7 years of experience with MS SQL Business Intelligence Stack (SSAS, SSIS, and SSRS)

5 years hands-on advanced experience using Power BI or similar BI platforms

Experience using Cloud architecture, NoSQL databases and R/Python

Experience using building data pipelines to integrate with unstructured data sources

Experience in designing and building unstructured data stores using Azure or AWS technologies

Experience with Data Warehouse concepts, including the use of Extract, Transform, and Load (ETL) tools

Excellent analytical, troubleshooting, problem-solving and research skills

Must be able to multitask and have experience with interacting within a diverse user/customer base

Excellent written, verbal, and interpersonal communication skills