Aannex Solution logo
Edit
Aannex Solution logo

About Us

Aannex Solution Inc , a Canadian owned company, provides IT support and solutions from small, medium to large sized businesses in various industries. We are Enterprise Cloud-Computing Consultants. AANNEX is a rapidly growing consultancy firm.

Free Consultation

Contact Info

Contact for Support

Contact for Support

1 (866) 328 6152

Career

Data Modeler

Data Modeler

Location: TBD

Job Description

As a Data Modeler, you are a data expert in global markets trading systems, driving the modelling of schema design across trading systems + integration services

Responsibilities

  • Platform independent skill to understand business and create the database objects (tables and relations that tie those together, typically normalized relational model, ERD, data integrity, keys) that map the business rules into this formalized view

  • Oracle, MS SQL Server, Sybase, mySQL, PostgreSQL skill to bring alive those tables by manipulating the data that live there, whether via stored procedures or triggers, web front end or client server GUI, conversion scripts, ETL, report writing, etc.

  • Oracle, MS SQL Server, PostgreSQL thorough understanding of how optimizer creates an explain plan, differences between full scans and merge and nested loops, how indices work, engineering approach to influence explain plans, i.e. how to build for scalability and how to improve performance (on many occasions from forever to instant)

  • Platform independent experience to build robust scalable big data systems, based on dimensional modeling that produces user friendly reports and dashboards, ability to convert relational OLTP data into dimensional decision support system via reliable meta driven ETL with extensive logging, OLAP, hierarchies, operational data stores, data marts, data vaults, thorough knowledge of Kimball’s and Inmon’s methodology, denormalization (advantages and drawbacks), star schema, snowflake schema, dimensions and fact tables

  • Data Analysis, Data Mining, Statistics, Data Visualization ability to analyze big data, find the patterns and present those in the meaningful easy to understand way

  • Data migration, conversion, data cleaning – platform independent skills and experience when moving data between legacy and new systems

  • Expertise in modelling trading system data across trading processes, including trade, transaction, event and reference data.

  • Expertise in trading systems platforms, their internal data representations, and their messaging, file and API representations, including Calypso, Murex, Broadridge.

  • Expertise in working with development teams to align their development + testing efforts.

Requirements

  • Strong understanding of RDBMS • ORACLE ver. 5.0 - 11.0 (SQL*Plus, PL/SQL, stored procedures and triggers, PRO*C, SQL*Loader, Export/Import, Oracle Packages, Report Builder, Developer 2000 (forms and report builder), Explain Plan, Hints, Oracle Enterprise Manager, Oracle Warehouse Builder, Oracle Discoverer, TOAD) • MS SQL Server ver. 7.0 – 2012 (Management Studio, Enterprise Manager, Transact SQL, stored procedures and triggers, DTS, SSIS, SSRS, SSAS, OLAP, MDX, security, explain plan, isql, osql, integration with .NET) • Postgre SQL, ver.7.0 - 9.1, plpgsql, dblink, partitioning, copy utility, pgAgent • mySQL, sqlite3, INGRES, MS ACCESS, WATCOM, OASyS, Erwin • SYBASE ver. 4.9 – 11 (Open Client Library, DB-Lib, CT-Lib, S-Designor, bcp)

  • Languages: C/C++, VC++, JAVA, C#, .NET, Objective C, PYTHON, Visual Basic, PowerBuilder, Fortran, Assembler

  • Scripting and Web: UNIX Shell, PERL, PHP, LAMP, JavaScript, VBScript, JAVA applets, Node JS, SOAP Web API

  • Applied Stats Packages and Environments: R, SAS

  • Reporting Tools: Crystal Reports, Business Objects, Oracle Report Writer, Oracle Discoverer, SSRS, Cognos Impromtu, GQL

  • OS: UNIX (SOLARIS, OSF1, HP-UX, AIX, DG/UX, OS-9), MS WINDOWS, MS-DOS, VMS.

  • Time Series Databases: PHD (Honeywell), PI (OSI Soft), IP21 (Aspen)

  • Exposure to messaging and API schema implementations

  • Clear, concise, purposeful documentation skills

  • Self-starter, motivated, collaborator

  • Great communicator

  • Demonstrates initiative

LocationRemote
Websitewww.aannex.net
SalaryHourly Rate
EXPERIENCE NEED4-5yrs
Apply on or Before30 September, 2021

Apply Now

Cloud Services

Cloud Models

Discover US

Connect With Us

Linkedin
Facebook
Twitter
Instagram
Contact for support

Contact for support

1 (866) 328 6152

Subscribe Newsletter

Sign up for our latest news & articles. We won’t give you spam mails.

Copyright © 2021 Aannex Solutions Inc.