Enterprise Data Engineer - EDW, ETL & Security

Easter Seals Southern California, Inc.; Irvine (CA); On-site; USD 87,000 - 110,000; Full time

Job summary

Easterseals Southern California is seeking a Database Architect to design, implement, and maintain our Enterprise Data Warehouse (EDW) architectures that support business applications and processes. You will oversee data ingestion, ETL/ELT, database security, and performance tuning to ensure reliable data delivery for analytics and decision-making.

Collaborating with IT, security, and analytics teams, you will help safeguard data, manage capacity, and maintain system integrity while planning

Qualifications

• Bachelor's degree in computer science, IT, or related field.
• 3-5 years DBA and cloud architecture experience.
• Proficiency in SQL and relational DB management systems.
• Experience with Spark, PySpark, and KQL preferred.
• Knowledge of data governance and security best practices.

Responsibilities

• Designs, implements, and maintains database schemas supporting applications and business processes.
• Manages data ingestion and ETL/ELT for the Enterprise Data Warehouse (EDW).
• Ensures backup and recovery procedures are documented and tested.
• Monitors and optimizes database performance for efficient queries.
• Collaborates with IT security and compliance on data governance.
• Leads incidents for the EDW and maintains documentation.
• Plans database upgrades and patching to stay current.
• Provides training on database management best practices.

Skills

SQL proficiency

Data warehousing

Spark

PySpark

KQL

Notebooks

Lakehouses

Education

Bachelor's degree in computer science or related field

3-5 years DBA experience

Tools

Databricks

Snowflake

AWS

Google Cloud

Azure

Microsoft Purview

Job description

Easterseals Southern California is seeking a Database Architect to design, implement, and maintain our Enterprise Data Warehouse (EDW) architectures that support business applications and processes. You will oversee data ingestion, ETL/ELT, database security, and performance tuning to ensure reliable data delivery for analytics and decision-making.

Collaborating with IT, security, and analytics teams, you will help safeguard data, manage capacity, and maintain system integrity while planning