ETL Lead at Austin, TX

Overview

On Site
$120,000 - $130,000
Full Time

Skills

Data Flow
Extract
Transform
Load
Scalability
SQL
Oracle Db
PL/SQL
Transact-SQL
Microsoft SSIS
Microsoft SSRS
Cloud Computing
Data Security
Encryption
Regulatory Compliance
Data Processing

Job Details

Role : ETL Lead

Location : Austin, TX

Fulltime

$120K - $130K PA

Here is the generic JD as ETL Lead

  • Develop Data pipeline
  • Strong SQL/Oracle DB knowledge ( T-SQL , PL/SQL)
  • Develop SSIS/SSRS workflow
  • Data governance
  • Performance optimization

 

1. Architecting Data Solutions

- Data Pipeline Design: Develop robust ETL architectures that ensure efficient data flow and transformation.

- Cloud & On-Prem Integration: Architect solutions that integrate cloud-based and on-premises data sources.

- Scalability & Performance : Design systems that can handle large-scale data processing with minimal latency.

- Security & Compliance: Implement best practices for data security, encryption, and regulatory compliance.

 

2. Data Modeling

- Conceptual, Logical & Physical Models : Define data structures that align with business needs.

- Normalization & Denormalization : Optimize data storage and retrieval for performance and flexibility. Good understanding of normalization.

- Dimensional Modeling : Design/Explain star and snowflake schemas for efficient reporting and analytics.

 

3. Business Understanding

- Stakeholder Collaboration : Work closely with business teams to understand data requirements.

- Data-Driven Decision Making : Enable insights through well-structured reporting and analytics.

- KPI & Metrics Definition : Help define key performance indicators that drive business success.

- Industry-Specific Knowledge: Understand domain-specific data challenges (e.g., finance or Schwab type organization).

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.