Description

You will build and optimize data pipeline architecture and manage data flow for cross-functional teams.

Responsibilities

• Build data acquisition and ingestion pipelines using ETL tools like SSIS and Alteryx.
• Identify and integrate data from SQL Server, SAP, Teradata, Hadoop/Hive, PostgreSQL, Oracle, and flat files.
• Develop and optimize data models to support business applications.
• Define data architecture frameworks, including modeling, metadata, security, and reference data.
• Automate workflows and manage data projects using JIRA stories.

Required Skills

• 10+ years of SQL Server development experience.
• Expertise in T-SQL and SSIS.
• 5+ years of ETL experience.
• 5+ years of experience working with multiple database technologies, specifically Microsoft SQL Server and Teradata.
• Expert knowledge of data warehousing.
• Experience managing data reliability, efficiency, and quality.
• Bachelor's degree.

Preferred Skills

• Experience with Python and Azure Cloud.
• Data model development using ERWIN.
• Understanding of BI Lifecycle management, Microsoft VBA, and HTML.

Key Skills

Education

Bachelor's degree