Data Engineer / Data Modeler

Essnova Solutions, Inc.; United States; Remote; USD 100,000 - 130,000; Full time

Benefits offered by this job

Comprehensive health insurance coverage

401(k) retirement plan with company matching

Generous paid time off (PTO)

Remote work flexibility

Professional development opportunities

Job summary

Essnova Solutions, Inc. is seeking a Data Engineer / Data Modeler to design and maintain robust data architectures for analytics. You will ensure high-quality data flows and collaborate closely with teams to support government programs within the healthcare, geospatial, and environmental sectors.

The ideal candidate has a Bachelor's degree in a related field and 5+ years of experience in data engineering, with strong SQL skills and knowledge of cloud platforms. Comprehensive benefits include health insurance, retirement plans, and professional development opportunities.

Qualifications

• 5+ years of experience in data engineering, database administration, or data architecture.
• Proven experience designing scalable database architectures and performance tuning.
• Hands-on experience with automated data ingestion and pipeline development.

Responsibilities

• Design and maintain scalable database architectures for analytical workloads.
• Develop and maintain data ingestion, transformation, validation, and loading pipelines.
• Collaborate with stakeholders and technical teams to deliver data solutions.

Skills

Data ingestion

Database optimization

SQL skills

Python or R proficiency

Cloud platforms experience

Education

Bachelor’s degree in Computer Science, Data Engineering, or related field

Tools

PostgreSQL

SQL Server

Oracle

Azure

AWS

Job description

Essnova Solutions, Inc. is an SBA 8(a) and HUBZone‑certified small business delivering technology and professional services to government clients, with a focus on healthcare, geospatial, and environmental solutions. As a Data Engineer / Data Modeler, you will play a pivotal role in designing and maintaining robust data architectures that enable large‑scale analytics and support mission‑critical government programs. You will collaborate closely with technical teams, security experts, and stakeholders to ensure data solutions are secure, scalable, and compliant with federal standards.

Key Responsibilities

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

Required Qualifications

• 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

Preferred Qualifications

• Hands‑on experience with Azure Data Factory and at least two of the following: Azure SQL, Azure Blob Storage, Azure Functions
• Active Public Trust clearance

Benefits

• 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