Senior Business Intelligence Analyst

HYBRID Position ESSENTIAL DUTIES: The position's essential duties include the following:

• Serve as technical team lead in the development of business intelligence reports and analysis, providing mentoring, guidance and troubleshooting to analysis team members in solving complex reporting and analytical problems
• Manage reporting environment including report data sources, security, subscriptions and metadata
• Assist in initiative towards data normalization and data integrity across the enterprise
• Assist Data Warehouse Engineer in identifying and revising enterprise reporting requirements
• Evaluate, test and implement new or upgraded software
• Troubleshoot reported problems pertaining to reports and the reporting database environment, working closely with other IT members, especially DBAs, Systems Analysts and Systems Engineers, identifying the cause and designing or developing an approach for resolution
• Assess impact of changes and updates to source production systems, planning and implementing resulting changes to reports
• Conduct end user training on reporting system

• Knowledge of Relational Databases 12 years
• Knowledge of Columnar Databases or columnar storage 5 years
• SQL Programming 12 years
• Microsoft SQL Server 2005 or above 8 years
• SQL Server Management Studio 4 years
• SQL Server Integration Services 4 years
• SQL Server Analysis Services 2 years
• Pentaho BI Suite 5 years
• PDI ETL 5 years
• Pentaho Analytics/Reporting 5 years
• Microsoft Excel 4 years
• Microsoft Access 1 year
• Microsoft Visio 2 years
• Data Modelling 4 years
• Data Warehousing 5 years

• Microsoft SQL Server 2018/2020
• HP Vertica
• Amazon Redshift
• Pentaho BI Suite