Data Engineer, Data Modeler

🕒 May 29

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Essnova Solutions, Inc.

WebsiteLinkedInAll Job Openings

11 - 50 employees

Founded 2005

🏛️ Government

🔒 Cybersecurity

🤖 Artificial Intelligence

Government • Cybersecurity • Artificial Intelligence

Essnova Solutions, Inc. is a technology and professional services firm that provides IT solutions, value‑added reseller (VAR/ITVAR) services, geospatial and environmental solutions, staff augmentation and healthcare support, and digital citizen/customer experience services to federal, state & local governments, education, commercial, and healthcare clients. The company is a certified 8(a) and HUBZone small business with multiple GSA contracting vehicles and focuses on cloud migration, big data and AI, information and cybersecurity, program and project management, and end‑to‑end technology implementation and support.

📋 Description

• 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

• 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

• 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