Data Engineer, Data Modeler

Essnova Solutions, Inc.

Data Engineer designing and maintaining scalable database architectures for government clients. Delivering high-impact data solutions and collaborating with technical teams and stakeholders.

Posted 5/29/2026full-timeRemote • 🇺🇸 United StatesMid-LevelSeniorWebsite

Tech Stack

Tools & technologies

AWSAzureCloudOraclePostgresPythonSQL

About the role

Key responsibilities & impact

Designing and maintaining scalable database architectures for analytical workloads, ensuring optimal performance through indexing, partitioning, caching, and query tuning.
Developing, automating, and maintaining data ingestion, transformation, validation, and loading pipelines to support high-quality data flows.
Building reusable data connection modules and backend infrastructure components to streamline data operations and support future scalability.
Supporting data preprocessing, normalization, and rigorous data quality validation processes.
Contributing to cloud migration planning, governance, and evaluation of cloud solutions for security, compliance, interoperability, and performance.
Producing comprehensive data models, architecture diagrams, flowcharts, and technical documentation for internal and external stakeholders.
Utilizing PowerShell scripting and automation to enhance data engineering workflows and system integration.
Collaborating with technical, security, and stakeholder teams throughout the project lifecycle to deliver high-impact data solutions.

Requirements

What you’ll need

Bachelor’s degree in Computer Science, Data Engineering, Information Systems, or a related field
5+ years of experience in data engineering, database administration, or data architecture
Proven experience designing and optimizing scalable database architectures for analytical workloads, including query performance tuning (indexing, partitioning, caching)
Hands-on experience building and maintaining automated data ingestion, transformation, validation, and loading pipelines
Strong SQL skills with PostgreSQL, SQL Server, Oracle, or similar relational databases
Proficiency in Python or R for data transformation, automation, or pipeline development
Experience with PowerShell scripting and automation
Experience with cloud platforms (Azure or AWS) for cloud-hosted data solutions
Knowledge of FedRAMP requirements and cloud security best practices
Proficiency using Git with documented development practices
Experience designing data models for analytics (e.g., dimensional star/snowflake and/or normalized relational models)
Experience collaborating with government program stakeholders and security/privacy personnel, and presenting technical deliverables to diverse audiences
Eligibility to obtain and maintain a Tier 4 (High-Risk) Public Trust and HSPD-12/PIV credentialing
Ability to travel approximately 10% as needed

Benefits

Comp & perks

Comprehensive health insurance coverage (medical, dental, vision)
401(k) retirement plan with company matching
Generous paid time off (PTO) and paid holidays
Remote work flexibility
Professional development and training opportunities
Supportive and inclusive team culture

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

database architecturedata ingestiondata transformationdata validationdata loading pipelinesquery performance tuningSQLPythonRdata modeling

Soft Skills

collaborationcommunicationproblem-solvingstakeholder engagementtechnical documentation

Certifications

Bachelor’s degree in Computer ScienceBachelor’s degree in Data EngineeringBachelor’s degree in Information SystemsTier 4 Public Trust eligibilityHSPD-12/PIV credentialing