What are the responsibilities and job description for the BIG Data Engineer position at Saxon Global?
Database Modelling
Stored Procedures
Person has to work c2H
Job Description :
Enterprise Master Data Technology group is at the forefront of building BNYM Strategic Reference Data Platforms. We are looking for a motivated senior Data Engineer. S / he will be part of the team that builds, maintains, and promotes our Enterprise Master Data platform, enable many teams cross LOBs in BNYM with the Client, Account, Product, Refernce data we own.
We are looking for a Data Engineer with focus in Relational Database. Candidate is expected to be operating under the guidance of Tech Lead, however is expected to be self-starter and operate with an ownership mentality and interface with other teams. Candidate must be familair with Agile Software Delivery Practice. This role is in Pittsburgh, PA HYBRID.
Skills and Qualifications
- Good knowledge of Relational Model, Dimensional Data Modeling, Data Warehouse
- Advanced working SQL knowledge and performance tuning
- Experience working with relational databases, for example Oracle, Vertica, familiar with Database objects like Indexes, Views, Synonyms
- Hands-on experience in database programming and design using PL / SQL, Stored Procedures, Functions, Triggers, and Views, using Oracle 12c or better
- Knowledge of ETL, experience in related programming, Java, Python, etc
- Unix / Linux and Scripting, Bash, Python, etc
- Experience using version control and DevOps tools such as Git, Jenkins, etc.
- Comfotrable working with large, complex datasets, performs data analysis required to troubleshoot data related issues
- Experience in Reference / Master Data is a plus
- Knowledge of data security is a plus
- A logical thinker with demonstrably strong analytical skills
- Good written and verbal communication skills, contributes to engineering wiki, and documents work
- Establishes good working relationship across peers and teams
- 5 years of experience in architecture in Data Engineer role , Master's or Bachelor's degree in Computer Science
- Is the goal to convert the candidate from temp to FTE? Yes
- How many years of experience will be required? 5 years in the area
- Is previous experience in the financial services industry required? Not a must
- Is a college degree required? If so, what type? Yes, Computer Science or a related discipline
- Will this position be a remote start or onsite? Onsite
- What are the top 3 skills that you'll be looking for on a resume? SQL, DB model, Stored Procedure
Manager Release Notes :
o If remote- would you consider candidates who sit 100% remote for the duration of the assignment? No
o If onsite- would you consider candidates who sit in other BNY locations such as Lake Mary, New York, or Boston? Location is Pittsburgh
