Data Engineer (Senior or Mid-level)

Responsibilities:

• Builds and deploys software, meeting standards and with defect rates below the target threshold.
• Delivers solutions in line with user expectations as per defined requirements.
• Programs and effectively tests changes for production migration.
• Leads in resolution of routine data integration errors/variances when needed.
• Researches and analyzes data in support of troubleshooting production issues.
• Provides regular updates and status of issue/task to the manager, product owner and/or report requestor.
• Provides technical counsel to co-workers and mentors associate members of the team.
• Thoroughly documents all development activities including user requests, specifications, development, modifications, testing and on-going production support.
• Continuously improves departmental processes, programs, operations and services.
• Consults users on system and data capabilities.

Job Summary - Mid-level:

• This position is responsible for the development of complex data integration processes, data transformation, and/or developing advanced visualizations within Penn Medicine. This individual will be required to ensure that the extracted, transformed, and/or displayed information meets all clinical and business requirements of the organization and end-users. This will entail creating new as well as maintaining and modifying existing development. This individual will be required to provide technical counsel and guidance to other team members, consultants, IS Staff, and end-users.

Responsibilities:

• Build and deploy software meeting standards and with defect rates below the target threshold.
• Assemble large complex data sets that meet functional and non-functional business requirements.
• Build the analytics infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL, ETL, visualizations, and/or big data technologies.
• Create analytics tools that utilize existing data assets to provide actionable insights into operational efficiency, quality improvement, and other key business performance metrics.
• Continuously improves departmental processes, programs, operations, and services.
• Research and data analysis in support of troubleshooting production issues.
• Participate in resolution of routine data integration errors/variances when needed.
• Coordinate with other IS groups to see problems through to resolution
• Attend planning and status meetings with team members, system administrators, and/or clients/end-users to understand project requirements and provide constructive commentary.
• Proactively contribute with ideas and solutions
• Consult users on system and data capabilities.
• Ensures clients find the DAC process supportive and effective
• Provide regular updates and status of issue/task to the manager, product owner, and/or report requestor
• Deliver solutions in line with user expectations as per defined requirements.
• Provide technical counsel to co-workers
• Maintain strict levels of data confidentiality, privacy, and security
• Performs duties in accordance with Penn Medicine and entity values, policies, and procedures
• Other duties as assigned to support the unit, department, entity, and health system organization

Education/Experience - Senior level:

• Bachelor's Degree (Required)
• 10+ years of experience in data warehousing, ETL and/or visualization experience (Required). 
• 10+ years of experience with databases and data architecture (Required).

Skills & Abilities:

• Demonstrated interpersonal/verbal communication skills.
• Ability to communicate technical information and ideas.
• Ability to communicate effectively with all levels of staff.
• Demonstrated customer service skills.
• Ability to solve problems and improve processes.
• Proficient with use of MSSQL, T-SQL, Oracle, PL/SQL and/or advanced data processing tools.
• Proficiency working with a variety of data formats such as XML, JSON.
• Proficiency working with program and script languages such as C#, Java, JavaScript, Python, Shell.
• Proficiency working with very large data sets.

Education/Experience - Mid-level:

• Bachelor's Degree (Required), preferably in Computer Science, Information Technology, Informatics, Software Engineering, Mathematics or related STEM discipline.
• 5+ years of experience working directly with data and/or databases (Required).

Skills & Abilities:

• Experience with relational and/or NoSQL databases (such as Oracle, MSSQL, HANA, HBase) and authoring SQL, PL/SQL and/or T-SQL.
• Experience with programming in languages such as SQL, C#, Java, JavaScript, Bash, R, Python and/or Scala.
• Experience developing within IBM DataStage, Informatica, HANA, Spark, Kafka and/or other data transformation tools/processes.
• Experience with the SAP BusinessObjects suite (Lumira, Design Studio, etc), PowerBI, D3 and/or other advanced visualization toolsets.
• Experience building and deploying within cloud-based services, such as AWS or Azure.
• Knowledge of healthcare data/systems.
• Ability to utilize critical thinking.
• Ability to work independently.
• Strong written, oral, and non-verbal communication skills.