About this role
Data Engineer II role focused on designing, developing, testing, documenting, and operating large-scale data structures for business intelligence analytics. You will implement ETL/ELT and OLAP solutions using SQL and Oracle, provide reporting via OBIEE, and produce metadata and dataset documentation.
Key Responsibilities
- Design and implement large-scale data structures for business intelligence analytics
- Develop ETL/ELT processes and OLAP technologies using SQL and Oracle
- Provide on-line reporting and analysis using OBIEE and a logical abstraction layer
- Produce comprehensive dataset documentation and metadata
- Own end-to-end development lifecycle including support and maintenance
Technical Overview
The role builds and operates scalable data structures and analytics layers for multi-dimensional datasets. Core technologies include ETL/ELT processes, OLAP technologies, data modeling, SQL, Oracle, and OBIEE for on-line reporting and analysis, with ownership across the full development lifecycle.
Ideal Candidate
The ideal candidate is an entry-level Data Engineer with 1+ year of experience building and operating large-scale data structures for business intelligence analytics. They are strong in ETL/ELT processes, OLAP technologies, data modeling, SQL, and Oracle, and can deliver reporting/analysis using OBIEE while producing metadata and dataset documentation.
Must-Have Skills
developing and operating large-scale data structures for business intelligence analytics using ETL/ELT processesdeveloping and operating large-scale data structures for business intelligence analytics using OLAP technologiesdeveloping and operating large-scale data structures for business intelligence analytics using data modelingdeveloping and operating large-scale data structures for business intelligence analytics using SQLdeveloping and operating large-scale data structures for business intelligence analytics using OracleBachelor's degree or Master's degree in Computer ScienceEngineeringInformation SystemsMathematicsor related field1 year of experience in the job offered or as an Operations Research AnalystDatabase Developeror related occupation
Tools & Platforms
OracleOBIEEbusiness intelligence tools
Required Skills
ETL/ELT processesOLAP technologiesdata modelingSQLOracleOBIEEbusiness intelligence analyticson-line reportingmetadatadataset documentationmulti-dimensional datasetslogical abstraction layerdata structures
Hard Skills
ETL/ELT processesOLAP technologiesdata modelingSQLOracleOBIEE business intelligence toolsdata structures for business intelligence analyticson-line reporting and analysislogical abstraction layermulti-dimensional datasetsdataset documentationmetadatafull development life cycledata pipeline developmentsource data system analysisdataset implementations evaluationpeer review decisions around dataset implementationssoftware products and tools evaluationend-to-end designimplementationand testingdocumentation and deliverysupport and maintenance
Soft Skills
requirements gatheringtranslation of requirements into solutionsmentoring junior data engineerscross-functional collaborationdecision-makingcommunication and documentation
Keywords for Your Resume
Data Engineer IIData EngineerETL/ELT processesOLAP technologiesdata modelingSQLOracleOBIEEbusiness intelligencebusiness intelligence analyticson-line reportingmulti-dimensional datasetslogical abstraction layerdataset documentationmetadatadatabase developerOperations Research Analystfull development life cycledocumentationsupportmaintenancelarge-scale data structuresMentor junior data engineersAMZ9794525CupertinoCalifornia
Deal Breakers
1 year of experience with ETL/ELT processes, OLAP technologies, data modeling, SQL, and Oracle (explicitly required), Master's degree (or acceptable Bachelor's with equivalent experience) in a related field
Get matched to jobs like this
Luna finds roles that fit your skills and career goals — no endless scrolling required.
Create a Free Profile