ETL Developer
Tampa, FL Application Development
Job Type
Full-time
Description

COMPANY OVERVIEW:  

Trellance is a leading provider of business analytics and technology consulting for credit unions, helping them meet the financial needs of today’s digital consumer. With a comprehensive suite of data science solutions, professional staffing and professional services, the Trellance team ensures credit unions increase efficiency, manage risk, and improve member experience. As credit unions’ tech partner, Trellance brings them to the next frontiers of fintech, filled with powerful tools such as artificial intelligence and machine learning. Data In. Insights out. Learn more at Trellance.com.


Overall responsibility: Perform ETL functions in a data warehousing environment. Demonstrate advanced SQL coding skills as the main mechanism for data extraction and transformation. Collaborate with the data analysis team in refining requirements and identifying data quality issues.


Essential Duties:

  • Write advanced SQL including some query tuning.
  • Design, build and deploy effective SSIS packages.
  • Implement stored procedures and effectively query a database.
  • Translate requirements from the business and analyst into technical code.
  • Identify and test for bugs and bottlenecks in the ETL solution.
  • Ensure the best possible performance and quality in the packages.
  • Provide support and fix issues in the packages.
  • Other duties as assigned.


Requirements

Minimum Education/Experience:

Bachelor’s degree (BA or BS) from an accredited college or university plus a minimum of four (4) years of experience in the specific or related field. Or High School Diploma or equivalent plus a minimum of eight (8) years of experience in the field.


Company / Industry Knowledge: Knowledge of financial institutions and financial data, preferably credit union or retail banking related a plus.


Other Experience:

  • 3+ years of Advanced SQL experience.
  • Experience designing and building complete ETL/SSIS processes moving and transforming data for ODS, Staging, and Data Warehousing.
  • Experience in the identification of data quality.
  • Some database design experience is helpful.
  • Some Knowledge of C#/VB.NET a plus.
  • Utilize ad-hoc techniques to perform on-the-fly analysis of data.
  • Proficient in how to deploy to and debug a production SSIS environment.
  • Experience with Jira and code repository procedures a plus.