Data Engineer II

Job Summary: Handle the design and construction of scalable management systems, ensure that all data systems meet company requirements, and also research new uses for data acquisition. Required to know and understand the ins and outs of the industry such as data mining practices, algorithms, and how data can be used. Primary Responsibilities: Design, construct, install, test and maintain data management systems. Ensure that all systems meet the business/company requirements as well as industry practices. Integrate up-and-coming data management and software engineering technologies into existing data structures. Develop set processes for data mining, data modeling, and data production. Create custom software components and analytics applications. Research new uses for existing data. Employ an array of technological languages and tools to connect systems together. Collaborate with members of your team (eg, data architects, the IT team, data scientists) on the project's goals. Recommend different ways to constantly improve data reliability and quality. Must Have Qualifications: Technical Degree or related work experience Experience with non-relational & relational databases (SQL, MySQL, NoSQL, Hadoop, MongoDB, etc.) Experience programming and/or architecting data Extraction using DataStage or any other Data Extraction Tool Expert in writing Complex SQL queries Good understanding of Data modelling concepts and experience Understanding and Experience working with JSON file formats Good communication skills Ability to lead and follow-up one's work Ability to document one's work and Share knowledge with rest of the team Nice to Have: Some exposure to modern data engineering tool set Knowledge and hands on experience with Snowflake and DBT Must Have Skills: Advanced SQL Ascential DataStage Data Extraction Data Modeling ETL Developer/Snowflake JavaScript Object Notation (JSON)