Finastra Enterprise BI Developer in Mississauga, Ontario
WHY DO WE LOVE COMING TO WORK EVERY DAY?
With over 10,000 superstars across 48 different countries globally, it is hard not to be inspired every single day. At Finastra we celebrate in global knowledge sharing, diversity and an opportunity to make a difference for each other and for our customers .
We are on a journey. After bringing two global Fintech leaders together in June 2017, Finastra has truly recognized the opportunity and power we have, by combining our expertise, successes and passion together. Whether it is in a collaboration hub or innovating with colleagues across our global landscape, we are one team creating a network of talent and creativity in a stimulating environment, to do what we can to make a difference for our customers .
Our people are leaders in their role and are always looking for new ways to help our customers grow, compete and optimize their business. From a graduate Software Engineer to an experienced Sales Executive – we are looking for personal leadership and people with the appetite to understand the markets and customers we serve. We drive innovation that challenges the status quo and feel proud of the positive differences that we make every day. We recognize talent and provide a work environment where leaders can drive results , develop and grow their careers.
Success is what you do, success is what we achieve, together.
The future of Finance is open – combine your talents with Finastra opportunities to create an exciting career with us.
For more information, visit Finastra.com
How will you contribute?
Reporting to the Senior Manager, Database Management, the Enterprise BI Developer will develop, maintain and enhance business intelligence environment across the enterprise including all BI Tools, Data Stores, Data Models and Meta Data. The role requires the candidate to understand complex, large scale data models for an enterprise system and underlying business processes to provide BI Reporting solution.
Responsibilities and Deliverables:
Your responsibilities and deliverables as an Enterprise BI Developer will include, but not limited to, the following:
Work with cross-functional groups to understand reporting requirements and solution design.
Translate project requirements into functional and non-functional specifications for BI reports and applications.
Develop and implement BI solutions.
Develop, enhance and maintain reporting solutions including (but not limited to) self-service reporting environments, corporate dashboards, reporting cubes and direct database access environment for BI “power users”.
Prepare all necessary documentation that clearly describes solution and Meta data.
Monitor, tune up and administer BI Environments for quality and optimal performance purpose.
Debug, monitor and troubleshoot BI solutions.
Be aware of and comply with all corporate and department policies, procedures and standards that apply to your work area.
Working conditions are normal for an office environment but at times work may require occasional weekend and/or evening work.
Diploma in Information Systems, Computer Science or other equivalent
3+ years of report development experience in any of the following reporting tools SAP Business Objects, Cognos, SAS, SSRS.
Good to have development experience in SSAS and/or SSIS
3+ years of design, analysis, implementation experience with relational databases like SQL Server and Oracle
Must be proficient writing PL-SQL or T-SQL queries, stored procedure writing and query performance tuning
Experienced in developing BI Solutions (reports, dashboards, scorecards), Data Warehousing
Excellent understanding of data architecture, relational and multidimensional data modeling and effective aggregation of data
Strong knowledge of Data Warehousing methodologies and concepts, including but not limited to: star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools
Knowledge of Kimball and Inmon methodologies is a plus.
Knowledge of any of the following would be advantageous:
Previous experience in Financial Services management, analysis and reporting
Design and develop objects in Oracle Database
The above statements describe the general nature and level of work being performed by people assigned to this job. They are not intended to be an exhaustive list of all responsibilities, duties, and skills required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. If you need assistance or an accommodation due to disability please contact us at 800-274-7280.
The Future is Collaborative . The Future is Open. The Future is Now.
Finastra unlocks the potential of people and businesses in finance, creating a platform for open innovation. Formed in 2017 by the combination of Misys and D+H, we provide the broadest portfolio of financial services software in the world today—spanning retail banking, transaction banking, lending, and treasury and capital markets. Our solutions enable customers to deploy mission critical technology on premises or in the cloud. Our scale and geographical reach means that we can serve customers effectively, regardless of their size or geographic location—from global financial institutions, to community banks and credit unions. Through our open, secure and reliable solutions, customers are empowered to accelerate growth, optimize cost, mitigate risk and continually evolve to meet the changing needs of their customers. 48 of the world’s top 50 banks use Finastra technology.
Finastra is an Equal Opportunity Employer in the United States. Qualified applicants will be considered for employment without regard to race, color, religion, sex, national origin, age, handicap or disability (physical or mental), Vietnam-era or disabled veteran status, and other factors protected by state and local laws. For more information please read Finastra's EEO Policy Statement at http://www.dh.com/sites/default/files/eeo-policy-statement.pdf .