Lead Data Engineer | Racedog Technologies | Charlotte, NC

RaceDog Technologies; Charlotte (NC); On-site; USD 140,000 - 190,000; Full time

Job summary

RaceDog Technologies seeks a Lead Data Engineer to lead enterprise data warehousing, ETL, and Oracle RDBMS optimization in Charlotte, NC. This on-site role requires 12+ years in data engineering and a proven track record architecting robust data pipelines and scalable data models.

You will mentor engineers, set coding standards, partner with data scientists and analysts, and drive performance tuning, data quality, and governance across critical data stores.

Qualifications

• 12+ years of professional data engineering experience in complex enterprise environments.
• Deep expertise in Oracle RDBMS architecture, database administration, and performance tuning.
• Mandatory advanced technical proficiency in SQL and PL/SQL programming for complex data transformations.

Responsibilities

• Lead design of scalable ETL pipelines and data warehouses.
• Optimize Oracle environments, schemas, and partitioning strategies.
• Develop and tune complex SQL queries and PL/SQL packages for max speed.
• Ensure data quality, lineage, governance, validation, and integrity across data stores.
• Collaborate with data scientists, BI analysts, and developers for analytics and reporting.
• Mentor junior engineers and establish architectural best practices.
• Create data architecture blueprints, ETL runbooks, and schema diagrams.

Skills

Oracle RDBMS

SQL

PL/SQL

ETL pipelines

Informatica

Talend

Apache Airflow

Cloud storage

Data modeling

Performance tuning

Education

Bachelor’s degree in Computer Science or related field

Tools

Informatica

Talend

Apache Airflow

Oracle RDBMS

Job description

Position Summary

We are seeking an exceptionally skilled and experienced Lead Data Engineer to join our enterprise data architecture team on a full-time onsite basis in Charlotte, NC, via Racedog Technologies. In this critical data engineering leadership role, you will be responsible for designing high-performance data pipelines, architecting enterprise data warehouses, and ensuring uncompromising database reliability. The ideal candidate will bring 12+ years of professional data engineering experience, deep mastery in Oracle RDBMS, advanced SQL, PL/SQL, and modern big data processing frameworks. If you possess a distinguished background in enterprise data architecture and database optimization, we invite you to apply.

Detailed Job Description

As a Lead Data Engineer in Charlotte, NC via Racedog Technologies, you will serve as a principal technical authority responsible for directing enterprise data warehousing and complex ETL pipeline development. Your daily responsibilities will encompass architecting robust data models, writing and optimizing complex Oracle SQL and PL/SQL queries, managing database performance tuning, and leading data engineering squads. You will collaborate closely with data analysts, data scientists, and business stakeholders. Candidates are required to submit their updated resume via email to Raju Varma at [e-mail].

Key Responsibilities

• Architect, design, and implement scalable enterprise data pipelines, ETL/ELT workflows, and data warehousing solutions.
• Manage and optimize mission-critical Oracle RDBMS environments, database schemas, tablespaces, and partitioning strategies.
• Write, tune, and optimize complex SQL queries, stored procedures, triggers, and PL/SQL packages for maximum execution speed.
• Ensure uncompromising data quality, lineage, governance, validation, and integrity across enterprise data stores.
• Collaborate proactively with data scientists, BI analysts, and software developers to support analytical and operational reporting.
• Implement robust automated testing, monitoring, and error-handling mechanisms for batch and streaming data pipelines.
• Enforce enterprise security standards, data masking, encryption, and access control policies within database systems.
• Conduct capacity planning, index maintenance, and database performance troubleshooting.
• Mentor junior and mid-level data engineers, establishing coding standards and architectural best practices.
• Author comprehensive data architecture blueprints, ETL runbooks, database schema diagrams, and technical specifications.

Required Qualifications & Skills

• Bachelor’s degree in Computer Science, Data Engineering, Information Technology, or a related discipline.
• Minimum of 12+ years of professional data engineering experience in complex enterprise environments.
• Deep specialized expertise in Oracle RDBMS architecture, database administration, and performance tuning.
• Mandatory advanced technical proficiency in SQL and PL/SQL programming for complex data transformations.
• Strong practical experience building ETL pipelines using modern data integration tools (Informatica, Talend, Apache Airflow) and cloud storage.
• Outstanding analytical problem-solving, data modeling, and cross-functional communication capabilities.
• Mandatory residency/work authorization: Ability to operate fully onsite in Charlotte, NC.

Nice-to-Have Skills

• Professional certifications such as Oracle Database SQL Certified Expert or AWS Certified Data Analytics.
• Prior professional experience working within tier-1 financial institutions or banking corporations in Charlotte.
• Familiarity with cloud data platforms (Snowflake, Databricks, AWS Redshift).
• Immediate availability for onsite mobilization in Charlotte.

Application Information

• Salary/Rate: Competitive market rate
• Deadline: Immediate
• Notice Period: Immediate to 30 Days
• Contract Duration: Full Time / Permanent

Recruitment Pro Tip

When applying for this Lead Data Engineer position with Racedog Technologies, ensure your resume explicitly highlights your Oracle RDBMS expertise, your advanced SQL/PL/SQL optimization portfolio, and your enterprise ETL leadership background.