Data Engineer/Developer

Software Guidance & Assistance, Inc., (SGA), is searching for an Data Engineer/Developer for a RIGHT TO HIRE assignment with one of our premier Banking clients in Irving, TX.

Responsibilities :



Data Modeling and Design:

• 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.

Database Development:

• 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.

Performance Tuning and Optimization:

• Proactively monitor, analyze, and optimize database performance in both Oracle and MongoDB.
• nalyze 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.

Data Integration and Management:

• 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.
• ssist with data migration strategies and execution.

Required Skills :

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• 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.
• bility to work independently and collaboratively in a fast-paced, agile environment.

Preferred Skills :

• 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.

SGA is a technology and resource solutions provider driven to stand out. We are a women-owned business. Our mission: to solve big IT problems with a more personal, boutique approach. Each year, we match consultants like you to more than 1,000 engagements. When we say let's work better together, we mean it. You'll join a diverse team built on these core values: customer service, employee development, and quality and integrity in everything we do. Be yourself, love what you do and find your passion at work. Please find us at .


SGA is an Equal Opportunity Employer and does not discriminate on the basis of Race, Color, Sex, Sexual Orientation, Gender Identity, Religion, National Origin, Disability, Veteran Status, Age, Marital Status, Pregnancy, Genetic Information, or Other Legally Protected Status. We are committed to providing access, equal opportunity, and reasonable accommodation for individuals with disabilities in employment, and our services, programs, and activities. Please visit our company EEO page to request an accommodation or assistance regarding our policy.