Description

Analyze and document ETL processes, database structures, and reporting assets within the Flash EDW environment.

Responsibilities

• Analyze and document existing SSIS packages, covering data sources, destinations, transformations, and control flows.
• Map database schemas, including tables, views, stored procedures, and functions.
• Capture metadata and data lineage for critical datasets and data flows.
• Review and document SSRS reports, detailing datasets, layouts, and expressions.
• Maintain an inventory of SSRS reports, including usage and access control information.

Required Skills

• 6+ years of experience with SSIS, SQL Server, and ETL processes.
• Strong SQL programming skills and proficiency with SQL Server databases (schema, tables, views).
• Experience with database design and data modeling.
• Familiarity with AWS and Snowflake.
• Experience documenting package functionalities, dependencies, and schedules.

Preferred Skills

• Experience with other ETL tools and data integration platforms.

Key Skills

Education

Not specified