Overview :
Our Clients Alternate Solutions Group, is seeking an experienced Data Modeler to work on dynamic projects transitioning from on-premise to Azure Cloud, with a key focus on supporting the Dynamic Currency Converter (DCC) application.
This role involves designing data models optimized for real-time OLTP (Online Transaction Processing) systems, capturing high-volume transactional data critical to banking applications.
You will drive data architecture practices within the Alternate Solutions Group and Simplii Financial line of business, collaborating with technology and business teams to ensure scalable, high-performing data models that support core applications.
You will act as a senior technical consultant, evaluating and refining existing data design patterns and defining scalable, efficient data solutions aligned with enterprise architecture strategies.
Leading data model design, offering innovative solutions for critical business and technology initiatives as well as serving as a primary data modeling resource, translating business requirements into technical data designs, and fostering relationships with both internal and vendor stakeholders.
This role offers a strategic opportunity to shape our Client's OLTP data architecture within high-impact banking applications and take ownership of data models driving the future of digital currency initiatives
Daily Responsibilities :
- Design, develop, and maintain conceptual, logical, and physical data models for OLTP systems that efficiently capture and structure transactional data, supporting DCC application
- Partner closely with stakeholders including business analysts, data architects, database administrators, and data governance teams to align data models with business requirements
- Ensure adherence to data standards, naming conventions, and governance policies; collaborate on data quality rules and data validation processes
- Analyze and optimize query performance, identifying bottlenecks and adjusting data structures or indexes to enhance transaction speed and scalability
- Focus on modeling that prioritizes transaction processing speed and reliability, ensuring ACID compliance to maintain data integrity and supporting high-volume, real-time transaction environments
- Regularly update data models as requirements evolve, integrate new data sources, and maintain comprehensive documentation of data structure changes
Technologies Used :
- Databases : Oracle, SQL Server, MySQL, DB2, PostgreSQL, Azure SQL, MongoDB, and SQL DB
- Data Modeling Tools : Erwin, ER Studio, Power Designer, Toad Data Modeler, MySQL Workbench, Sparx Enterprise Architect, Visual Paradigm, Lucidchart
Must-Have Qualifications :
- OLTP-based data modeling within banking, finance, or capital markets, with a strong ability to articulate OLTP concepts
- Extensive experience with data modeling tools commonly used in banking / finance such as Erwin, ER Studio, Power Designer
- Hands-on experience with relational databases like Oracle, SQL Server, and DB2, as well as NoSQL databases such as MongoDB
- Expertise in SQL for enhancing database processes, prioritizing speed and transactional efficiency
Nice-to-Have Qualifications :
- Familiarity with Tableau, Power BI for data visualization
Senior Data Modeler
Proficiency in Python to quickly transform and manipulate data. Strong SQL skills, as the Murex database is Oracle. Understanding of JSON and XML, since Murex intraday events data will be in MXML format used by Murex. Candidate personal data will be processed in line with our Global Candidate Privac...
Data Modeler
Partner closely with stakeholders—including business analysts, data architects, database administrators, and data governance teams—to align data models with business requirements. Leading data model design, offering innovative solutions for critical business and technology initiatives as well as ser...
Data Modeler
Be in charge of developing conceptual, logical, and physical data models and implementing RDBMS, operational data stores (ODS), data marts, and data lakes on target platforms (SQL/NoSQL). Keep the metadata – the "data about the data" that describes the data model, its structure, and semantics – up t...
Data Modeler
Experience as a Data Modeler (or closely related occupation) building Business Process Model Notation (BPMN) models to depict end to end business process flows and Domain Modeling Notation (DMN) to design and execute decisions and complex business rules management. DE designing and developing data v...
Data Architect Modeler 5782
Perform data profiling, assess data accuracy, design and document data quality and master data management rules. Design dimensional data mart models, create source-to-target-mapping documentation, design and document data transformation from curated model to data mart. BI Data Architect experience i...
Data Modeler
Advanced knowledge of data modeling techniques with an understanding of data gathering, inspection, cleansing, and transformation. Advanced skill in using data modeling tools and approaches with an understanding of physical implementation issues, data strategies, design implications, and performance...
Senior Data Modeler/data Engineer
We are seeking a Senior Data Modeler/Data Engineer to join our Information Technology Department to play a crucial role in designing and implementing data models for a data warehouse/lakehouse that support our business requirements. Create and maintain comprehensive technical documentation for datab...
Intermediate Data Modeler- Capital Markets - data architecture strategy, data modeling, and the overall data practice with a OLTP environment - 80460-1
Job Description: Seasoned professional responsible for providing operational leadership, governance and stewardship for the data architecture strategy, data modeling, and the overall data practice, in addition to all related principles, policies, and procedures around data management. Position Title...
Data Modeler
Experience with Azure Solutions Strong Data Analysis skills Strong Data Modeling skills Expertise with Power Designer, Erwin Data Modeling tool Familiarity with Capital Markets data Able tomunicate clearly, both verbally and in written form Good work ethic, results oriented, and accuracy, attention ...
Senior Manager - Project Accounting
Senior Manager - Project Accounting to join a dynamic team environment. Manage and oversee the full accounting cycle for multiple development projects. Monthly review of projects’ trial balances and maintenance of key schedules for letters of credit, loan amortizations, other and accrued liabilities...