Job Description:

• • Translate business needs to technical specifications
  • Design, build and deploy BI solutions (e.g. reporting tools)
  • Maintain and support data analytics platforms (e.g. MicroStrategy)
  • Create tools to store data (e.g. OLAP cubes)
  • Conduct unit testing and troubleshooting
  • Evaluate and improve existing BI systems.
  • Collaborate with teams to integrate systems
  • Develop and execute database queries and conduct analyses
  • Create visualizations and reports for requested projects
  • Develop and update technical documentation
  • Supports deployment and training activities for developed solutions
  • Support sustainment efforts, with a focus on the scoping of BI solution sessions with business lines to capture business objectives and prioritize opportunities.
  • This position will play a primary role in the sustainment of the existing Power BI solutions under the management of the DOS EAM Department, with a focus on availability and maintenance as needs arise.
  • Under the direction of the Report Development Lead, extract transform and load data, using SQL.
  • Support the scoping of BI solution sessions with business lines to capture business objectives and prioritize opportunities.
  • Create mock−up reports for proof−of−concept reviews.
  • Support and develop activities related to end−to−end data lifecycle management, including the review of data loads for accuracy and completeness.
  • Support Business lead in developing system reporting solutions based on business needs.
  • Support Business lead in creating, validating, executing and documenting test cases
  • Assist in the development of end−user training and reference materials
  • Perform or assist in end−user training
  • Assist in implementation go−live and post−go−live activities
  • Support requests from users to research system problems or errors, and to assist in their resolution

Requirements:

• • Proven experience as a BI Developer or Data Scientist.Industry experience is preferred
  • Background in data warehouse design (e.g. dimensional modeling) and data mining
  • In−depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework.
  • Familiarity with BI technologies (e.g. Microsoft Power BI, Oracle BI)
  • Knowledge of SQL queries, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS).
  • Proven abilities to take initiative and be innovative. Analytical mind with a problem−solving aptitude
  • BSc/BA in Computer Science, Engineering or relevant field.
  • Experience developing and implementing Power BI solutions, including modelling, design, development and testing of data visualization or paginated report solutions

 

• • Proficiency in Data Analysis (DAX), M, ETL (Power Query), SQL (or data extraction and integration tools) and performance optimization
  • Strong ability to work on multiple initiatives simultaneously and work within tight deadlines
  • Microsoft Power BI certifications or Azure certifications are an asset
  • Experience working in an Agile project delivery model is an asset
  • Understanding of complex relational database organization, design, and functionality.
  • Ability to communicate clearly in conversation and in presentations to both technical and non−technical staff and to provide updates to all levels of management and stakeholders
  • Ability to effectively prioritize and execute in a high−pressure environment
  • Ability to independently set priorities and meet deadlines in a fast−paced environment, a self−starter Excellent inter−personal skills including the ability to work with individuals at all levels of the organization