EDW Data Engineering (100% Remote) W2 only- Must have Education Domain exp

Responsibilities:

Data Architecture & Engineering

• Design, build, and maintain enterprise data platforms including data warehouses, data marts, operational data stores, and data lakes
• Develop scalable, secure cloud and hybrid solutions using Oracle Cloud Infrastructure (OCI) and related technologies
• Create and maintain logical and physical data models for analytics and reporting
• Architect robust data ingestion and transformation pipelines for structured and semi-structured data
• Establish enterprise data standards, governance practices, and metadata management processes
• Optimize large-scale data environments through performance tuning, indexing, and partitioning strategies
• Support modernization initiatives transitioning legacy systems to cloud-based architectures

Data Integration & ETL/ELT

• Design and manage ETL/ELT pipelines using tools such as Oracle Integration Cloud (OIC), SnapLogic, SSIS, and SQL-based technologies
• Develop reusable integration components, workflows, and automation frameworks
• Integrate enterprise systems including ERP, HCM, SIS, CRM, and third-party platforms
• Build APIs and data integrations using REST, SOAP, SFTP, and event-driven architectures
• Ensure data quality, validation, and reconciliation across all pipelines
• Troubleshoot and resolve complex integration and performance issues

Analytics & Business Intelligence

• Support analytics initiatives using Power BI, Oracle Analytics Cloud (OAC), and similar platforms
• Develop curated datasets, semantic models, and reporting structures
• Translate business requirements into scalable data and reporting solutions
• Enable self-service analytics while maintaining governance and security standards
• Contribute to KPI development, dashboards, and executive reporting

Cloud Platform & Data Operations

• Administer and support Oracle Cloud Infrastructure for data and analytics workloads
• Manage cloud storage, compute, networks, and databases
• Monitor data pipelines, integrations, and system performance
• Implement security protocols, including encryption, backups, and disaster recovery
• Participate in architecture reviews, capacity planning, and performance optimization

Collaboration & Leadership

• Partner with cross-functional teams to deliver data solutions aligned to business needs
• Provide mentorship and technical guidance to junior team members
• Participate in code reviews, architecture discussions, and standards development
• Maintain documentation including data dictionaries, workflows, and technical designs
• Contribute to Agile, DevOps, and CI/CD practices

Required Skills:

• Bachelor s degree in Computer Science, Information Systems, Data Engineering, or a related field (or equivalent experience)
• 8+ years of experience in data engineering, data warehousing, ETL/ELT development, or related areas
• Strong experience with enterprise data warehouses, operational data stores, and cloud-based analytics platforms
• Expertise in hybrid cloud and on-prem data ecosystems
• Proficiency in SQL, data modeling, and database optimization
• Experience with Oracle or SQL Server technologies and integration platforms
• Knowledge of enterprise integration patterns and data lifecycle management
• Familiarity with cloud platforms such as OCI and tools like SnapLogic, OIC, and SSIS
• Experience with BI tools such as Power BI or Oracle Analytics Cloud
• Understanding of Agile, SDLC, and DevOps practices
• Strong problem-solving, communication, and stakeholder management skills