- Developing SQL queries / ETL packages using T-SQL and SSIS to ingest data from source systems to integrate with SQL Server data warehouse.
- Design and develop physical data model structures in SQL Server
- Design and development of high-quality dashboards / reports using tools like Power BI, SSRS, Crystal Report, Excel/PowerPivot, and Tableau. Develop custom reports, analytics and KPI's for the Business
- Builds and maintain proper documentation, data lineage and extract-transform-load (ETL) processes.
- Collecting business requirements / user stories while working in a lab with a product owner, Business Analyst, Scrum Master, and application developers.
- Developing SQL views to enable data consumers to read data from data warehouse.
- Documenting databases, data process flows and maintain data dictionaries, support and onboarding procedures.
- Troubleshoot and resolve database and application defects in a timely manner with consultation with internal and external groups as needed.
- Train and assist users at all levels.
- Analyze root causes of operational malfunctions including but not limited to batch jobs and provide resolutions.
- Analyze highly complex business requirements; generate technical specifications to design or redesign complex software components and applications.
- Act as an expert technical resource in Data Warehouse/DBs and ETL
- Leverage industry best practices to design, test, implement and support a solution.
- Assure quality, security and compliance requirements are met for supported area.
- Be flexible and thrive in an evolving environment.
- Adapt to change quickly and adjust work accordingly in a positive manner.
- On-call responsibilities to operate as the L2 point of contact for monitoring TIDAL/EDL jobs requests may be required for weekends rotation.
- 3-5 years previous experience working within a technically focused environment as a database analyst / data developer.
- Experience with databases such as Microsoft BI stack SQL Server, T-SQL, SSRS, MS SQL Enterprise Manager, MySQL, Crystal Report, Tidal jobs etc.
- Experience working in an agile development team engaged in the SDLC process and SDLC methodologies (agile / waterfall).
- Experience with EDL / Hadoop / Hive / Tableau a plus. Hands-on programming experience and advanced knowledge of SQL.
- Expertise with data visualization / BI tools like e.g., Power BI.
- Clear communication and interpersonal skills required.
- Familiarity with JIRA/SharePoint
- Attention to detail and feedback from clients on dashboards and reports must be completed rapidly.
- Experience developing code to consume REST API services and integrating systems with sftp a plus.
- Experience with MS Azure / SQL Server MI / Machine Learning services a plus.
- Experience with databases, dimensional data modeling design.
- Experience with data warehouse, ETL, SSIS, SSAS/cubes a must.
- Experience with implementing DevOps / CIAD a plus.
- Experience with web development (in ASP.NET MVC / C#) a plus.
- Database: SQL Server / MS SQL Enterprise Manager / Oracle
- Platform: Microsoft.NET, IIS, SharePoint Online / Azure
- Development Environment: Visual Studio / SSMS
- Languages: T-SQL, C#, .NET, Python
- Source Control: MS Team Foundation Server / Git / Bitbucket / TFS
- Reporting: MS SQL Server Reporting Services, Crystal Reports, SSRS
- Data Visualizations: MS PowerBI / Tableau / Excel
- Diversity, Equity, Inclusion & Allyship - We strive to create an inclusive culture where every employee is empowered to reach their fullest potential, respected for who they are, and are embraced through bias-free practices and inclusive values across Scotiabank. We embrace diversity and provide opportunities for all employee to learn, grow & participate through our various Employee Resource Groups (ERGs) that span across diverse gender identities, ethnicity, race, age, ability & veterans.
- Accessibility and Workplace Accommodations - We value the unique skills and experiences each individual brings to the Bank, and are committed to creating and maintaining an inclusive and accessible environment for everyone. Scotiabank continues to locate, remove and prevent barriers so that we can build a diverse and inclusive environment while meeting accessibility requirements.
- Upskilling through online courses, cross-functional development opportunities, and tuition assistance.
- Competitive Rewards program including bonus, flexible vacation, personal, sick days and benefits will start on day one.
- Community Engagement - no matter where you choose to work from; we offer opportunities for community engagement & belonging with our various programs such as hackathons, contests, cooking with friends, Humans of Digital and much more
-
Data Developer
2 weeks ago
Scotiabank Toronto, CanadaRequisition ID: 199915 · Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture. · The Team · Automotive Finance IT support team is responsible for supporting the technology solutions implementations to drive the bank's automotive bu ...
-
Data Developer
3 weeks ago
Zonda Toronto, ON, CanadaBabylonJS Developer Remote (Quebec, Canada) | Full Time · At Zonda Home Canada, we're not just envisioning the future of housing – we're crafting it As the brains behind Livabl and strategically situated in the bustling hub of the real estate world, we're not just following the ...
-
Data Developer
3 weeks ago
CB Canada Toronto, CanadaRef ID: · Classification: Database Developer · Compensation: DOE · Are relational databases in your realm of expertise? Does designing, building and developing database architecture excite you? You'll be interested in Robert Half's new opening for a Database Developer, if you h ...
-
IT Data Developer
2 weeks ago
Epsilon Solutions Ltd. Toronto, ON, CanadaJob Title: Snowflake DeveloperTerm: Long Term ContractWork Location: Toronto, Ontario, Canada Job Description:Design and implement Snowflake solutions based on project requirements.Develop and optimize queries for data transformation and loading processes.Implement stored procedu ...
-
Data Developer
2 days ago
Canada Mortgage and Housing Corporation Toronto, ON, CanadaPress Tab to Move to Skip to Content Link Select how often (in days) to receive an alert: · Language Skill Levels (Read/Write/Speak): ZZZ · We lean in with courage, band together as a community and try new things to make a lasting impact on housing from coast to coast to coast. ...
-
Data Engineering Developer
2 weeks ago
Interac Corp. Toronto, Canada Full timeData Engineering Developer · At Interac, we design and deliver products and solutions that give Canadians control over their money so they can get more out of life. But that's not all. Whether we're leading real-time money movement, driving innovative commerce solutions like ope ...
-
Senior Data Developer
2 weeks ago
Upgrade, Inc. Toronto, Canada: We are in search of a Senior Data Developer to design, architect, and maintain Upgrade's DW that supports our data and analytical needs for our rapidly evolving suite of financial products. This role will partner closely with our Data Platform, Backend, TechOps, Product, Market ...
-
Data developer
3 weeks ago
Tata Consultancy Services Toronto, ON, CanadaTCS has been recognized as a Global Top Employer by the Top Employers Institute - one of only eight companies worldwide to have achieved this status. Our organizational structure is domain-led and designed to offer businesses a single window into industry-specific solutions. Our ...
-
Data & BI Developer
2 weeks ago
Bond Brand Loyalty Toronto, Canada Full timeAt Bond we design creative and innovative solutions for our clients, all with the goal of helping them build ever-stronger loyalty to their brands. That can take us in some pretty amazing directions, you'll have your hands on the wheel as we drive the future of loyalty. · Workin ...
-
Data Engineer-Development
3 weeks ago
Tata Consultancy Services Toronto, CanadaAbout TCS · TCS operates on a global scale, with a diverse talent base of more than 600,000 associates representing 153 nationalities across 55 countries. TCS has been recognized as a Global Top Employer by the Top Employers Institute - one of only eight companies worldwide to ha ...
-
Data Developer
2 weeks ago
Scotiabank Old Toronto, CanadaPress Tab to Move to Skip to Content Link · Select how often (in days) to receive an alert: · Requisition ID: 199915 · Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture. · The Team · Automotive Finance IT support team is re ...
-
Data Quality Developer
1 week ago
S I Systems Toronto, ON, CanadaBilingual ETL Developer to maintain and integrate new business domains into Oracle and Snowflake data warehouses - 797 Our client is looking for a Sr. Bilingual ETL Developer to maintain and integrate new business domains into Oracle and Snowflake data warehouse. · Initial 5-mon ...
-
Developer/Data Transformation
2 weeks ago
Tata Consultancy Services Toronto, ON, CanadaTCS has been recognized as a Global Top Employer by the Top Employers Institute - one of only eight companies worldwide to have achieved this status. Our organizational structure is domain-led and designed to offer businesses a single window into industry-specific solutions. Our ...
-
Automation Developer, Data
3 weeks ago
Swoon Toronto, ON, CanadaJob Title: IBM Sterling MFT DeveloperContract Duration: 18 monthsLocation: Toronto (Remote work available)Responsibilities:- Design, develop, and implement MFT solutions using IBM Sterling MFT- Write and maintain Unix shell scripts for task automation- Configure and manage MFT se ...
-
Big Data Developer
2 weeks ago
Quantum World Technologies Inc. Toronto, CanadaJob Title: Big Data Developer Location: Toronto, ON Position Type: Full Time Note: Must have 6+ years experience in Bigdata Development Job Description: Strong experience with Hadoop , Hive, Apache Sqoop, Apache Spark (must-have) Exposure and familiarity with Talend ETL tool (or ...
-
Data Engineer-Development
3 weeks ago
Tata Consultancy Services Toronto, ON, CanadaAbout TCSTCS operates on a global scale, with a diverse talent base of more than 600,000 associates representing 153 nationalities across 55 countries. TCS has been recognized as a Global Top Employer by the Top Employers Institute - one of only eight companies worldwide to have ...
-
Software Developer, Data Engineering
1 week ago
Robinhood Toronto, CanadaJoin a leading fintech company that's democratizing finance for all. · Robinhood was founded on a simple idea: that our financial markets should be accessible to all. With customers at the heart of our decisions, Robinhood is lowering barriers and providing greater access to fina ...
-
SalesForce Data Developer
3 weeks ago
Scotiabank Toronto, ON, CanadaPress Tab to Move to Skip to Content Link Select how often (in days) to receive an alert: · Our Global Wealth Management Engineering Team is hiring a Salesforce Developer: · Performed many implementations on Salesforce platform – for Enterprise level projects – at least 5. · M ...
-
Data Developer marketing
3 weeks ago
Designfusion Ontario, CanadaDesignfusion is a dynamic, evolving company that is always looking for the right people to help our company grow. People who are creative thinkers and not afraid to take on challenges. Teamcenter Developer and Application Support · Teamcenter Developer and Application Support · ...
-
Big Data Developer, GFT
3 weeks ago
Royal Bank of Canada> Toronto, CanadaJob Summary · Job Description · What is the opportunity? · Are you a talented, creative, and results-driven professional who thrives on delivering high-performing applications. Come join us · Global Functions Technology (GFT) is part of RBC's Technology and Operations division. G ...
Data Developer - Toronto, Canada - Scotiabank
![Scotiabank background](https://contents.bebee.com/companies/ca/scotiabank/background-OE0OE.png)
Description
Is this role right for you?
In this role you will:Do you have the skills that will enable you to succeed in this role? We'd love to work with you if you have:
Technical Environment:
What's in it for you?
Work arrangements: Hybrid
#LI-Hybrid