Principal Data Engineer

The Data Architect / Data Engineer will be responsible for designing, developing, and supporting enterprise data platforms and solutions across multiple database environments. This role focuses on data architecture, data modeling, data quality, data migration, integration, governance, performance optimization, and cloud-based data services. The ideal candidate combines strong database expertise with modern data platform knowledge and an understanding of emerging AI and analytics technologies., Data Architecture & Modeling

• Design and maintain enterprise data architectures, logical and physical data models.
• Develop scalable data solutions supporting complex business applications and reporting needs.
• Define data standards, governance frameworks, and data lifecycle processes.
• Translate business requirements into effective data architectures and solutions.

Database Development & Administration

• Design, develop, administer, and optimize databases using MySQL, Oracle, SQL Server, Azure SQL, and related technologies.
• Develop and optimize SQL queries, stored procedures, views, and database objects.
• Perform schema design, indexing, query optimization, performance tuning, and capacity planning.
• Ensure database security, integrity, reliability, and availability.

Data Quality & Governance

• Establish and maintain enterprise data quality standards and controls.
• Perform data profiling, validation, cleansing, reconciliation, and integrity checks.
• Develop data quality monitoring processes and reporting mechanisms.
• Support enterprise data governance and compliance initiatives.

Data Integration & Migration

• Design and support ETL/ELT processes and enterprise data integration solutions.
• Develop and maintain APIs, middleware integrations, and data exchange services.
• Support data migration, conversion, and synchronization efforts across platforms.
• Integrate data between enterprise applications, databases, and cloud services.

Cloud & Modern Data Platforms

• Design and support cloud-based data solutions using:
• Microsoft Azure
• AWS
• Oracle Cloud
• Support data lakes, data warehouses, cloud databases, and modern analytics environments.
• Optimize cloud-based data architectures for scalability, performance, and cost efficiency.

Security, Compliance & Risk Management

• Implement database security controls, access management, and governance policies.
• Ensure compliance with cybersecurity, privacy, and regulatory requirements.
• Protect enterprise data through monitoring, auditing, and security best practices.

AI & Emerging Technologies

• Support initiatives involving:
• Artificial Intelligence (AI)
• Machine Learning (ML)
• Generative AI
• Large Language Models (LLMs)
• Retrieval-Augmented Generation (RAG)
• Intelligent Document Processing
• Vector Databases
• NoSQL Databases
• Embeddings and AI-ready Data Architectures
• Evaluate opportunities to modernize enterprise data platforms using emerging technologies.

• Strong experience designing and supporting enterprise data solutions.
• Experience with data architecture, data modeling, and enterprise data management.
• Extensive experience with:
• MySQL
• Oracle
• SQL Development
• Database Administration
• Performance Tuning
• Experience implementing data quality management and governance practices.
• Experience with ETL/ELT, data migration, and integration projects.
• Experience developing APIs and supporting enterprise integrations.
• Experience with Azure DevOps, GitHub, Oracle SQL Developer, or comparable tools.
• Knowledge of database security, access controls, and compliance requirements.
• Strong written and verbal communication skills.

Preferred Qualifications

• Experience with Microsoft SQL Server and Azure SQL.
• Experience supporting cloud-native data architectures.
• Experience with AWS, Azure, and Oracle Cloud services.
• Experience with enterprise data warehouse and data lake implementations.
• Experience with NoSQL and vector database technologies.
• Experience supporting AI/ML, Generative AI, and RAG initiatives.
• Experience supporting large-scale enterprise data migration programs.

Core Skills

• Data Architecture
• Data Modeling
• Data Governance
• Data Quality Management
• Data Profiling
• Data Validation
• Data Cleansing
• Data Reconciliation
• Data Migration
• ETL / ELT
• SQL Development
• MySQL
• Oracle Database
• SQL Server
• Azure SQL
• Database Administration
• Performance Tuning
• API Integration
• JSON / XML
• Azure DevOps
• GitHub
• Azure Data Services
• AWS Data Services
• Oracle Cloud
• Data Warehousing
• Data Lakes
• NoSQL Databases
• Vector Databases
• Artificial Intelligence (AI)
• Machine Learning (ML)
• Generative AI
• LLMs & RAG
• Database Security
• Cloud Data Architecture