BI Developer - Level III

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., * 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.

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, and Git/CI-CD deployment practices. The work supports large-scale enterprise data management and reporting needs across business customers, vendors, and internal technical teams., * 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., * 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.