NEW JOB OPENING DATA ENGINEER IN IRVING, TX, USA!

Job Description
Required Education
• Bachelor's degree in Computer Science, Information Technology, or a related field

Required Qualifications/Skills/Experience
• 5-10 years of progressive experience in a data-centric development role
• Expert-level proficiency in Oracle, including advanced SQL and PL/SQL development
• Strong, hands-on experience with MongoDB, including data modeling, MQL, and the aggregation framework
• Proven experience in data modeling, with a portfolio of projects demonstrating skills in both relational and NoSQL design
• Strong analytical and problem-solving skills, with a talent for identifying and resolving complex data-related issues
• Ability to work independently and collaboratively in a fast-paced, agile environment

Preferred Qualifications/Skills/Experience
• Experience with data modeling tools such as Erwin, ER/Studio, or Lucidchart
• Knowledge of cloud database services (e.g., Oracle Cloud, MongoDB Atlas, AWS RDS)
• Proficiency in a scripting language like Python or Bash for automation
• Experience with ETL tools (e.g., Informatica, Talend, SSIS)
• Familiarity with version control systems, particularly Git
• Experience in the financial services or banking industry is a plus

Data Engineer Overview:
We are seeking a highly experienced Data Engineer to join our technology team. With 5-10 years of experience, the ideal candidate will be an expert in designing and developing data solutions across both Oracle (relational) and MongoDB (NoSQL) environments. This role is a hybrid of data modeling and hands-on development, requiring a deep understanding of how to structure data effectively and the technical skills to build, optimize, and maintain the database code that interacts with it. You will be a key player in ensuring our data architecture is robust, scalable, and perfectly aligned with our application and business needs.

Job Duties
• Design, develop, and maintain conceptual, logical, and physical data models for both Oracle and MongoDB platforms
• Translate complex business requirements into efficient and scalable relational (Oracle) and document-based (MongoDB) data structures
• Create and manage data dictionaries, ensuring clear documentation of data elements, relationships, and lineage
• Develop complex and efficient SQL, PL/SQL packages, stored procedures, functions, and triggers in an Oracle environment
• Write sophisticated queries, including complex joins, subqueries, and analytical functions to support application logic
• Develop and optimize queries and aggregation pipelines in MongoDB (MQL) to support high-performance application features
• Proactively monitor, analyze, and optimize database performance in both Oracle and MongoDB
• Analyze query execution plans, create appropriate indexes, and refactor code to ensure optimal efficiency and response times
• Work closely with application developers to guide them on best practices for database interaction and query writing
• Design and build ETL processes and data pipelines for moving and transforming data between Oracle, MongoDB, and other enterprise systems
• Ensure the integrity, consistency, and security of data across all platforms
• Assist with data migration strategies and execution

#CT1

• **Only those lawfully authorized to work in the designated country associated with the position will be considered.**

• **Please note that all Position start dates and duration are estimates and may be reduced or lengthened based upon a client's business needs and requirements.**

Benefits:
For information and details on employment benefits offered with this position, please visit here . Should you have any questions/concerns, please contact our HR Department via our secure website .

California Pay Equity:
For information and details on pay equity laws in California, please visit the State of California Department of Industrial Relations' website here .

Rose International is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, sexual orientation, gender (expression or identity), national origin, arrest and conviction records, disability, veteran status or any other characteristic protected by law. Positions located in San Francisco and Los Angeles, California will be administered in accordance with their respective Fair Chance Ordinances.

If you need assistance in completing this application, or during any phase of the application, interview, hiring, or employment process, whether due to a disability or otherwise, please contact our HR Department .

Rose International has an official agreement (ID #132522), effective June 30, 2008, with the U.S. Department of Homeland Security, U.S. Citizenship and Immigration Services, Employment Verification Program (E-Verify). (Posting required by OCGA 13/10-91.).