Data Engineer / Data Modeler

2 months, 4 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

Lead Data Engineer

Media.Monks 5K-10K Media

Monks Technology Services is seeking a fully remote Lead Data Engineer for a fixed-term contract to lead the modernization of legacy Python/Spark ETL pipelines into dbt Core models on Databricks supporting analytics and business intelligence.

Apache Spark CI/CD Databricks Git GitHub Actions Python SQL
17 hours, 48 minutes ago

Staff Data Engineer

Webflow 251-1K Internet Software & Services

Webflow is hiring a Staff Data Engineer to lead data platform initiatives involving its data lake, event instrumentation, data quality, governance, and cloud infrastructure for modern web marketing operations.

Apache Airflow Apache Spark CI/CD Kafka SQL
17 hours, 48 minutes ago

Data Engineer [Zeal]

Livefront 11-50 Internet Software & Services

Zeal, now part of Livefront, is hiring a Data Engineer across its U.S. hubs to build reliable data pipelines and architectures that support technology consulting engagements for Fortune 1000 companies.

Apache Airflow CI/CD Databricks dbt GCP Git Kafka Oracle PostgreSQL Power BI Python RabbitMQ Snowflake SQL SQL Server Tableau
18 hours, 3 minutes ago

Sr Data Ops Engineer

Coderio 51-250 Internet Software & Services

Coderio is hiring a DataOps Engineer and Technical Referent to work with international customers on designing, implementing, and operating scalable cloud data infrastructure and automation solutions.

AWS Bash dbt Docker GitHub Python SQL Terraform
18 hours, 33 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