Data Engineer / Data Modeler

1 month, 3 weeks ago
Full-time
Senior
Software Development
Essnova

Essnova

Essnova is a mature small business providing a broad range of technology and programmatic support services to governmental and commercial customers. Specializing in SETA Services, Geospatial, Environmental, and Medical Services, Essnova offers highly e...

Internet Software & Services
11-50
Founded 2005

Description

  • Design and maintain scalable database architectures for analytical workloads.
  • Optimize database performance through indexing, partitioning, caching, and query tuning.
  • Develop, automate, and maintain data ingestion, transformation, validation, and loading pipelines.
  • Build reusable data connection modules and backend infrastructure components to support scalable data operations.
  • Support data preprocessing, normalization, and data quality validation processes.
  • Contribute to cloud migration planning and evaluate cloud solutions for security, compliance, interoperability, and performance.
  • Produce data models, architecture diagrams, flowcharts, and technical documentation for stakeholders.
  • Use PowerShell scripting and automation to improve data engineering workflows and system integration.
  • Collaborate with technical teams, security experts, and stakeholders throughout the project lifecycle.

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.
  • Experience with query performance tuning, including indexing, partitioning, and 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 such as 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 analytics data models, including dimensional star/snowflake and/or normalized relational models.
  • Experience collaborating with government program stakeholders and security/privacy personnel.
  • Ability to obtain and maintain a Tier 4 (High-Risk) Public Trust and HSPD-12/PIV credentialing.
  • Ability to travel approximately 10% as needed.
  • Hands-on experience with Azure Data Factory and at least two of Azure SQL, Azure Blob Storage, or Azure Functions (preferred).
  • Active Public Trust clearance (preferred).

Benefits

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

Interested in this position?

Apply directly on the company website

Apply Now

Similar Roles

Data Engineer IV (6249)

Dan.com - a GoDaddy brand Internet Software & Services

itD is hiring a Data Engineer IV to build and optimize AWS-based data infrastructure and pipelines that support AI infrastructure and inference initiatives in a remote role.

AWS
16 hours ago

Senior Data Engineer (GCP)

Xebia 1K-5K Internet Software & Services

Xebia is hiring a data engineer to support a BigQuery migration by building and maintaining scalable data pipelines for production reporting, analytics, and business intelligence solutions.

Apache Airflow CI/CD Databricks dbt Git Python Snowflake SQL
16 hours ago

Staff Data Engineer (Coupang Pay)

Coupang 1K-5K Internet Software & Services

쿠팡페이 핀테크 데이터 플랫폼 팀의 Staff Data Engineer로서 실시간 결제·주문 데이터를 기반으로 데이터 파이프라인과 분석 인프라를 구축·고도화하는 역할입니다.

Apache Spark AWS ClickHouse Flink Hive Java Presto Python Scala SQL Tableau
16 hours, 15 minutes ago

Data Migration Engineer (SQL Server / TSQL)

Cresteo 51-200 information technology & services

Cresteo is hiring a Data Migration Engineer to own end-to-end SQL Server data migrations from legacy schemas into reconciled, production-ready data for US-based clients and international teams.

JSON SQL Server
16 hours, 15 minutes ago

You're on a roll! Sign up now to keep applying.

Sign Up

Already have an account? Log in

Used by 14,729+ remote workers