Data Engineer (financial services/banking)

Las Vegas

06 Sep 2021

Las Vegas

Full Time

1

3 - 10 years

Financial services/banking client - Direct Hire

 

 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
  • 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

Qualifications

  • 3+ years' working with relational DBs in a production environment
  • 3+ years' experience with Microsoft SQL Server
  • 2+ years' experience in SSIS packages
  • 2+ years' experience working in an Agile/SCRUM environment 
  • Experience delivering high quality, high traffic, scalable database objects
  • 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
  • Bachelor's Degree in Computer Science, Information Systems, Computer Engineering or related field

Preferred:

  • Experience in BigData 
  • Banking