Data Engineer ( enterprise data management)

Las Vegas

01 Feb 2021

Las Vegas

Full Time

1

3 - 10 years

Our client has reinvented the banking model and grown to over $12 billion in assets since our founding in 2000. With a broad and ever-growing range of financial products, is now rated among the top 5 digital banks in the country!  It's a holding company and publicly traded 

We bring together human insight and digital expertise to anticipate the needs of our customers. Our team members are innovative, technologically sophisticated, and motivated to achieve.   
 

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