Role Description
Science Systems and Applications, Inc. (SSAI) is seeking a senior BI Developer / Data Engineering professional to support enterprise data initiatives for a public sector education client. The selected candidate will design, automate, support, and improve data extraction, transformation, loading, data warehouse, and data lake solutions. This position is Onshore / Remote and requires availability during Pacific Time business hours.
This role is ideal for a senior data professional with deep experience in:
-
Oracle
-
dbt
-
ETL/ELT
-
Data ingestion
-
Dimensional modeling
-
Cloud data integration
-
Data quality validation
-
Git/CI-CD deployment practices
The work supports large-scale enterprise data management and reporting needs across business customers, vendors, and internal technical teams.
Key Responsibilities:
-
Design, automate, support, and enhance sophisticated data extraction, transformation, and loading applications.
-
Develop and support Oracle database batch applications within data warehouse and data lake environments.
-
Ingest data from heterogeneous sources into on-premises or cloud data storage platforms, including environments such as Snowflake, AWS, and related cloud data services.
-
Build and manage ETL/ELT workflows using dbt, Oracle Data Integrator (ODI), Oracle PL/SQL, Oracle SQL, and shell scripting.
-
Develop dimensional hierarchies and data models to support enterprise data management reports and analytics needs.
-
Create and improve data solutions that support smooth, reliable data delivery across large volumes of data.
-
Perform data quality validation, write dbt tests, and help resolve data integrity or reporting issues.
-
Support API development frameworks and cloud-native data integration technologies as needed.
-
Support data lake migration from on-premises systems to cloud platforms.
-
Build incremental models, manage raw data layers, and develop modular dbt models for vendor/application data.
-
Convert complex Oracle stored procedures into maintainable dbt models using macros, hooks, incremental models, and modular design practices.
-
Use Git workflows, branching strategies, and CI/CD pipelines to support automated deployment of data solutions.
-
Collaborate with business customers, vendors, and internal resources to clarify requirements, resolve issues, and support successful delivery.
-
Provide weekly status updates and maintain required project/time reporting.
Qualifications
-
10+ years of demonstrated experience in BI development, data engineering, ETL/ELT, data warehouse, data lake, enterprise data management, or closely related services.
-
Strong knowledge of Oracle database development for batch applications in data warehouse or data lake environments.
-
Hands-on experience with data ingestion from multiple heterogeneous sources into on-premises and/or cloud data platforms.
-
Experience using dbt, ODI, Oracle PL/SQL, Oracle SQL, and shell scripting to manage ETL/ELT processes.
-
Experience developing dimensional hierarchies and data models for enterprise reporting.
-
Experience creating, maintaining, processing, and analyzing large data volumes.
-
Experience with data quality validation, reconciliation, and testing.
-
Knowledge or hands-on experience with API development frameworks.
-
Knowledge or hands-on experience with cloud-native data integration technologies.
-
Experience supporting data lake migration from on-premises systems to cloud platforms.
-
3+ years of experience building incremental models, handling raw data layers, and building dbt models for vendor/application data.
-
Proficiency in dbt development, including macros, hooks, incremental models, data quality tests, and model security.
-
Experience converting complex Oracle stored procedures into modular dbt models.
-
Expert-level knowledge of Git workflows, branching strategies, and CI/CD pipelines for automated deployment.
-
Strong communication skills and ability to work with business stakeholders, vendors, and technical teams.
Desired Qualifications
-
Previous experience working on LAUSD Data Lake systems or similar large education/public-sector data platforms.
-
Hands-on experience with Snowflake, AWS, or other cloud data platforms.
-
Experience with Oracle Data Integrator (ODI) in enterprise environments.
-
Experience modernizing legacy Oracle/PL SQL data processes into dbt-based models.
-
Experience supporting cloud data migration, data validation, and data reconciliation activities.
-
Experience working with vendor/application datasets and enterprise reporting requirements.
-
Strong technical problem solver with deep Oracle, dbt, ETL/ELT, data warehouse, and data lake experience.
-
Experience in Agile, DevOps, or CI/CD-enabled data delivery environments.
Physical Requirements
-
Regularly required to stand, walk, and use hands to touch, handle or feel objects, tools or controls.
-
Frequently required to talk and hear.
-
Occasionally required to reach with hands and arms and stoop, kneel, crouch, or crawl.
-
Must regularly lift and/or move up to 10 pounds, and occasionally lift and/or move up to 25 pounds.
-
Specific vision abilities required include close vision, peripheral vision, depth perception, and the ability to adjust focus.