Bi Developer/Analyst Jobs

Business Intelligence Developer/Analyst

Location: Calgary, AB (Hybrid, 3 Days Onsite)

Term: Full-Time Permanent

Responsibilities

• Write SQL queries and formulate DAX calculations to facilitate data analysis, data sourcing and report development.
• Troubleshoot dashboard/report issues in a timely fashion and ensure high report/dashboard uptime.
• Partner with IT and business teams to execute data quality and cleansing exercises.
• Collaborate with the IT Infrastructure, Software Development, and other cross functional teams to accurately capture related datasets for reporting.
• Structure data models, visualize information, and publish analytical dashboards/reports.
• Adopt an Agile approach when executing projects from inception to completion
• Perform QA and coordinate solution UAT with stakeholders.
• Prepare and release report documentation to guide users through report/dashboard definitions and navigation.
• Assist BI Lead with development of reporting solutions within Power BI, and aid business teams in refining requirements.
• Adhere to IT project management standards and procedures, tracking and documenting the various tasks accordingly.
• Design, develop and deploy ETL solutions to capture data for report/dashboard ingestion.
• Accommodate evolving requirements, risks and issues while meeting targets within reasonable timelines.
• Learn the functionality, operation and business process of internal software applications as it pertains to reporting objectives.
• Gather and document requirements, problems, and opportunities for key reporting needs.

Required Skills and Experience

• ETL experience covering package development, data lineage and auditing, loop containers, dynamic SQL, parameter/variable transmission, integration services catalog. Script tasks and extraction of data using APIs would be advantageous.
• Proficiency formulating Data Analysis Expression (DAX) calculations.
• Candidates for this role must have SQL querying, data analysis and Power BI report development experience.
• Minimum 5 years of experience working with the Microsoft BI stack, particularly SQL Server Integration Services (SSIS)
• 2+ years experience in Agile methodologies and experience in project-oriented working environments.
• Familiarity with project documentation and tracking. Exposure to tools such as Team Foundation Server, DevOps and SharePoint.
• Minimum 5 years of experience as a Business Intelligence Analyst/Developer, Data Analyst or report developer.
• Minimum 5 years in SQL querying and development spanning stored procedures, functions, views, temporary tables, cursors, linked servers, SQL server agent jobs.
• 5+ years proven experience or recognized training in Power BI/ SSRS report development including data modelling. Experience in other industry standard tools will also be considered.
• Understanding of cloud-based platforms (Azure, Snowflake, others) would be an asset
• SQL Server Analysis Services (SSAS) would be advantageous.
• Demonstrated experience with data science, statistical analysis or data mining and programming languages such as R, Python, MDX would be an asset.
• Post-secondary diploma or degree in Computer Science, Management Information Systems or a related field is preferred, however, a combination of professional certifications, recognized training and/or experience will be considered.

Thank you for your interest, however only those being considered for this role will be contacted.

Akkodis will only present your resume to client’s when your explicit permission is obtained.

Akkodis maintains a general inbox for all IT candidates. If you are interested in being considered for other roles in the Calgary and/or Edmonton markets, please forward your resume to [email protected] or [email protected]

"Akkodis is one of the world's largest and most respected providers of Information Technology Resource Management (ITRM) services."