Principal Oracle IT Data Engineer

Join ABC Fitness and become part of a culture that’s as ambitious as it is authentic. Let’s transform the future of fitness—together! Our Values Best Life We believe great work begins with great people. That’s why our culture is built on respect, trust, and belonging. We create an inclusive environment where every team member can bring their authentic self to work—because diverse perspectives drive innovation and meaningful impact. Growth Mindset We are doers, thinkers, and dreamers. At ABC Fitness, your growth is our investment. Through continuous learning, mentorship, and professional development opportunities, we empower you to reach new heights—personally and professionally. One Team From day one, you’ll be part of a team that collaborates, celebrates, and cares. We move fast, support one another, and have fun along the way. Because when you thrive, we all thrive. RESPONSIBILTIES: Design, develop, test, implement, and maintain PL/SQL code, UNIX scripts, Views for reporting and other needs. Versioning and ETL changes as per the requirements, experience with a variety of transformations like Aggregate, Derived Column, Conditional Split and Data Conversion, Transaction, Checkpoints, SSIS Package Management, Debugging, Error handling and logging, SSIS Package deployment etc. Design and develop solutions using SQL and PL/SQL with DBLinks from heterogeneous data sources. Create/Modify complex and large queries, writing/modifying stored procedures, functions, implementing error handling logic, performance tuning and query optimization, bug fixing, data auditing and Production Job monitoring. Create/Modify tables, keys and indexes Perform sequel tuning, use SQL Plans and AI tools to identify bottleneck in performance. Strong concepts of Data Warehousing, strategies for ETL. Work closely with different teams for manual processes as well as resolving issues. Troubleshoot data and workflow issues within the data warehouse, as well as transactional databases Work closely with team members, DBAs, and business analysts to implement a sound solution, while adhering to agile methodology and lean integration techniques Automate and monitor jobs, rectifying issues within a timely manner ensuring SLAs are met Logical and physical database design following best practices and standards Work efficiently to resolve production support issues, escalating issues as needed. Maintain proficiency in a variety of computer programming languages, such as SQL, PL/SQL, Unix shell scripting, in order to successfully complete the tasks of the role. Provide documentation of new processes, as well as update and maintain existing documentation as needed. QUALIFICATIONS: Typically, 8+ years’ of programming experience using Oracle SQL and PL/SQL. Minimum 5 years’ of programming experience using scripting. Experience with Oracle Scheduler, UNIX Crontab and OEM. Experience using both Oracle Transactional Database and Oracle Datawarehouse. Bachelor’s degree in Information Technology or related field from an accredited college or university. In depth knowledge of relational database systems, specifically Oracle Minimum 2-3 years Data Warehousing experience. AND IT'S GREAT TO HAVE: Hands-on experience with gathering business requirements, documenting the reporting and analysis specifications, designing technical architecture, installing and configuring all components of an ETL tool, creating complex mappings, sessions, and workflows. Demonstrates sound understanding of development methodology. Experience developing using Oracle APEX Proficient in a variety of computer programming languages, such as SQL, PL/SQL, Unix shell Scripting, to successfully complete the tasks of the role. In-depth knowledge of relational database systems. Update and maintain Entity Relational Diagrams as required. Able to set and achieve standards, goals, and objectives with minimal supervision. Ability to clearly prove value to the company and achieve profitable results. Ability to fit, mold, and adapt within the dynamics of multi-functional, self-directed workgroups. Ability to encourage and assist peers in reaching their individual and team-oriented goals and objectives. Effectively convey the needs of our products to vendors and prospective suppliers. The ability to effectively convey the capabilities and limitations of equipment, hardware, drivers, etc. to ABC Developers, Business Analysts, and other internal staff. Ability to write reports that effectively convey information in concise, readable terms. Ability to effectively present ideas and solutions to small or large audiences of customers, clients, vendors, suppliers, managers, and other stakeholders. Able to relate to both technical and non-technical users. Build and foster positive interpersonal rapport with internal and external stakeholders. Ability to discern when the business goals and objectives of others might take precedence over assigned goals and objectives. Must be able to identify problems based on subtle indicators. Must be able to develop options to solve problems in a timely manner and apply logic and reasoning to determine and implement optimum solutions. Ability to solve problems using deductive reasoning skills in a timely manner Flexibility and adaptability to frequent change Please note that the salary information shown below is a general guideline only and based on employees in the United States and may be different in other countries. Salaries are based upon candidate experience, qualifications, and location, as well as market and business considerations. Our pay range for US based candidates for this position is $120,000 - $142,000 Dollars annually. Your recruiter can share more about the specific salary range for the job location during the hiring process. Also, certain positions are eligible for additional forms of compensation such as bonuses and commissions. Please note that the salary information shown below is a general guideline only and based on employees in the U.S and may be different in other countries. Salaries are based upon candidate experience, qualifications, and location, as well as market and business considerations. Our pay range for U.S based candidates for this position isannually. Your recruiter can share more about the specific salary range for the job location during the hiring process. Also, certain positions are eligible for additional forms of compensation such as bonuses and commissions.WHAT’S IN IT FOR YOU: Purpose led company with a Values focused culture – Best Life, One Team, Growth Mindset Time Off – with our open PTO policy, we offer flexibility in how and when you take PTO! Days of Disconnect – once a quarter, we take a collective breather and enjoy a day off together around the globe. #oneteam Parental & Pawternity Leave – we offer leave for when your family grows by two feet or four paws! Best Life Perk – we are committed to meeting you wherever you are in your fitness journey with a quarterly reimbursement Medical/Dental/Vision coverage EAP – we get you help when you need it. Period. Premium Calm App – enjoy tranquility with a Calm App subscription for you and up to 4 dependents over the age of 16 And more! – so many benefits we couldn’t even fit them all here! At ABC Fitness, we don’t just build technology—we build communities and transform lives. Your work matters here, your growth is supported, and your voice is heard. We welcome diverse talent and encourage you to apply, even if you don’t meet every requirement. ABC’S COMMITMENT TO DIVERSITY, EQUALITY, BELONGING AND INCLUSION: ABC is an equal opportunity employer committed to diversity, equity, and inclusion. We strive to create a workplace where every employee, client, and partner feels valued, inspired, and empowered to reach their full potential. For us, inclusion isn’t just the right thing to do—it’s a business imperative. Learn more at abcfitness.com About ABC Fitness ABC Fitness is the #1 software provider for fitness businesses of any size, all around the world. Supporting 30K clubs, 650K coaches, 40M members, and processing more than $12B in payments every year, ABC Fitness provides scalable, data-driven solutions to simplify club management and engage members and clients. From personal trainers, boutique studios, and gyms, to international franchise health clubs, ABC Fitness will move your business forward through technology and industry insights. Innovation is at the center of everything we do, across ABC Glofox, ABC Ignite, ABC Trainerize, and ABC Evo. Let's make your fitness vision a seamless reality, together. Learn more at abcfitness.com #LI-REMOTE Apply To This Job