Data Engineer

Easterseals Southern California•Irvine, CA

5d•$87,000 - $110,000

About The Position

Easterseals Southern California is hiring a Data Engineer to design, implement, and maintain database architectures supporting business applications and processes. The role handles data ingestion and ETL/ELT processes within the Enterprise Data Warehouse (EDW), database security, performance optimization, data governance, backup and recovery, and compliance with applicable regulations. The position collaborates with stakeholders and cross-functional IT, compliance, development, analytics, and data science teams to support reliable database operations and data-driven decision-making. It also represents the EDW team in managing the Microsoft Fabric environment, supports team members, and helps plan for capacity and scalability.

Requirements

Bachelor's degree in computer science, information technology, or a related field, or commensurate or equivalent work experience.
Three to five years of experience as a Database Administrator and in cloud architecture (such as Databricks, Snowflake, AWS, or Google), or in a similar role.
Proven experience with the Microsoft ecosystem.
Proficiency managing relational database management systems such as T-SQL, MySQL, PostgreSQL, or Oracle.
Strong SQL skills, including the ability to write and optimize complex SQL queries.
Experience with database performance tuning and optimization techniques.
Knowledge of database security best practices and experience implementing measures such as encryption, access controls, and auditing.
Demonstrated proficiency with MS Office applications, including Word, Excel, and Outlook.
Ability to maintain customer service orientation and professionalism in all interactions.
Ability to explain technical concepts in business-friendly language to non-technical stakeholders.
Effective communication with cross-functional teams, including IT, compliance, and analytics.
Ability to mentor and train team members on database management best practices and new implementations.
Ability to exercise independent judgment and discretion and maintain confidentiality with sensitive documentation or situations.
Ability to obtain and maintain criminal record/fingerprint clearance from the Department of Justice and Federal Bureau of Investigation, per Easterseals Southern California and/or program requirements.

Nice To Haves

Certification in database administration desired, such as Oracle Certified Professional or Microsoft Certified: Azure Database Administrator Associate.
Experience with Spark, PySpark, KQL, Notebooks, and Lakehouses preferred.
Experience with Microsoft Purview preferred.
Experience in DevOps or similar environments preferred.

Responsibilities

Design, implement, and maintain database schemas that support applications and business processes.
Manage data ingestion and ETL/ELT processes for data related to the Enterprise Data Warehouse (EDW).
Ensure backup and recovery procedures are documented, reviewed against IT security, infrastructure, and compliance standards, and tested.
Serve as the primary Major Incident Management (MIM) resource for the EDW; monitor EDW users and conduct audits as requested.
Collaborate with IT Security and Compliance to follow data governance guidelines.
Monitor and optimize database performance, query execution, and system efficiency.
Implement and maintain security measures to protect sensitive data from unauthorized access or breaches.
Develop and implement backup and recovery plans to protect data integrity and availability.
Plan and execute database upgrades and patching.
Diagnose and resolve database-related issues to minimize downtime and maintain system reliability.
Lead technical sessions and projects, representing the EDW team in managing the Microsoft Fabric environment.
Maintain accurate documentation of database configurations, processes, and procedures.
Analyze data usage trends to forecast capacity needs and support scalability planning.
Collaborate with development and IT teams to provide insights and recommendations.
Ensure databases comply with relevant regulations and standards, such as GDPR, HIPAA, or PCI DSS.
Collaborate with data scientists and analysts to support advanced analytics and data-driven decision-making.
Develop and maintain data models and metadata to support data consistency and quality.
Train and support team members on database management best practices and new implementations.
Perform other duties as assigned.