BI Programmer Analyst
Empire Communities
Vaughan, ON
Position Overview:
The Business Intelligence (BI) Programmer Analyst will contribute to the design, development and maintenance of management-level metrics, reports and dashboards for IS&C Security Analytics.

The Business Intelligence (BI) Programmer Analyst will support the continual development of an enterprise-wide BI function, including building out the architecture, tools, and processes to report on business performance. The ideal candidate will have demonstrated experience in writing code to deliver high-quality reports in a complex environment. It will also be vital for the candidate to bridge the technical world of data warehousing with the needs of the business by acting as an internal consultant to help answer challenging questions using their data expertise and technical know-how.

This role will report to the VP, IT and will responsible for developing data based solutions in accordance with organizational priorities.

Key Functions & Duties:
Responsibilities of this position include, but are not limited to:

Design, build and deploy integrated BI solutions (Dashboards, Standard Reports, ADHOC Self Service, Scorecards) using industry BI Tools.
Analyze and migrate existing reporting tools into the new BI tools (SSRS, Excel, etc.)
Provide support to end users
Analyzing business needs and determining appropriate data, report design, and processes to deliver relevant BI solutions that leverage best practices
Work with Business SME and Business/Systems Analysts to define reporting requirements and goals and to identify the data needed for meeting business requirements
Follows change and version control in moving code from development to test/QA and to production environments
Researches, analyzes, recommends, and implements new methods, standard processes, best practices, and techniques for developing BI Solutions
Ensure proper registration of devices and licensing compliance
Ensure all system problems and requests are logged and tracked in accordance with problem management procedures.
Recommend improvements for BI Dashboard and ETL design processes, data quality and testing
Define and direct the implementation of security requirements for the data warehouse or source systems
ETL design and process guidelines including data quality and testing
Data Design, Data Modelling

Skills and Qualifications

Education & Certification:
A post-secondary degree or diploma in computer science or equivalent.

Knowledge & Experience

Extensive and demonstrated experience leading successful enterprise data warehousing implementations in designing and developing the architecture for all data warehouse components (e.g. tool integration strategy; source system data ETL strategy, data staging, movement and aggregation; information and analytics delivery; and data quality strategy).
Hands-on experience in data architecture, data mining, data modeling, metadata management, and platform migration.
Development experience with ASP.NET framework using C# and VB.NET. Experience with HTML, CSS and Javascript is preferred.
Minimum of 3 years of experience in data development creating data marts, data warehouses, and performing data engineering;
Experience with Qlikview, Qliksense and Microsoft Power BI
Ability to connect and query data from Microsoft SQL, Progress OpenEdge, oData, webservices, Microsoft Office, Sharepoint, Microsoft Analysis Services, etc.
Experience with building/implementing databases, analysis services (tabular and multidimensional models, star/snowflake schema), data warehouse architecture
Data analysis
Performance Monitoring

Personal Attributes

Present ideas in business-friendly and user-friendly language.
Very strong customer service orientation.
Excellent written, oral, interpersonal, and presentational skills.
Experience working in a team-oriented, collaborative environment.

Work Conditions

Able to travel between Canada and US
Occasional travel between training locations required.
Sitting for extended periods.
Dexterity of hands and fingers to operate a computer keyboard, mouse and to handle other computer components.
Lifting and transporting of moderately heavy objects, such as computers and peripherals