Senior Oracle Data Warehouse Developer/Lead

Job Title: Senior Oracle Data Warehouse Developer/Lead

Location: Charlotte, NC (Onsite required)

Duration: Contract - 12 months

Pay Range: $65.05/hr (W2)

Job ID: 399841

About BCforward

BCforward is a leading global IT consulting and workforce solutions firm providing services and support to Fortune 500 and government clients. Founded in 1998, BCforward has grown with our customers needs into a full-service business solutions provider. With delivery centers and offices across North America and India, we take pride in building long-term relationships and delivering excellence through innovation, collaboration, and integrity.

Job Description

We are seeking a Software Engineer / Oracle Developer (Feature Lead) to join our dynamic team starting in July. The ideal candidate will have strong experience in Oracle SQL and PL/SQL, data warehousing, ETL, and Java (Spring/Hibernate) and a proven ability to lead feature delivery, mentor offshore teams, and deliver scalable HR and finance data solutions.

Responsibilities:

• Lead feature delivery across design, development, testing, and migration of Oracle objects for HR reporting domains.
• Mentor and provide technical direction to mostly offshore developers and represent the team in status meetings.
• Develop complex ETL and data models in a data warehousing environment for FTE, headcount, and leadership reporting.
• Ensure systems design and requirements align with desired business outcomes and quality standards.
• Promote coding, testing, documentation, release procedures, and security best practices that minimize technical debt.
• Implement enterprise data quality and data protection standards.
• Act as liaison for production activities and guide work breakdown and execution.
• Oversee continuous improvement of database scalability and performance.
• Use version control tools such as Git/Bitbucket and schedule automation with Autosys.
• Advance Agile delivery with automated testing, CI, and CD; identify data anomalies and patterns in large datasets.

Required Skills & Qualifications:

• Expertise in Oracle Database platforms including SQL and PL/SQL, stored procedures, functions, triggers, and VPD security.
• 6+ years in data warehousing with efficient manipulation and transformation of millions of rows.
• Experience building ETL and data models for large data domains, preferably HR, Finance, and Real Estate.
• Proficiency with TOAD, Unix shell scripting, Autosys, Jira, and Microsoft Office Suite.
• Strong analytical, debugging, risk identification, and critical thinking skills.
• Master Data Management concepts, tools, and best practices.
• Enterprise Java with Spring and Hibernate.

Preferred Skills:

• Bachelor's degree in Computer Science, Software Engineering, or related field, or equivalent experience.
• Enterprise HR or other sensitive data domain experience and financial services or banking industry background.
• Advanced experience with Unix shell scripting, Autosys, and TOAD for Oracle.
• Working knowledge of machine learning, AI, and big data analytics; experience integrating tools such as Co‑Pilot, ChatGPT, or Claude.
• Experience with Agile Scrum, DevOps, SAFe or Disciplined Agile, and CI/CD release processes.
• Knowledge of data regulations, data management, and governance best practices.

Why BCforward?

At BCforward, we believe in advancing lives and careers. When you join our team, you gain access to:

• Competitive compensation and benefits.
• Opportunities for growth with global clients.
• A supportive, inclusive culture that values innovation and people.
• Exposure to cutting-edge technologies and projects.

About Our Commitment

BCforward is an equal opportunity employer. We value diversity and are committed to creating an inclusive environment for all employees. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, sexual orientation, gender identity, national origin, age, disability, or veteran status.

Interested? Apply Now!

If this sounds like the right opportunity for you, please apply with your most recent resume.