Data Engineer

NTT DATA North America

Montreal

Hybrid

CAD 57,859,200 - 63,369,600

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Benefits offered by this job

Medical, dental, and vision insurance

Flexible spending or health savings account

Paid time off

401k program with company match

Job summary

A leading technology service firm located in Montreal is hiring a Data Engineer to work within a Global Team responsible for developing Trade Capture data stores. The role involves translating business requirements into database queries, designing scalable databases, and developing efficient automation scripts using Python and SQL. Ideal candidates should have strong relational database skills, particularly with DB2 or Sybase, and knowledge of the equity derivatives business is a plus.

Qualifications

Strong relational database skills especially with DB2 or/and Sybase.
Experience with automation scripts using Python.
Knowledge in equity derivatives business would be advantageous.

Responsibilities

Translate business requirements into queries against relational tables.
Design and build scalable databases.
Develop and tune stored procedures and queries.

Skills

Relational database skills (DB2/Sybase)

Python

SQL

ETL tools

Data reporting tools

Tools

Power Designer

Job description

Join to apply for the Data Engineer role at NTT DATA North America

Get AI-powered advice on this job and more exclusive features.

NTT DATA strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now.

This is a Data Engineer role in the team responsible for developing on the firm's Trade Capture data stores that holds the transactional data for real time. The Global Team consists of highly technical team members who are adaptable and hands on in software development and life cycle management and proficient in DevOps.

We deliver multiple projects for multiple business areas in parallel. The business owners and subject matter experts will be globally distributed, making communication and pro-active to be important. The candidate will be expected to work closely with our users and support partners. The development will be performed using an agile methodology which is based on scrum (time boxing, daily scrum meetings, retrospectives, etc) and XP (continuous integration, refactoring, unit testing, etc) best practices. Candidates must therefore be able to work collaboratively, demonstrate good ownership and be able to work well in teams.

Primary responsibilities include:

Translate business requirement into queries against a set of relational tables and produce reporting based on the requirements.
Design and build scalable and performant databases.
Database and ETL development, including stored procedures, queries, performance tuning, archiving, etc.; using python, SQL and ETL tools.
Build efficient automation scripts (using Python etc.)

Technical Skills Requirement:

Strong relational database skills especially with DB2 or/and Sybase.
Create high quality and optimized stored procedures and queries
Experience with Power Designer or some similar modeling tool.* Python and Unix / K-Shell

Strong knowledge base of relational database performance and tuning such as:

Proper use of indices, database statistics/reorgs, de-normalization concepts.
Experience with data reporting tools is a big plus.
Familiar with lifecycle of a trade and flows of data in an investment banking operation. Experienced in Agile development process.
Knowledge in Equity Derivatives Business would be advantageous.
The current global team members are all very skilled in domain modeling, database design, big data, Java and messaging so this is an excellent opportunity to play a key role in the growing team.

About NTT DATA:
Where required by law, NTT DATA provides a reasonable range of compensation for specific roles. The starting hourly range for this role isHOURLY RATE $42.00hrTO $46.00/hr.Actual compensation will depend on several factors, including the candidate’s relevant experience, technical skills, and other qualifications.

This position is eligible for company benefits that will depend on the nature of the role offered. Company benefits may include medical, dental, and vision insurance, flexible spending or health savings account, life,and AD&D insurance, short-and long-term disability coverage, paid time off, employee assistance, participation in a 401k program with company match, and additional voluntary or legally required benefits.
NTT DATA is a $30 billion trusted global innovator of business and technology services. We serve 75% of the Fortune Global 100 and are committed to helping clients innovate, optimize and transform for long term success. As a Global Top Employer, we have diverse experts in more than 50 countries and a robust partner ecosystem of established and start-up companies. Our services include business and technology consulting, data and artificial intelligence, industry solutions, as well as the development, implementation and management of applications, infrastructure and connectivity. We are one of the leading providers of digital and AI infrastructure in the world. NTT DATA is a part of NTT Group, which invests over $3.6 billion each year in R&D to help organizations and society move confidently and sustainably into the digital future. Visit us at us.nttdata.com
Whenever possible, we hire locally to NTT DATA offices or client sites. This ensures we can provide timely and effective support tailored to each client's needs. While many positions offer remote or hybrid work options, these arrangements are subject to change based on client requirements. For employees near an NTT DATA office or client site, in-office attendance may be required for meetings or events, depending on business needs. At NTT DATA, we are committed to staying flexible and meeting the evolving needs of both our clients and employees. NTT DATA recruiters will never ask for payment or banking information and will only use @nttdata.com and @talent.nttdataservices.com email addresses. If you are requested to provide payment or disclose banking information, please submit a contact us form, https://us.nttdata.com/en/contact-us.
NTT DATA endeavors to make https://us.nttdata.com accessible to any and all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact us at https://us.nttdata.com/en/contact-us. This contact information is for accommodation requests only and cannot be used to inquire about the status of applications. NTT DATA is an equal opportunity employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status. For our EEO Policy Statement, please click here. If you'd like more information on your EEO rights under the law, please click here. For Pay Transparency information, please click here.

Seniority level