ZipRecruiter

Log In

1

Vortex Jobs in Ashburn, VA (NOW HIRING)

Electra

Staff / Senior Flight Physics Engineer

Manassas, VA · Hybrid

$55.25 - $71.25/hr

Experience with vortex lattice method (VLM) and aircraft analysis tools such as AVL, xRotor, or similar * Strong analytical, problem-solving, and systems engineering skills * Ability to effectively ...

All JobsVortex JobsVortex Jobs in Ashburn, VA

Vortex information

What is a vortex?

A Vortex job typically refers to a specialized role in fluid dynamics, meteorology, or data processing, where expertise in vortex behavior is required. It may involve analyzing airflow patterns, turbulence, or energy transfer in various industries like aerospace, climatology, or engineering. Professionals in this role use simulations, mathematical modeling, and experimental data to understand and optimize vortex-related phenomena. Responsibilities may vary depending on the field, but a strong background in physics and computational techniques is often essential.

What is a vortex operator?

Vortex operators are specialized professionals who manage and monitor vortex technology systems, which are often used in fields like fluid dynamics, meteorology, or HVAC systems. Their responsibilities typically include overseeing the operation and maintenance of vortex equipment, troubleshooting technical issues, and ensuring optimal performance. They may also analyze data generated by vortex systems to improve efficiency or safety. Vortex operators often need a background in engineering or technical trades, depending on the industry. The role can vary significantly based on the specific application of vortex technology.

What are some common challenges faced by vortex engineers when working with computational fluid dynamics (CFD) simulations?

Vortex engineers working with CFD simulations often encounter challenges such as managing high computational demands, ensuring accurate boundary conditions, and interpreting complex flow patterns. Collaborating closely with multidisciplinary teams is essential to validate simulation results and implement design changes. Staying updated with the latest software and modeling techniques also helps in overcoming these challenges and delivering reliable solutions for real-world engineering problems.

What are the key skills and qualifications needed to thrive as a vortex engineer, and why are they important?

To thrive as a Vortex engineer, you need a strong background in mechanical or aerospace engineering, with expertise in fluid dynamics and thermodynamics. Familiarity with computational fluid dynamics (CFD) software, CAD tools, and relevant engineering certifications are typically required. Strong problem-solving skills, attention to detail, and effective communication help professionals collaborate and innovate in complex projects. These skills are crucial for designing, analyzing, and optimizing vortex-related systems to ensure performance and safety.

What is the difference between Vortex vs Wind Turbine Technician?

AspectVortexWind Turbine Technician
Required CredentialsTypically requires engineering or technical certifications, safety trainingRequires technical training, safety certifications, and sometimes an engineering background
Work EnvironmentIndustrial settings, manufacturing plants, or specialized facilitiesOutdoor, on-site at wind farms, often in remote locations
Employer & Industry UsageManufacturers, research labs, or specialized industrial companiesRenewable energy companies, wind farm operators
Common Search & Comparison IntentUnderstanding technical roles in industrial settingsCareers in renewable energy and wind energy maintenance

Vortex and Wind Turbine Technician roles share similarities in technical requirements and safety training. However, Vortex positions often focus on industrial or manufacturing environments, while Wind Turbine Technicians work primarily outdoors at wind farms. Both roles are vital in their respective industries, with overlapping certifications and skills, but differ in work setting and industry focus.

What are the most commonly searched types of Vortex jobs in Ashburn, VA?

The most popular types of Vortex jobs in Ashburn, VA are:

What are popular job titles related to Vortex jobs in Ashburn, VA?

For Vortex jobs in Ashburn, VA, the most frequently searched job titles are:

What job categories do people searching Vortex jobs in Ashburn, VA look for?

The top searched job categories for Vortex jobs in Ashburn, VA are:

What cities near Ashburn, VA are hiring for Vortex jobs?

Cities near Ashburn, VA with the most Vortex job openings:

Vortex jobs near you
Infographic showing various Vortex job openings in Ashburn, VA as of August 2026, with employment types broken down into 89% Full Time, and 11% Part Time. Highlights an 88% Physical, and 12% Remote job distribution.

Data Warehouse Subject Matter Expert

Diaconia LLC

Merrifield, VA • On-site

$150K - $220K/yr

Full-time

This job post has expired 3 days ago. Applications are no longer accepted.

Job description

Description

Diaconia is seeking a Data Warehouse Subject Matter Expert to support the Client's Enterprise Data Modernization Program (Vortex). This is a proposal-critical Key Personnel role responsible for leading Enterprise Data Warehouse execution across a large, mission-critical SQL Server-based data environment supporting Client reporting, SearchPlus, APIs, AI/ML enrichment, and mission-user data access.

The successful candidate must be more than a traditional SQL Server DBA. This role requires a senior EDW leader who can guide data warehouse development, ETL sustainment, dimensional modeling, production support, performance tuning, data quality, release execution, modernization planning, and technical coordination across a complex federal data ecosystem.


Key Responsibilities

Lead the EDW team responsible for development, sustainment, modernization, troubleshooting, and production support of Client's enterprise data warehouse environment.

