Principal Data Engineer

SMART TECH SKILLS LLC•Tallahassee, FL

7d•Onsite

About The Position

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.

Requirements

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.

Nice To Haves

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.

Responsibilities

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