Data Engineer (W2 Contract)

Hiring,
Greetings from Modern Agile Technologies.

Position: Data Engineer

Location: Dallas,, TX (Onsite)

Type: Contract (W2 Only)

Required skills:
• 10+ years of experience in data architecture, data modeling, or database engineering, including prior experience as a senior/lead data modeler, solution architect or data architect.
• Deep, hands-on expertise with Erwin Data Modeler at an enterprise scale (model mart, subject areas, complex compare/merge, versioning across large teams).
• Strong expertise in Oracle Database (on-premises), including advanced SQL/PL-SQL, schema design, partitioning, indexing strategy, and performance tuning at the architectural level.
• Demonstrated experience architecting and modeling for large data volumes (GB to multi-TB scale) with a track record of designs that scaled successfully in production.

We are seeking a Data Architect to own the strategic design and governance of our enterprise data landscape, built on Oracle on-premises database platforms and modeled using Erwin. This role sits above individual project data models: you will define the enterprise-wide data architecture, standards, and target operating model that all data modelers, engineers, and DBAs build against, while personally handling the highest-complexity, highest-volume modeling and architecture decisions across the organization. You will bring proven experience architecting for large-scale data volumes (multi-GB to multi-TB), regulated environments, and the performance, scalability, and integrity demands that come with them.

Nice to have skills:
• Experience in a regulated industry (utilities, financial services, insurance, healthcare) with associated data governance and compliance obligations.
• Experience leading or mentoring a team of data modelers/architects.
• Previous experience working with PostGres and MongoDB and big plus.
• Familiarity with complementary data modeling tools such as ER/Studio, Power Designer, Collibra, Alation
• Exposure to hybrid on-prem/cloud data strategies, even where the primary platform remains Oracle on-premise.
• Experience with Target Operating Model (TOM) design for data functions.
• Relevant certifications (OCI, DAMA, CDMP, etc.) is a plus.
• Experience with Hadoop/MongoDB is a plus
• Working experience with Denodo is a plus