Hiring: Senior Data Modeler/Architect Company: Software Methods, Incorporated Location: Philadelphia, PA Job Posted Time: 2026-09-16 21:33:47 Employment Type: Contract / Hybrid Target Skills & Keywords : AWS, Azure, Data Pipeline, Data Warehouse, Enterprise Architecture, Kafka, OCI, Oracle Cloud, Oracle Database, PL/SQL, PySpark, Python, RDS, Redshift, SAP, SQL, Snowflake, Vault, dbt About the job Experience: •20 years of hands-on experience to lead our data strategy, enterprise schema design, and database engineering roadmap. In this role, you will bridge the gap between complex business requirements and high-performance technical infrastructure. •20+ years of dedicated experience in Data Architecture, Enterprise Data Modeling, and Core Database Development. •Over 20 years of hands-on experience to lead our data strategy, enterprise schema design, and database engineering roadmap. In this role, you will bridge the gap between complex business requirements and high-performance technical infrastructure. Required Skills: •Architect and maintain conceptual, logical, and physical data models for highly complex, multi-terabyte transactional (OLTP) and analytical (OLAP) environments. •Establish, champion, and enforce enterprise-wide data modeling standards, metadata management protocols, and data governance frameworks. •Design structures that bridge traditional Oracle data warehouses with modern cloud data lakes, lakehouses, and real-time streaming platforms. •Advanced PL/SQL & Oracle Database Engineering •Author, review, and optimize highly sophisticated, mission-critical PL/SQL packages, stored procedures, triggers, and analytical functions.] •Act as the ultimate escalation point for complex database performance tuning, rewriting convoluted queries, optimizing execution plans, and managing indexing/partitioning strategies. •Lead data migration, schema refactoring, and data cleansing initiatives to safely transition heavy on-premise PL/SQL logic into highly scalable modern architectures •Technical Leadership & Collaboration Qualifications: •15+ years of extensive hands-on mastery with Oracle Database suites (Oracle 19c/21c and legacy versions) and advanced PL/SQL engineering. Interested candidates, please apply directly through the job posting on company's career page or try via AI auto apply on this platform. Don't miss this opportunity to join a forward-thinking team!