Data Engineer

Eliassen Group is a strategic consulting firm that provides technology, business advisory, and life sciences solutions. The Data Engineer will design, build, integrate, and sustain secure enterprise data solutions, including scalable ETL/ELT pipelines, data models, and hybrid cloud and on-premises platforms. The role also supports data quality, governance, troubleshooting, modernization, and collaboration across technical and business teams in an Agile and DevOps environment.

Responsibilities

• Design, develop, test, deploy, and maintain scalable ETL/ELT pipelines for structured and unstructured data from systems, applications, APIs, logs, files, and databases
• Build and optimize data models, schemas, tables, views, and curated datasets for analytics, business intelligence, operational reporting, and application needs
• Develop data-processing solutions using SQL and Python with reusable patterns, source control, peer review, and documented release practices
• Integrate cloud and on-premises data platforms to support secure data movement, interoperability, availability, retention, and performance across hybrid environments
• Implement automated data-quality checks, reconciliation controls, monitoring, alerting, and exception handling
• Troubleshoot pipeline failures, data discrepancies, performance degradation, access issues, and integration defects; perform root-cause analysis and implement corrective and preventive actions
• Partner with analysts, BI developers, data owners, administrators, and stakeholders to define requirements, mappings, transformation rules, and acceptance criteria
• Apply data governance, security, privacy, least-privilege access, auditability, and records-retention requirements in coordination with cybersecurity and compliance teams
• Support platform upgrades, data migrations, modernization initiatives, capacity planning, and performance tuning with minimal disruption
• Create and maintain technical documentation, including architecture diagrams, data dictionaries, lineage, interface specs, runbooks, SOPs, and troubleshooting guides
• Participate in Agile planning, backlog refinement, technical reviews, demonstrations, incident response, and after-hours support when required

Preferred

• BI experience with dashboards, reports, semantic models, KPIs, and self-service analytics; Power BI and DAX
• Microsoft Certified Azure Administrator Associate (AZ-104)
• Hands-on experience with Azure Data Factory, Azure SQL, Azure Storage, Synapse, Databricks, or comparable cloud platforms
• Familiarity with STIGs, RMF, vulnerability management, system hardening, security controls, and compliance frameworks
• Experience with Ansible, Jenkins, Bitbucket, and CI/CD practices
• Experience in classified, DoD, federal government, or highly regulated environments
• Knowledge of data lakes, lake houses, dimensional modeling, streaming or event-driven data, distributed processing, or containerized workloads
• Experience with data cataloging, lineage, master or reference data, RBAC, audit logging, backup and recovery, and disaster recovery
• Relevant technical certifications in Azure, data engineering, database administration, analytics, cloud architecture, or security
• Strong customer engagement, requirements analysis, technical presentations, mentoring, and cross-functional collaboration
• Experience with graph databases such as Neo4j, Cypher, and property graph modeling
• Familiarity with knowledge graphs, ontologies, semantic data models, and controlled vocabularies
• Experience with entity resolution and record linkage across multiple authoritative sources
• Business Intelligence
• Dashboard Development
• Report Development
• Semantic Models
• KPI Development
• Self-Service Analytics
• Power BI
• DAX
• Azure Administrator Associate (AZ-104)
• Azure Data Factory
• Azure SQL
• Azure Storage
• Azure Synapse
• Databricks
• Cloud Platforms
• STIGs
• Risk Management Framework (RMF)
• Vulnerability Management
• System Hardening
• Security Controls
• Compliance Frameworks
• Jenkins
• Bitbucket
• CI/CD
• Classified Environments
• DoD Experience
• Federal Government Experience
• Regulated Environments
• Data Lakes
• Lakehouses
• Dimensional Modeling
• Streaming Data
• Event-Driven Data
• Distributed Processing
• Containerized Workloads
• Data Cataloging
• Data Lineage
• Master Data
• Reference Data
• Role-Based Access Control (RBAC)
• Audit Logging
• Backup
• Recovery
• Disaster Recovery
• Azure Certifications
• Data Engineering Certifications
• Database Administration Certifications
• Analytics Certifications
• Cloud Architecture Certifications
• Security Certifications
• Requirements Analysis
• Graph Databases
• Neo4j
• Cypher
• Property Graph Modeling
• Knowledge Graphs
• Ontologies
• Semantic Data Modeling
• Controlled Vocabularies
• Entity Resolution
• Record Linkage
• Authoritative Data Sources
• Customer Engagement
• Technical Presentations
• Mentoring
• Cross-Functional Collaboration

Benefits

• Medical, Dental, and Vision benefits
• 401k with company matching
• Life insurance
• For W2 employees regularly scheduled to work 30 or more hours per week: medical (choice of 3 plans)
• Dental
• Vision
• Pre-tax accounts
• Other voluntary benefits including life and disability insurance
• 401(k) with match
• Sick time if required by law in the worked-in state/locality

Company

• Strategic consulting in technology, business advisory, and life sciences.
• North Reading, Massachusetts, USA
• http://www.eliassen.com/
• Founded in 1989
• 1001-5000 employees

Qualifications

• applicant must be a United States Citizen with an active Secret clearance
• Proficiency with SQL and at least one scripting or programming language such as Python for extraction, transformation, validation, automation, and troubleshooting
• Experience with ETL/ELT, relational data structures, data modeling, schema design, source-to-target mapping, data quality, metadata, and lifecycle management
• Experience integrating data from relational databases, APIs, flat files, application data, system logs, or message-based interfaces
• Working knowledge of cloud and on-premises infrastructure, authentication and authorization, network connectivity, encryption, secure file transfer, and service accounts
• Experience diagnosing production data issues, analyzing logs and metrics, resolving failed jobs or performance problems, and documenting root cause and corrective action
• Ability to work independently and collaboratively in a high-tempo environment, manage priorities, communicate clearly, and produce complete documentation
• Working knowledge of PowerShell, Python, and Ansible, with familiarity using large language models and AI-enabled tools
• Applicant must be a United States Citizen with an active Secret clearance
• BI experience with dashboards, reports, semantic models, KPIs, and self-service analytics; Power BI and DAX
• Microsoft Certified Azure Administrator Associate (AZ-104)
• Hands-on experience with Azure Data Factory, Azure SQL, Azure Storage, Synapse, Databricks, or comparable cloud platforms
• Familiarity with STIGs, RMF, vulnerability management, system hardening, security controls, and compliance frameworks
• Experience with Ansible, Jenkins, Bitbucket, and CI/CD practices
• Experience in classified, DoD, federal government, or highly regulated environments
• Knowledge of data lakes, lake houses, dimensional modeling, streaming or event-driven data, distributed processing, or containerized workloads
• Experience with data cataloging, lineage, master or reference data, RBAC, audit logging, backup and recovery, and disaster recovery
• Relevant technical certifications in Azure, data engineering, database administration, analytics, cloud architecture, or security
• Strong customer engagement, requirements analysis, technical presentations, mentoring, and cross-functional collaboration
• Experience with graph databases such as Neo4j, Cypher, and property graph modeling
• Familiarity with knowledge graphs, ontologies, semantic data models, and controlled vocabularies
• Experience with entity resolution and record linkage across multiple authoritative sources

Required skills

• SQL, Python, ETL/ELT, Data Modeling, Data Integration, Data Quality, PowerShell, Ansible, Power BI, DAX, Azure Data Factory, Requirements analysis

Preferred skills

• Microsoft Certified Azure Administrator Associate (AZ-104)

Experience

• Mid level