Senior Oracle Developer

Posted Yesterday
Be an Early Applicant
Hiring Remotely in Canada
Remote
Senior level
Software
The Role
Design, build, and maintain batch and real-time data pipelines and ETL/ELT processes using Oracle and cloud data platforms. Optimize SQL and stored procedures, ensure data quality and compliance, automate data workflows, analyze data, and mentor junior engineers.
Summary Generated by Built In
3Pillar is an AI transformation partner on a mission to help enterprises build the AI-native products and intelligent agents that will define the next era of business. With teams across North America, Europe, Latin America, and Asia, we work with the most ambitious companies in financial services, healthcare, media, and technology — helping them move faster, modernize boldly, and compete on their own terms. Our HelixAI platform and Helix Pods delivery model put our engineers at the center of real agentic transformation — doing work that is open, portable, and built to last. We are building the future of enterprise AI.
 

🌟 Accomplished Tech Visionary: 

Embark on an exciting journey into the realm of software development with 3Pillar! We extend an invitation for you to join our team and gear up for a thrilling adventure. At 3Pillar, our focus is on leveraging cutting-edge technologies that revolutionize industries by enabling data driven decision making. As a Senior Data Engineer, you will hold a crucial position within our dynamic team, actively contributing to thrilling projects that reshape data analytics for our clients, providing them with a competitive advantage in their respective industries.

If your passion for data analytics solutions that make a real-world impact, consider this your pass to the captivating world of Data Science and Engineering! 🔮🌐

Responsibilities

    Key Skills: Oracle Database, Stored Procedures, SQL Optimization, Data Analysis

    • Understanding the business requirements

    • Writing code and implementing the proposed solutions

    • Debugging, root cause analysis…

    • Creating data pipelines, versioning and change management

    • Manage the complexity inherent in versioned data pipelines

    • Develop ETL/ELT processes to help extract and manipulate data from multiple sources.

    • Design, build and maintain batch or real-time data pipelines in production.

    • Automate data workflows such as data ingestion, aggregation, and ETL processing.

    • Ensure data accuracy, integrity, privacy, security, and compliance through quality control procedures.
    • Train and mentor junior engineers.

Qualifications

    • Expert with  Oracle Database, Stored Procedures, SQL Optimization, Data Analysis

    • Debugging, Root Cause Analysis
    • Advanced Oracle SQL skills and experience with relational databases and database design.
    • Experience working with cloud-based platform of data lakehouse and ETL such as Databricks..

    • Strong Python skills with hands-on experience on Pandas, NumPy and other data related libraries

    • Experience with data visualization tools like Tableau, PowerBI, AWS QuickSight etc

    • Very good exposure of working on Data Lakes & Data Warehouses solutions

    • Excellent problem-solving, communication, and organizational skills.

Desired

    • Experience with the AWS/Azure/GCP data engineering services

      • Knowledge of AWS services viz., S3, Lambda, EMR, GLUE ETL, Athena, RDS, Redshift, EC2, IAM

      • OR

      • Knowledge of Azure services viz., ADF, Azure Synapse Analytics, ADLS Gen2, Azure SQL DB

      • Experience with Big Data technologies like Spark, Map Reduce, Hadoop, Hive

What is it like working for 3Pillar Global?

    At 3Pillar, we create an environment where people can do their best work while maintaining a healthy work-life balance.

  • Flexibility & Well-being – Our remote-first approach gives you the flexibility to work where you perform best, while prioritizing your well-being and personal commitments.
  • Global Community – Collaborate with talented colleagues across the globe in a culture built on connection, support, and shared success.
  • Your Voice Matters – We foster open communication and multiple feedback channels, ensuring every employee has the opportunity to be heard and make an impact.
  • Growth & Development – Gain exposure to diverse clients, industries, and challenges that accelerate learning and career growth.
  • Our culture is guided by four core values: Collaboration, Outperform, Respect, and Evolve—the principles that shape how we work, grow, and succeed together.

Skills Required

  • Expertise with Oracle Database, stored procedures, and SQL optimization
  • Advanced Oracle SQL skills and relational database design experience
  • Experience developing ETL/ELT processes and managing data pipelines
  • Experience with cloud-based data lakehouse platforms such as Databricks
  • Strong Python skills with hands-on experience using Pandas and NumPy
  • Experience with data visualization tools (Tableau, PowerBI, AWS QuickSight)
  • Experience working with Data Lakes and Data Warehouses
  • Debugging and root cause analysis skills
  • Excellent problem-solving, communication, and organizational skills
  • Experience with AWS/Azure/GCP data engineering services (S3, Lambda, EMR, Glue, Athena, RDS, Redshift, EC2, IAM or ADF, Azure Synapse, ADLS Gen2, Azure SQL DB)
  • Experience with big data technologies such as Spark, MapReduce, Hadoop, Hive
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Fairfax, VA
1,784 Employees
Year Founded: 2006

What We Do

3Pillar Global builds breakthrough software products that power digital businesses. 3Pillar is an innovative product development partner whose solutions drive rapid revenue, market share, and customer growth for industry leaders in Software and SaaS, Media and Publishing, Information Services, and Retail. Leveraging a lean and agile approach, 3Pillar delivers value-generating, digital solutions with specialized product strategy and management, user experience design, as well as software and data engineering expertise across mobile, cloud, and disruptive technologies.

Similar Jobs

Block Logo Block

Systems Engineer

Blockchain • eCommerce • Fintech • Payments • Software • Financial Services • Cryptocurrency
In-Office or Remote
Toronto, ON, CAN
12000 Employees
104K-156K Annually

Block Logo Block

Systems Engineer

Blockchain • eCommerce • Fintech • Payments • Software • Financial Services • Cryptocurrency
In-Office or Remote
8 Locations
12000 Employees
114K-213K Annually

Square Logo Square

Senior Ios Engineer

eCommerce • Fintech • Hardware • Payments • Software • Financial Services
Remote or Hybrid
8 Locations
12000 Employees
185K-327K Annually

Square Logo Square

Ios Engineer

eCommerce • Fintech • Hardware • Payments • Software • Financial Services
Remote or Hybrid
8 Locations
12000 Employees
264K-395K Annually

Similar Companies Hiring

Hanover Park Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
42 Employees
Kepler  Thumbnail
Fintech • Software
New York, New York
6 Employees
Onshore Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
60 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account