Unosquare Logo
2135 - Data Engineer Software Development Professional
Seniority
Location
Required skills
Published 12 days ago

Data Engineer Summary:

• 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

Skills:
• Should be familiar with SSIS and ETL packages and also be able to create and support console programs written in C#
• Expertise in SQL server design and development
• Excellent verbal and written communication skills, including ability to simplify complex concepts for technical and non-technical audience
• Superior problem-solving skills, self-motivation, and the capacity to work under pressure and tight deadlines
• Demonstrated ability to learn, acquire and utilize new technologies, disciplines and frameworks as needed
• Technical expertise in the areas of data profiling, data mining and data analytics
• Technical expertise in building reliable data ETL/ELT processes, query optimization and dynamic SQL
• Strong customer focus, excellent problem solving and analytical skills
• Ability to work independently under minimal supervision and strong track record of setting and meeting delivery commitments