Job Summary / Purpose

The Data Engineer I develops data models and maintains foundational data architecture supporting Payer Strategy & Relationships (PSR) initiatives. This role manages information using relational databases, database management systems and tools. The Data Engineer I acts as a liaison between super users, data architects, programmers, and analysts to implement and enforce data integrity standards and procedures to ensure data is managed consistently and appropriately integrated within data marts and databases. Additionally, the Data Engineer I manipulates and integrates data from various sources to enlarge and enhance the data repository and is responsible for coding and documenting procedures, programming, testing and debugging.

Essential Key Job Responsibilities

• Develop scripts to automate routine and repetitive database SQL tasks using standard integration processes.
• Interact regularly with team members and clients to improve data structure, ETL processes, and application performance.
• Provide production support as required to ensure the availability and performance of developed applications for both external and internal users.
• Develop stored procedures, triggers, functions and views to support PSR initiatives.
• Develop SQL queries in the creation of business applications and SQL reports from corporate data sources.
• Evaluate, design, develop, implement and maintain PSR repository using industry standard database tools.
• Create and support data integration process through database refreshes and SSIS.
• Maintain data integrity by working to eliminate redundancy.
• Support PSR to continuously improve upon the current work/business processes to achieve high levels of effectiveness and efficiency.

• Bachelor of Science in Computer Science or related technical field. Education and experience may be considered in lieu of degree.
• Minimum of three (3) years of Information Technology (IT) experience in a fast-paced, complex business environment.
• Experience with relational database management systems (RDBMS) such as SQL Server, Oracle, DB2, MySQL, PostgreSQL.
• Experience developing SQL queries in the creation of business applications and SQL reports from corporate data sources.
• Proven ETL development and data integration between multiple data source systems.
• Detailed analytic problem-solving skills, documentation, communication and flexibility with strong attention to detail in high pressure situations.
• Ability to manage time, work within a team environment to meet project goals/deadlines.
• Ability to work on multi (Technical/Business) environments and train end users.
• Strong SSIS/T-SQL troubleshooting and debugging skills.
• Ability to provide effective testing of new technology related to data management, storage, and retrieval.
• Knowledge of all phases of Software Development Life Cycle (SDLC), from user engagement through post-implementation evaluation.
• Experience with creating views, stored procedures, functions, indexes, triggers, and other related SQL objects.
• Experience with Microsoft development tools and technologies including:
  • SQL Server 2008 R2/2012/2014/2016
  • MS Office (Excel, Word, PowerPoint, Access, Visio)
• Experience in payer contract analysis and payer process preferred
• Experience with healthcare claims and remit data preferred
• Experience in medical and billing data preferred
• Working knowledge of Python, JavaScript, C# or R preferred
• Working knowledge of Power BI, Tableau, and SAS preferred