Associate Data Engineer Job in Healthedge Software, Inc.

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 complex updates that may require scripting skills beyond using the native SSIS components 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, sprint refinement, planning, retrospectives and other agile processes to support two weeks sprint cycles and assure consistent and accurate delivery of Healthcare data and software Work closely with data architect, SMEs and other technology partners to develop & execute on the data architecture and product roadmap Work with stakeholders including the leadership, product, customer teams to support their data infrastructure needs while assisting with data-related technical issues Keep current on big data and data visualization technology trends, evaluate, work on proof-of-concept and make recommendations on cloud technologies Act as a subject matter expert to leadership for technical guidance, solution design and best practices within the customer organization 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 Advanced SQL and ETL automation experience Experience working with Microsoft Database Technologies including SSIS & SSRS 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. Excellent communication and presentation skills Experience with US Healthcare data domain is a plus Nice to Have: Certification in one of the cloud platforms (AWS/GCP/Azure)