Software Developer 2

The Data Engineer will be responsible for managing complex data pipelines, transformations and aggregations, while adhering to SLA that impact both product and business for OCI. In addition, this specific role requires a passion for solving high-impact problems and the ability to jump into any in-flight project and get it on the rails.

Specific responsibilities for this role include:

• Create Business insights for large dataset / structured & un-structured

• Define and implement business data ingestion and analysis requirements.

• Perform data modelling and integration activities in data warehouse systems.

• Support the development of business intelligence standards to meet business goals.

• Coordinate with the business units to identify new data requirements, analysis strategies and reporting mechanisms.

• Recommend enhancements and modifications to optimize processes.

• Design, build, and maintain automated pipelines and transforms to enable our team to self-service 80% of data needs, allowing you to focus on answering hard and ambiguous problems.

• Write high-quality SQL queries to retrieve and analyze data from database tables (ex. Oracle, MySQL).

• Build scalable data solutions data sets, views, queries and scheduled processes.

• Troubleshoot code, research root causes, document solutions, and communicate to all stakeholders.

• Ensure data is within required quality standards.

• Keeps stakeholders informed about problems and resolutions. Deliver products on schedule and communicate updates regularly.

• Identify, track, and resolve data issues, working in partnership with other Data Engineers to ensure data is accurate, complete, delivered on-time and supports the needs of the business.

Basic Qualifications

• Bachelor's or higher degree in Computer Science, Information Technology or Engineering

• 3-5 years relevant experience

• Hands-on experience in SQL, Python scripting, Data Flows, Databricks notebooks, Spark, Kubernetes, TerraForm.

• Strong experience with Data Lakehouse architecture using Delta Lake for ACID transactions, schema evolution, and time travel.

• Knowledge of Delta Live Tables (DLT) and Medallion Architecture (Bronze, Silver, Gold layers) for data curation.

• Understanding of software engineering principles - version control, modular design, CI/CD, and testing frameworks.

• Hands-on experience with Data Integration service in OCI or similar services like AWS Glue, Azure Data Factory, or Apache Airflow for orchestrating and automating data pipelines.

• Solid analytical, planning, and interpersonal skills with an ability to handle competing demands.

Preferred Qualifications

• Experience with cloud services, virtualization, or SaaS products

• Self-driven problem solver able to adapt and thrive in a dynamic, ambiguous, and customer-focused environment

• Highly analytical, technically proficient, and able to learn new tools and software quickly

• Demonstrated ability to effectively communicate (oral and written) at different levels in the org

• Experience using agile software development practices and associated tooling