Data Engineer

Job Description

Design, code and maintain new and existing complex SQL stored procedures and functions.

Responsibilities:

• Design, code and maintain new and existing complex SQL stored procedures and functions. Review SQL code written by other developers to ensure compliance to coding standards and best practices as well as maximum performance.
• Work with other engineers to troubleshoot, repair and performance tune databases. Perform data analysis and data profiling tasks to provide support and recommendations for development and design decisions.
• Create SSIS packages for data transformation, cleansing, caching, aggregation, staging, and transfer. Define, prepare, execute and implement data validation and unit testing methods to ensure data quality.
• Troubleshoot problems that may come up with database environments: performance issues; replication issues; or operational issues. Maintain re-useable development standards that help implement each solution and/or enhancements to existing systems to meet current and future needs.
• 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

Education & Experience

• Bachelor's Degree in Computer Science, Information Systems, Computer Engineering or related field
• 5+ years working with relational DBs in a production environment, Microsoft SQL Server versions, and SSIS packages
• 5+ years experience working in an Agile/SCRUM environment required
• Experience in C# scripting experience