8918 - Data Engineer Data

Job Description:

• 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
• Work with other engineers to troubleshoot, repair and performance tune databases
• 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
• Perform any additional duties as assigned