Open Systems Technologies
SQL Data Analyst/Reporting Analyst
Open Systems TechnologiesCanada1 day ago
ContractEngineering

Responsibilities and Duties:

• Develop and maintain Dashboards and Visualisations in PowerBI from SQL source

• Develop and maintain OLAP Cubes, Excel reports from SQL using Excel Power Query and Power Pivot (inc DAX)

• Develop ETLs using API’s, SSIS and Python

• Collaborate with cross-functional teams to meet project deadlines.


Technology Knowledge

• SQL DB architectures and creating complex SQL queries especially in the Microsoft ecosystem (T-SQL)

• Data Warehousing

• OLAP Reporting Services, creating and maintaining OLAP Cubes

• Python

• Powershell

• Splunk (preferable)


Product knowledge:

• Microsoft SQL Server and Admin Studio

• Microsoft PowerBI

• Microsoft Excel Power Query and Power Pivot (inc DAX)

• Salesforce Tableau would be beneficial


Qualifications:

• Bachelor's degree in Computer Science, Information Technology, or related field.

• Proven experience as a SQL Developer or similar role.

• Strong analytical and problem-solving skills.

• Excellent communication and teamwork abilities.

Key Skills

Ranked by relevance