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.