Sign upLog in

Oracle BI Developer

Talent & Acquisition LLC., d/b/a Stand 8

Los Angeles, CA(remote)

Apply
JOB DETAILS
SALARY
$72–$88 Per Hour
SKILLS
ADP, Amazon Web Services (AWS), Analysis Skills, Application Programming Interface (API), Automation, Business Intelligence, Cloud Computing, Communication Skills, Continuous Deployment/Delivery, Continuous Integration, Customer Experience, Data Lake, Data Management, Data Migration, Data Modeling, Data Quality, Data Sets, Data Storage, Data Warehousing Applications, Database Extract Transform and Load (ETL), Employee Assistance Plan, Git, Marketing, Model Validation, Oracle, Oracle Database, Oracle PL-SQL, Process Management, Scalable System Development, Security Monitoring, Stored Procedures, Test Plan/Schedule, Unix Shell Programming, Writing Skills
LOCATION
Los Angeles, CA
POSTED
Today
Job Title: Oracle BI Developer

Location: Remote must be available to work PST hours

Overview:
STAND 8 provides end to end IT solutions to enterprise partners across the United States and with offices in Los Angeles, New York, New Jersey, Atlanta, and more including internationally in Mexico and India.

The Oracle BI Developer will design, automate, and support data extraction, transformation, and loading applications across data warehouse and data lake environments. This role will support data ingestion, ETL development, data modeling, validation, and cloud-based data integration. The position requires strong Oracle database knowledge, DBT development experience, and the ability to build scalable data solutions that support enterprise reporting and analytics needs
Qualifications & Responsibilities
  1. Design, automate, and support sophisticated data extraction, transformation, and loading (ETL) applications.
  2. Demonstrate strong knowledge of Oracle databases for batch application development within data warehouse and data lake environments.
  3. Perform data ingestion from heterogeneous data sources into both on-premises and cloud-based data storage platforms, including but not limited to Snowflake and AWS.
  4. Manage ETL processes using DBT, ODI, Oracle PL/SQL, Oracle SQL, and Shell Scripting.
  5. Develop dimensional hierarchies and design data models that support multiple Enterprise Data Management reports. Work closely with business stakeholders, vendors, and internal teams to facilitate communication and achieve project objectives.
  6. Create and improve data solutions that enable efficient data delivery and support the gathering, processing, maintenance, and analysis of large-scale datasets.
  7. Perform and support data quality validation processes.
  8. Possess knowledge and experience with API development frameworks.
  9. Demonstrate knowledge and experience with cloud-native data integration technologies.
  10. Have experience migrating data lakes from on-premises systems to cloud platforms.
  11. Previous experience working on LAUSD Data Lake systems is required.
  12. Minimum of three years of experience building incremental models, handling raw data layers, and developing DBT models for LAUSD vendors and applications.
  13. Demonstrate proficiency in DBT (Data Build Tool) development, including experience with macros, hooks, and incremental models, as well as experience converting complex Oracle stored procedures into modular DBT models.
  14. Ability to write DBT tests for data quality validation and manage security for DBT models.
  15. Expert-level knowledge of Git workflows, including implementing branching strategies and establishing CI/CD pipelines for automated deployment processes.
  16. 10+ years of experience in the field
Benefits
  • Medical coverage and Health Savings Account (HSA) through Anthem
  • Dental/Vision/Various Ancillary coverages through Unum
  • 401(k) retirement savings plan
  • Paid-time-off options
  • Company-paid Employee Assistance Program (EAP)
  • Discount programs through ADP WorkforceNow
Additional Details
The base range for this contract position is $72 – $88 / per hour, depending on experience. Our pay ranges are determined by role, level, and location. The range displayed on each job posting reflects the minimum and maximum target for new hires of this position across all US locations. Within the range, individual pay is determined by work location and additional factors, including job-related skills, experience, and relevant education or training. Qualified applicants with arrest or conviction records will be considered.

About Us
STAND 8 provides end-to-end IT solutions to enterprise partners across the United States and globally with offices in Los Angeles, Atlanta, New York, Mexico, Japan, India, and more. STAND 8 focuses on the “bleeding edge” of technology and leverages automation, process, marketing, and over fifteen years of success and growth to provide a world-class experience for our customers, partners, and employees.
Our mission is to impact the world positively by creating success through PEOPLE, PROCESS, and TECHNOLOGY.
Check out more at www.stand8.io; and reach out today to explore opportunities to grow together!
By applying to this position, your data will be processed in accordance with the STAND 8 Privacy Policy.

About the Company

T

Talent & Acquisition LLC., d/b/a Stand 8

Resume Resources

Free Resume TemplatesFree Resume Builder