Big Brothers Big Sisters of America, located in Tampa, FL, is looking for an ETL Developer to join their information technology team, remotely. An ETL Developer will report to the Chief Technology Team and will be responsible for program and data management. This position requires a Bachelor's degree. A minimum of 3 years experience designing, developing, testing and implementing ETL solutions using any enterprise ETL tools (SSIS), 3+ years of experience working with high volume data bases and/or big data.

Position Purpose

The ETL Developer assists on a wide range of analytics, business intelligence, and data warehouse initiatives designed to support data-driven business strategies. They will be primarily responsible for implementing the ETL processes. The ETL Developer should be well-versed in the design and development of ETL and database developments for a large data warehouse, as well as maintaining and supporting the production jobs. The Developer should be able to work collaboratively with other team members, as well as BBBS users for operational support.

Essential Duties and Responsibilities

  • Develops, designs, tunes and maintains SSIS packages to perform the ETL process.
  • Designs and develops SQL Server stored procedures, functions, views and triggers to be used during the ETL process.
  • Designs and develops ETL solutions using data integration tools for interfacing between source application and the Enterprise Data Warehouse.
  • Develops ETL technical specifications, designs, develops, tests, implements, and supports optimal data solutions.
  • Documents ETL data mappings, data dictionaries, processes, programs and solutions as per established standards for data governance.
  • Integrates ETL development with existing projects to maximize object reuse
  • Creates, executes, and documents unit test plans for ETL and data integration processes and programs.
  • Works with the data analysis team to assess and troubleshoot potential data quality issues at key intake points such as validating control totals at intake.
  • Performs problem assessment, resolution and documentation in existing ETL packages, mapping and workflows in production.
  • Troubleshoots data issues and defects to determine root causes in a timely manner.
  • Conducts performance tuning of the ETL process and SQL queries, and recommend and implement ETL and query tuning techniques.
  • Develops and creates transformation queries, views, and stored procedures for ETL processes, and process automation.
  • Other duties as assigned.

Equal Employment Opportunity

BBBSA provides equal employment opportunities to all qualified individuals without regard to race, creed, color, citizenship, religion, national origin, age, sex, familial or marital status, pregnancy, military or veteran status, sexual orientation, gender identity or expression, genetic information, disability, or any other legally-protected status in accordance with applicable local, state, and federal laws, regulations, and ordinances.

Americans with Disabilities Act

Employee must be able to perform all essential job functions, with or without reasonable accommodation.

Job Responsibilities

The above statements reflect the general duties, responsibilities and competencies considered necessary to perform the essential duties and responsibilities of the job and should not be considered as a detailed description of all the work requirements of the position. BBBSA may change the specific job duties with or without prior notice based on the needs of the organization.

Disclaimer

This job description has been designed to indicate the general nature and level of work performed by employees within this classification, it is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities and qualifications required of employees assigned to the job.