Back to Jobs
Recently postedTechnology

Data & Analytics Engineer

V2SoftArlington, VA🇺🇸United States

Quick overview

SeniorityMid Senior
Work modeHybrid
LocationArlington, VA, United States
SQLAWSETLSnowflakeTableauAirflowApachePandasPythonRedshiftPower BIData Analysis

Job description

Basic Qualifications:
  • 5+ years of experience in data analytics, data engineering, or business intelligence
  • Expert-level SQL proficiency — complex joins, window functions, CTEs, subqueries, query optimization, and performance tuning in Client Redshift or similar MPP databases
  • Demonstrated experience conducting RCA, implementing fixes, and building enhancements on data pipelines, reports, and analytics systems
  • Proven ability to convert business requirements into technical data solutions — pipeline logic, SQL transformations, report builds, and data model changes
  • Deep experience creating dashboards, reports, analyses, and datasets using BI tools — Client QuickSight strongly preferred; Tableau, Power BI, or similar also acceptable
  • Proven ability to work with business stakeholders to define metrics and KPIs, and drive the build of reporting solutions
  • Strong understanding of data integration and ETL/ELT concepts — extraction patterns, transformation logic, load strategies, incremental vs. full refresh, CDC, and pipeline architecture
  • Deep knowledge of data warehouse and data mart design — star schema, snowflake schema, fact/dimension tables, slowly changing dimensions, and aggregation layers
  • Hands-on experience with Apache Airflow — ability to read DAG code, understand task dependencies, troubleshoot failures, and drive fixes with engineering teams
  • Strong Python programming skills (pandas, boto3, SQL libraries, automation scripting)
  • Working knowledge of AWS cloud services (Redshift, S3, Glue, Athena, Lambda)
  • Track record of collaborating with engineering teams to drive data requirements and solution design.

Similar jobs