ETL Developer

Entertimeonline; Guaynabo (PR); On-site; USD 65,000 - 95,000; Full time

Job summary

Entertimeonline in Puerto Rico is seeking an experienced ETL Developer to deliver ETL processes that support business intelligence and reporting. You will analyze data to provide insight and ensure accuracy for analytic models while collaborating with cross-functional teams.

The role involves developing SSIS packages, writing complex SQL queries, and building dashboards, with a strong focus on data quality and integrity across multiple data sources and systems.

Qualifications

• Bachelor’s degree required.
• 5+ years of ETL and BI experience.
• Fluent in English and Spanish.

Responsibilities

• Develop SSIS packages using TFS 2008 or later.
• Write complex SQL queries, stored procedures, and functions; manage transactions.
• Create dashboards and reports for business intelligence.
• Ensure data quality and integrity across systems and data sources.

Skills

English proficiency

Spanish proficiency

Data analysis

ETL concepts

Education

Bachelor's Degree

Tools

SSIS

Team Foundation Server (TFS)

SQL

Job description

Contact information

Description

Job Description

Responsible for the delivery of (Extract, Transformation, and Loading (ETL) process) of information assets in support of business intelligence and reporting to support business decisions. Accountable for the analysis of data to provide insight and recommendations for business decisions and the performance of data validation to ensure accuracy and appropriateness of analytic models.

Responsibilities

• Develop SSIS packages using Team Foundation Server (TFS) 2008 or later.
• Perform complex stored procedures, complex SQL queries, and user defined functions, Common Table Expressions and transaction management using best practices.
• Create dashboards
• Analyzes, develops, and maintains quality control in management of advancement information to ensure data integrity.

Requirements

• Bachelor’s Degree
• Minimum of five (5) years of proven experience in same or similar
• Must be able to communicate effectively (read, speak, and write) in English and Spanish
• Responsible for designing, developing, and maintaining data extraction, transformation, and loading (ETL) processes across different systems.
• Integrates data from multiple sources, ensures data quality and integrity, and optimizes data flows to support migration, analysis, and reporting.
• Develops and maintains database objects, optimizes SQL queries, and performs data management tasks required for assigned projects.
• Requires knowledge of SQL, databases, and integration tools such as SSIS.