Senior Data Engineer

Responsibilities

• Work with technical and business team to understand the business requirements, functional and technical specifications • Design, code and maintain new and existing complex SQL stored procedures and functions • Performance tune existing stored procedures, tables, and indexes • Review SQL code written by other developers to ensure compliance to coding standards and best practices as well as maximum performance • Create SSIS packages for data transformation, cleansing, caching, aggregation, staging, and transfer • Troubleshoot problems that may come up with database environments: performance issues; replication issues; or operational issues • Perform data analysis and data profiling tasks to provide support and recommendations for development and design decisions • Analyze and define data flow requirements and prepare applicable system documentation and operation manuals as needed • Support production data loads and ongoing refreshes of the database systems • Define, prepare, execute, and implement data validation and unit testing methods to ensure data quality • Maintain re-usable development standards that help implement each solution and/or enhancements to existing systems to meet current and future needs • Perform enhancements and bug fixes as required