Senior Data Analyst

Duration: 6 Months (Possible Extension)
Location: Remote (Physically present in Canada + EST Time Zone)
Enhanced Reliability Clearance Required

We are seeking a Data Analyst for one of our direct client. The Data Analyst will serve as a member of a team that is responsible for the design, development, implementation, and support of the company's data store ( including data warehouse, data lake, Power BI reporting platform) and various other data assets across the company.

Roles and Responsibilities
• Work with business stakeholders to understand business processes and data flows, document requirements, analyse and design the data models, and reporting solutions.
• Define, create, and maintain SharePoint lists, Power BI Certified Data Sets.
• Write SQL queries and reports to extract and manipulate data from multiple relational databases.
• Create reports and dashboards including data visualizations in Power BI.
• Perform discovery and profiling of new or undocumented data sources.
• Integrate disparate data sources into unified Power BI models.
• Develop data transformations using SharePoint data and Power BI.
• Meet deadlines for individual and team projects.
• Maintain technical documentation and source control related to project design and implementation.
• Respond quickly to resolve application issues.
• Other duties to support a collaborative approach to managing IT responsibilities as required

Skills Required
• Bachelor’s degree in computer science, Information Science, or equivalent relevant experience
• 5+ years' experience developing reports, dashboards, visualizations in one or more BI tools
• 3+ years Power BI development experience
• Highly proficient with SQL coding; experience using advanced concepts
• Highly proficient with SharePoint and Power BI report and dashboard creation, data modeling/integration, visualizations
• Familiarity with dimensional data modeling and data warehousing concepts
• Experience in using Azure SQL.
• Understanding of Agile application development methodologies; Azure DevOps a plus
• Data Analyst: 5 years (Required)
• Data warehouse: 3 years (Required)
• Data lake: 3 years (Required)
• Developing reports, dashboards, visualizations in BI tools: 5 years (Required)
• SQL coding: 3 years (Required)
• Data modeling/integration: 3 years (Required)
• Dimensional data modeling: 2 years (Required)
• Azure SQL: 2 years (Required)
• Agile application development methodologies: 1 years (Preferred)
• Azure DevOps: 1 year (Preferred)
• Power BI reporting, Development: 3 years (Required)
• Excellent verbal and written skills
• Self-direct to complete assignments within a specified timeline
• Team-focused

We thank you for visiting the job page. Only candidates closely matching the requirement will be contacted for interview. Wishing you all the best in your job search.

Email your resume to info@oggninc.com