Sr Data Engineer - Blue Bell, PA

AHU Technologies Inc; Washington (District of Columbia); On-site; USD 90,000 - 110,000; Full time

Job summary

A data solutions company located in Washington, DC is seeking an experienced Data Engineer to join their team. The ideal candidate will have extensive experience with data aggregation, RDBMS, and ETL tools. Responsibilities include creating complex SQL queries, mentoring team members, and troubleshooting issues. A Bachelor’s degree in Computer Science or Engineering is required, alongside familiarity with Agile/Scrum methods. Competitive salary offered with potential for bonuses.

Qualifications

• 5+ years of experience with data aggregation, standardization, linking, quality check mechanisms, and reporting.
• Demonstrated experience in data production environment supporting.
• Familiar with System Development Life Cycle (SDLC) process.

Responsibilities

• Create and execute complex SQL queries.
• Demonstrate subject matter expertise in Data Mapping and Programming.
• Troubleshoot and provide solutions for complex problems.
• Train and mentor new system analysts.

Skills

Data aggregation

RDBMS (Oracle, MS SQL Server)

Data integration/ETL tools (Talend, Pentaho)

SQL

Data analysis

Data mapping

Programming languages

Agile/Scrum

Education

Bachelor’s degree in Computer Science or Engineering

Tools

Microsoft Office Suite

UNIX/Linux

Job description

Job Description

• 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: Microsoft Office Suite (Excel, Word, Access, Visio UNIX/Linux XML
• 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 Cotiviti 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: Microsoft Office Suite (Excel, Word, Access, Visio UNIX/Linu 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.