Data Engineer PL - SQL

Confiz is seeking a Data Engineer with deep PL/SQL expertise to join a client-facing data environment built on a hybrid architecture spanning Oracle, SQL Server, and SQL Server Analysis Services (SSAS). The engineer will be responsible for developing and maintaining data pipelines, reporting solutions, and web-based dashboards across this multi-platform environment. The role requires hands-on reporting experience with SSRS and Oracle APEX, and comfort operating within a governed CI/CD delivery process using Bitbucket and TeamCity. 

Responsibilities 

• Design, develop, and optimize PL/SQL stored procedures, functions, packages, and triggers in Oracle 

• Build and maintain ETL/data pipelines and transformation logic across Oracle and SQL Server environments 

• Develop and support multidimensional and tabular models in SQL Server Analysis Services (SSAS) 

• Create and maintain parameterized, scheduled, and ad-hoc reports using SQL Server Reporting Services (SSRS) 

• Build web-based reporting applications and dashboards using Oracle APEX 

• Manage and version database objects, reports, and application code through Bitbucket 

• Work within CI/CD pipelines via TeamCity, including build configuration, deployments, and environment promotions 

• Collaborate with architects, analysts, and business stakeholders to translate requirements into data solutions 

• Conduct code reviews and contribute to technical documentation and best practices 

• Troubleshoot performance issues across queries, data models, and reporting layers 

Requirements 

• 5+ years of hands-on PL/SQL development experience (stored procedures, packages, triggers, cursors) 

• Strong proficiency in T-SQL and SQL Server for data transformation and reporting 

• Experience designing and optimizing ETL/ELT pipelines in hybrid Oracle and SQL Server environments 

• Hands-on experience with SQL Server Analysis Services (SSAS), tabular or multidimensional models 

• Practical experience developing SSRS reports, including parameterization, subscriptions, and drill-through 

• Experience with Oracle APEX for building data-driven web applications and dashboards 

• Proficiency with Git-based source control, specifically Bitbucket 

• Familiarity with CI/CD principles and working within TeamCity or equivalent deployment pipelines 

• Strong understanding of relational data modeling, normalization, and schema design 

We have a global team of amazing individuals working on highly innovative enterprise projects & products. Our customer base includes Fortune 100 retail and CPG companies, leading store chains, fast growth fintech, and multiple Silicon Valley startups.

What makes Confiz stand out is our focus on processes and culture. Confiz is ISO 9001:2015 (QMS), ISO 27001:2022 (ISMS), ISO 20000-1:2018 (ITSM) and ISO 14001:2015 (EMS) Certified. We have a vibrant culture of learning via collaboration and making workplace fun.

People who work with us work with cutting-edge technologies while contributing success to the company as well as to themselves. 

To know more about Confiz Limited, visit https://www.linkedin.com/company/confiz/