Data Engineer

Overview Engineers in this role accomplish business objectives by monitoring system functions from all points of system processing, identifying, and assisting in solving processing problems. They will also execute system configuration, transformations, and data mapping. The engineer works closely with internal partners and external clients by providing technical assistance on products and services, department reporting and process trending. They are responsible for utilizing internal data sources to perform in-depth research and analysis on client data inquiries, execute a varying level of implementation functions such as testing new file extracts, provide defect and enhancement support to development and product teams. They can provide guidance to others in areas of products as well as processing workflows. Responsibilities · Create and execute complex SQL queries. · Demonstrates subject matter expertise in relation to Data Mapping, Programming, and Ingestion workflows. · Demonstrates subject matter expertise in relation to data analysis, data mining an investigation using SQL and/or Oracle. · Can independently deploy, configure, monitor production solutions and services while working mentor others to do the same. · Serves as a change agent to identify organizational improvements and make recommendations to improve business processes. · Validate new tech requirements are properly integrated within existing processes and product functionality. · Write technical defect requirements, SOP creation and updates. · Train and mentor new system analysts. · Ability to participate in project meetings contributing to the SDLC. · Troubleshoots and provides solutions for complex problems. · Provide technical operational expertise when working with Engineering teams to troubleshoot issues or building requirements for new functionality. · Leverages multi-disciplinary knowledge to develop innovate ideas. · Contributes to the productivity of the organization through the completion of projects associated with departmental objectives. · Provide off hour support as needed. · Demonstrates an ability to work independently in all areas of job expectations. · Complete all responsibilities as outlined on annual Performance Plan. · Complete all special projects and other duties as assigned. · Must be able to perform duties with or without reasonable accommodation. · This job description is intended to describe the general nature and level of work being performed and is not to be construed as an exhaustive list of responsibilities, duties and skills required. This job description does not constitute an employment agreement and is subject to change as the needs of the client and requirements of the job change. Qualifications · Bachelor’s degree in relevant filed such as Computer Science or Engineering. · 5+ years’ experience with data aggregation, standardization, linking, quality check mechanisms, and reporting. · 5+ years’ experience with RDBMS (Oracle, MS SQL Server), Columnar databases (Vertica, Redshift), and data integration/ETL tools (Talend, Pentaho). · Familiar with programming language, operating systems, computer hardware platforms – not responsible in actual hardware/software development – such as: o Microsoft Office Suite (Excel, Word, Access, Visio o UNIX/Linu o XML · Understanding of relational databases and familiar with ETL database functions. · Demonstrated experience in data production environment supporting. · Familiar with System Development Life Cycle (SDLC) process. · Experience working in an Agile/Scrum environment.