Business Intelligence Developer Jobs

Our reputable client in the defense sector is seeking skilled a BI DEVELOPER to join their team on a permanent basis. This role would be hybrid (1 day a week in office) in Ottawa. The successful candidate would require to be eligible for Secret Security Clearance and meet the following requirements.

Roles and Responsibilities

• Model various complex data sources using the Kimball methodology.
• Other duties as directed.
• Capture specified document user requirements, gathering report objectives, required data and specifications.
• Where applicable, develop the reports within the existing Data Warehouse and ERP.
• Responsible for the development and maintenance of management reports and/or developing the views those reports are based on using Crystal Reports, SSRS, Power BI and QlikView reporting applications.
• Carry out data validation with the Applications Manager to ensure reports are pulling all correct data accurately and achieving customer needs.
• Work with the business to ensure appropriate governance is applied and adhered to in accordance with IT best practices.
• Extract data and run reports from an existing library and create new reports/ modify existing reports as appropriate.
• Develop and maintain the organization’s Data Warehouse. Includes but not limited to SSMS, SSAS and SSIS solutions.
• Provides analytical and technical support for complex requests, projects, or initiatives.
• Develop reports and extract from multiple data sources.
• Provide data as a service to end users via the Data Warehouse.

Qualifications and Skills

• 4+ years of relevant experience including experience with data repository design and maintenance and database administration and complex reporting analysis.
• Eligible for a Canadian Secret Security and ITAR Clearance.
• Minimum of 3 years’ experience of working with Windows Server technologies.
• Experience working in a large-scale organization with ERP systems.
• Thorough understanding of the Kimball data modelling methodology.
• Minimum of 3 years’ experience of Data Warehouse technology - SSMS, SSIS, SSAS.
• Minimum of 3 years of working in report writing using SQL, Crystal XI, Power BI, SSRS, Business Intelligence or other reporting tools. QlikView experience preferable.

If this role aligns with your expertise and interest, we invite you to apply today!

https://portal.altis.com/jobad?b=altistechnology&jobid=10540-BI-Developer