This position is responsible for Data Sourcing, File Extract and ETL development associated with a major EHR migration program.
Specific Responsibilities:
- Develop & support Microsoft SSRS reports using MS Visual Studio/Report Builder.
- Develop & support Microsoft SSIS packages using MS Visual Studio.
- Create and update source SQL Server stored procedures and other SQL objects and jobs.
- Create and update ETL pipelines supporting near real-time applications.
- 5+ years of experience working directly with SQL Server
- Proficient with MS SQL Server, SSIS (with C#), and SSRS.
- Proficient in writing optimized SQL queries.
- Experience working with different data formats
- Data extracting experience
- Experience creating and maintaining SQL Server stored procedures, functions, triggers, etc..
Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.