{"schemaVersion":"jobsearcher.job.v1","id":"99d990cef0b786f1188de87f","url":"https://jobsearcher.com/jobs/99d990cef0b786f1188de87f","canonicalUrl":"https://jobsearcher.com/jobs/99d990cef0b786f1188de87f","title":"Data Engineer / Data Modeler","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 ResponsibilitiesDesigning 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 QualificationsBachelor’s degree in Computer Science, Data Engineering, Information Systems, or a related field5+ years of experience in data engineering, database administration, or data architectureProven 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 pipelinesStrong SQL skills with PostgreSQL, SQL Server, Oracle, or similar relational databasesProficiency in Python or R for data transformation, automation, or pipeline developmentExperience with PowerShell scripting and automationExperience with cloud platforms (Azure or AWS) for cloud‑hosted data solutionsKnowledge of FedRAMP requirements and cloud security best practicesProficiency using Git with documented development practicesExperience 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 audiencesEligibility to obtain and maintain a Tier 4 (High‑Risk) Public Trust and HSPD‑12/PIV credentialingAbility to travel approximately 10% as neededPreferred QualificationsHands‑on experience with Azure Data Factory and at least two of the following: Azure SQL, Azure Blob Storage, Azure FunctionsActive Public Trust clearanceBenefitsComprehensive health insurance coverage (medical, dental, vision)401(k) retirement plan with company matchingGenerous paid time off (PTO) and paid holidaysRemote work flexibilityProfessional development and training opportunitiesSupportive and inclusive team culture#J-18808-Ljbffr","company":"Essnova Solutions","rawCompany":"essnova solutions","city":"New York","state":"NY","isRemote":false,"isActive":false,"createdAt":"2026-06-04T07:16:06.184Z","occupations":[{"code":"15-1243.01","title":"Data Warehousing Specialists","slug":"data-warehousing-specialists"},{"code":"15-1243.00","title":"Database Architects","slug":"database-architects"},{"code":"15-1299.08","title":"Computer Systems Engineers/Architects","slug":"computer-systems-engineers-architects"}],"industries":[{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"541690","title":"Other Scientific and Technical Consulting Services","slug":"other-scientific-and-technical-consulting-services"},{"code":"541511","title":"Custom Computer Programming Services","slug":"custom-computer-programming-services"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"Data Engineer / Data Modeler","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 ResponsibilitiesDesigning 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 QualificationsBachelor’s degree in Computer Science, Data Engineering, Information Systems, or a related field5+ years of experience in data engineering, database administration, or data architectureProven 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 pipelinesStrong SQL skills with PostgreSQL, SQL Server, Oracle, or similar relational databasesProficiency in Python or R for data transformation, automation, or pipeline developmentExperience with PowerShell scripting and automationExperience with cloud platforms (Azure or AWS) for cloud‑hosted data solutionsKnowledge of FedRAMP requirements and cloud security best practicesProficiency using Git with documented development practicesExperience 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 audiencesEligibility to obtain and maintain a Tier 4 (High‑Risk) Public Trust and HSPD‑12/PIV credentialingAbility to travel approximately 10% as neededPreferred QualificationsHands‑on experience with Azure Data Factory and at least two of the following: Azure SQL, Azure Blob Storage, Azure FunctionsActive Public Trust clearanceBenefitsComprehensive health insurance coverage (medical, dental, vision)401(k) retirement plan with company matchingGenerous paid time off (PTO) and paid holidaysRemote work flexibilityProfessional development and training opportunitiesSupportive and inclusive team culture#J-18808-Ljbffr","datePosted":"2026-06-04T07:16:06.184Z","dateModified":"2026-06-04T07:16:06.184Z","hiringOrganization":{"@type":"Organization","name":"Essnova Solutions","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"New York","addressRegion":"NY","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"99d990cef0b786f1188de87f"},"url":"https://jobsearcher.com/jobs/99d990cef0b786f1188de87f"}}