Provide hands-on technical leadership for SQL Server EDW design, dimensional modeling, ETL development, data ingestion, data validation, performance tuning, release support, and operational reliability.

Maintain and enhance Kimball-style dimensional structures, including fact tables, dimension tables, star schemas, conformed dimensions, surrogate keys, slowly changing dimensions, and reporting-ready data models.

Design, develop, review, troubleshoot, optimize, and maintain SSIS packages, T-SQL scripts, stored procedures, functions, triggers, indexes, jobs, views, and other EDW database objects.

Support recurring production releases, including release planning, deployment coordination, regression testing, data validation, rollback planning, documentation, and post-release verification.

Lead root-cause analysis for EDW defects, data quality issues, ETL failures, report discrepancies, performance degradation, job failures, and production incidents.

Coordinate EDW work with downstream consumers, including Power BI, SSRS, enterprise reporting, SearchPlus/OpenSearch, APIs, AI/ML models, dashboards, and mission-user applications.

Support modernization planning for EDW architecture, cloud readiness, metadata, lineage, ELT, data quality, data observability, automation, and API-enabled data access.

Develop and maintain source-to-target mappings, ETL documentation, data dictionaries, data lineage artifacts, data validation procedures, operational runbooks, and technical design documentation.

Support performance optimization across large SQL Server databases, including indexing, partitioning, query tuning, statistics maintenance, execution plan analysis, storage optimization, and workload monitoring.

Support high availability, disaster recovery, backup/recovery, failover testing, security patching, access controls, STIG/security compliance, and production database reliability  

Support Agile or Kanban delivery, including backlog refinement, sprint planning, daily standups, technical estimation, demonstrations, retrospectives, and status reporting.

Mentor data engineers, ETL developers, DBAs, reporting developers, and analysts on EDW standards, development patterns, data quality practices, and production support expectations 

Requirements

Minimum Required Qualifications

Active U.S. government Secret clearance or higher required at proposal submission.

U.S. Citizenship required.

SME labor-category compliant education and experience: Bachelor's degree with 10+ years of relevant experience; less than a Bachelor's degree requires 14+ years of relevant experience; Master's degree or higher may qualify with 8+ years of relevant experience.

For this role, Diaconia is seeking 15+ years of total database, data warehouse, data engineering, or related data management experience due to the scale and complexity of the Client's Vortex environment.

12+ years of hands-on SQL Server experience.

Experience supporting large SQL Server databases or enterprise data warehouse environments, preferably 5 TB or larger, billion-row scale, or hundreds of tables.

Experience leading or serving as a senior technical SME for an enterprise data warehouse team, data engineering team, ETL team, or production database/data platform team.

Hands-on experience with SQL Server EDW development, administration, performance tuning, data modeling, ETL, production support, and release execution.

Experience with Kimball-style dimensional modeling, including fact/dimension design, star schemas, conformed dimensions, surrogate keys, slowly changing dimensions, and reporting-ready data marts.

Experience with SSIS, SSRS, SSAS, Power BI, T-SQL, SQL Agent jobs, stored procedures, indexes, views, triggers, functions, and SQL Server performance tools.

Experience developing, maintaining, or troubleshooting ETL pipelines and data transformation workflows across multiple source systems.

Experience creating or maintaining source-to-target mappings, data dictionaries, ETL specifications, lineage documentation, data validation rules, and technical design documentation.

Experience working in Agile, Scrum, or Kanban environments with recurring releases and production support responsibilities.

Experience supporting security, access controls, auditing, data integrity, backup/recovery, HA/DR, and compliance in a federal or similarly regulated production environment.

Strong written and verbal communication skills, with the ability to explain technical risks, tradeoffs, data quality issues, and modernization recommendations to technical and non-technical stakeholders 


Preferred Qualifications

Current or prior federal, law enforcement, public safety, homeland security, intelligence, financial-crimes, investigative, or sensitive federal mission experience.

Experience with EDW environments comparable to client Vortex scale: 25+ source systems, 200+ ETL workflows, hundreds of tables, tens of terabytes of data, and recurring monthly or more frequent releases.

Experience with Python, R, PowerShell, or automation scripting for data validation, ETL support, operational monitoring, testing, or data quality analysis.

Experience with cloud data modernization using AWS, Azure, Azure Government, SQL Server on cloud infrastructure, cloud storage, data lake, lakehouse, Snowflake, Databricks, Azure Data Factory, AWS Glue, or similar tools.

Experience with metadata management, data lineage, data quality tooling, data cataloging, data observability, data governance, or master/reference data management.

Experience integrating EDW outputs with Power BI, SSRS, Power BI Report Server, enterprise reporting portals, APIs, SearchPlus/OpenSearch, ElasticSearch/OpenSearch indexes, or AI/ML enrichment pipelines.

Experience supporting FedRAMP, FISMA, NIST, STIG, CUI, Privacy Act, law enforcement sensitive, or similarly controlled data environments.

Experience with CI/CD, DevSecOps, automated testing, database deployment automation, version control, code review, and release management for database/ETL assets.

Microsoft SQL Server, Azure Database Administrator, Azure Data Engineer, AWS, Snowflake, Databricks, DAMA, or related certifications.

Apply