Assoc. Data Engineer  

What you will do: 

• Extract, Transform, and Load (ETL) data sets in various file formats such as flat files, excel, Access, PDF, XML, JSON, EDI etc. 
• Maintain, optimize, and refactor existing ETL processes for improved performance and manageability 
• Build data pipelines to assemble large, complex sets of data that meet non-functional and functional business requirements 
• Create and maintain T-SQL scripts, stored procedures, functions, views, triggers, CTEs, Recursive table expressions etc. to handle large and complex datasets 
• Create and maintain SSIS packages for data updates 
• Ensure data quality and integrity in databases by developing robust validation scripts, and continuously make improvements to mitigate bugs, redundancies, and inconsistencies 
• Analyze and query multiple, complex databases and systems to produce various data analysis reports 
• Create and maintain documentation for data updates process using requirement specifications, schema and record layouts, programs, business requirements and other artifacts 
• Participate in daily scrum meetings, planning, retrospectives and other agile processes to support two weeks release cycles and assure consistent and accurate delivery of Healthcare data and software 

What You Bring: 

• 2+ years of data engineering experience working in partnership with large data sets 
• Solid experience, developing and implementing DW Architectures, OLAP & OLTP technologies and data modelling  
• Experienced with T-SQL and ETL automation 
• Proficient in using SSDT tools for building SQL server relational databases, Integration Services packages and Reporting Services reports   
• Experience with Python and/or Powershell 

• Experience with the version control system such as GIT, ADO etc. 
• Familiarity with BI & dashboarding tools and multi-dimensional modelling 
• Great problem-solving capabilities, troubleshooting data issues and experience in stabilizing big data systems. 

Bonus points:  

• Experience with US Healthcare data domain is a plus 
• Certification in one of the cloud platforms (AWS/GCP/Azure)