Responsible for the design and development of databases and ETL flows
Maintain detailed documentation related to database and ETL systems
Documents will provide engineers with information about existing systems and new enhancements and/or functionality
Documents will be leveraged in future development work
Documents ensure systems are adequately represented
Develops design and functional specifications, produces deliverables related to the projects assigned and assists in post implementation support through customer service help and system enhancement.
Responsible for gathering, compiling, and synthesizing information (financial, healthcare, etc.)
Monitoring and troubleshooting errors related to SQL Agent Jobs and SSIS Packages
Optimizes database operations such as tuning Stored Procedures and User Defined Functions as well as SSIS packages
Any other duties as assigned
Qualifications:
Education & Experience
Bachelor's degree in Computer Science, information systems, or equivalent work experience
Four plus years of ETL experience with additional two to three years of a database design and development experience
Four years working with Microsoft technologies (SQL Server, SQL Server Integration Services and Visual Studio. C# .Net experience a plus)
Well versed with Agile development methodologies and respective tools (JIRA or TFS)
Experience working with either Azure and/or AWS a plus