Linkedprime
Open Systems Technologies

SQL Data Analyst/Reporting Analyst

Posted: 3 days ago

Job Description

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 beneficialQualifications:• 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.

Job Application Tips

  • Tailor your resume to highlight relevant experience for this position
  • Write a compelling cover letter that addresses the specific requirements
  • Research the company culture and values before applying
  • Prepare examples of your work that demonstrate your skills
  • Follow up on your application after a reasonable time period

You May Also Be Interested In