ZipRecruiter

Log In

2

Remote Data Transformation Jobs in Washington, DC

Sparibis

Data Engineer

Washington, DC · On-site +1

$129K - $155K/yr

Location: 100% Remote Years' Experience: 5+ years Professional Experience Education: Bachelor ... Create, maintain, and manage data transformations. * Maintain/update documentation. * Create ...

McBride

Power BI Developer

Arlington, VA · Remote

$125K - $140K/yr

This is a remote position. McBride Consulting is seeking a PowerBI Developer for a banking client ... ) * ETL / data transformation to cleanse and standardize data * Data visualization for both ...

Mondo

SQL Data Engineer

Centreville, VA · Remote

$125K - $140K/yr

Remote (EST/CST Preferred) Start Date Is: ASAP Duration: Permanent Compensation Range: $125,000 ... Lead and support data migration initiatives, including schema mapping and transformation logic.

Lucky Rabbit

Backend Developer - Remote

Washington, DC · On-site +1

Experience designing and maintaining ETL/data transformation processes. * Experience working with relational databases such as PostgreSQL or MySQL. * Familiarity with RESTful APIs and backend service ...

Lucky Rabbit

Backend Developer - Remote

Washington, DC · Remote

Experience designing and maintaining ETL/data transformation processes. * Experience working with relational databases such as PostgreSQL or MySQL. * Familiarity with RESTful APIs and backend service ...

Lucky Rabbit

Backend Developer - Remote

Washington, DC · On-site +1

Experience designing and maintaining ETL/data transformation processes. * Experience working with relational databases such as PostgreSQL or MySQL. * Familiarity with RESTful APIs and backend service ...

previous pagenext page

Showing results 21-40

All JobsData Transformation JobsRemote Data Transformation JobsRemote Data Transformation Jobs in Washington, DC

Remote Data Transformation information

What are some common challenges faced in a remote data transformation role and how can they be addressed?

In a remote data transformation role, common challenges include managing large data sets across multiple platforms, ensuring data quality, and maintaining clear communication with distributed teams. Working remotely can make it harder to quickly clarify requirements or spot inconsistencies, so adopting strong documentation practices and regular check-ins are essential. Utilizing collaborative tools for version control, data sharing, and workflow management helps streamline processes and reduce errors. Proactively communicating progress and blockers with cross-functional teams ensures alignment and timely project delivery.

What is the difference between Remote Data Transformation vs Remote Data Analyst?

AspectRemote Data TransformationRemote Data Analyst
Primary RoleDesigning, developing, and implementing data transformation processesAnalyzing data to identify trends, generate reports, and support decision-making
Skills & CertificationsSQL, ETL tools, data modeling, scripting languagesExcel, SQL, data visualization tools, statistical knowledge
Work EnvironmentData engineering teams, cloud platforms, data warehousesBusiness units, analytics teams, reporting platforms
Industry UsageData engineering, software development, cloud servicesBusiness intelligence, marketing, finance

Remote Data Transformation specialists focus on creating and managing data pipelines and transforming raw data into usable formats. In contrast, Remote Data Analysts interpret data to generate insights and support strategic decisions. Both roles require strong technical skills, but their core responsibilities differ in focus and output.

What are the key skills and qualifications needed to thrive as a remote data transformation specialist?

A Remote Data Transformation Specialist needs strong analytical abilities, proficiency in data management, and a solid understanding of databases and data modeling, often supported by a degree in computer science, information systems, or related fields. Familiarity with ETL (Extract, Transform, Load) tools, SQL, and cloud-based data platforms like AWS or Azure is typically required, along with relevant certifications such as AWS Certified Data Analytics. Excellent problem-solving skills, attention to detail, and effective remote communication are vital soft skills for collaborating with distributed teams. These competencies ensure accurate, efficient data processing and integration, which are crucial for data-driven decision-making in modern organizations.

What is a remote data transformation?

A Remote Data Transformation job involves converting, cleaning, and organizing data from one format or structure to another, all while working from a remote location. Professionals in this role use various tools and programming languages, such as SQL, Python, or ETL platforms, to ensure data is accurate, consistent, and usable for analytics or business processes. They often collaborate with data engineers, analysts, and other stakeholders to understand data requirements and deliver high-quality transformed datasets. This role is crucial for organizations that rely on data-driven decision-making and need to integrate information from multiple sources.
What are popular job titles related to Remote Data Transformation jobs in Washington, DC? For Remote Data Transformation jobs in Washington, DC, the most frequently searched job titles are:
What job categories do people searching Remote Data Transformation jobs in Washington, DC look for? The top searched job categories for Remote Data Transformation jobs in Washington, DC are:
Remote Data Transformation jobs near you

Data Engineer

Sparibis

Washington, DC • On-site, Remote

$129K - $155K/yr

Full-time

Re-posted 15 days ago

Job description

Location: 100% Remote
Years' Experience: 5+ years Professional Experience
Education: Bachelor's Degree in IT related field
Clearance: Applicants must be able to obtain and maintain a secret security clearance. United States Citizenship is required as part of the eligibility criteria to be able to obtain this type of security clearance.
Required Certifications:
  • CompTIA Security +

Key Skills:
  • 5+ years of IT experience focusing on enterprise data architecture and management to include data flow charts, diagrams, and other technical documentation.
  • Experience with Databricks, Structured Streaming, Delta Lake concepts, and Delta Live Tables required.
  • Python development experience required.
  • Experience with ETL and ELT tools such as SSIS, Pentaho, and/or Data Migration Services, and the ability to incorporate Python as required.
  • Advanced level SQL experience (Joins, Aggregation, Windowing functions, Common Table Expressions, RDBMS schema design, Postgres performance optimization).
  • Proficiency using Git for version control, including repository management, branching, merging, and pull requests.
  • Active CompTIA Security+ certification preferred. If selected, must be able to obtain a CompTIA Security+ certification prior to beginning supporting the program.

Responsibilities
  • Plan, create, and maintain data architectures, ensuring alignment with business requirements.
  • Obtain data, formulate dataset processes, and store optimized data.
  • Identify problems and inefficiencies and apply solutions.
  • Determine tasks where manual participation can be eliminated with automation.
  • Identify and optimize data bottlenecks, leveraging automation where possible.
  • Create and manage data lifecycle policies (retention, backups/restore, etc).
  • In-depth knowledge for creating, maintaining, and managing ETL/ELT pipelines.
  • Create, maintain, and manage data transformations.
  • Maintain/update documentation.
  • Create, maintain, and manage data pipeline schedules.
  • Monitor data pipelines.
  • Create, maintain, and manage data quality gates (Great Expectations) to ensure high data quality.
  • Support AI/ML teams with optimizing feature engineering code.
  • Expertise in Spark/Python/Databricks, Data Lake and SQL.
  • Create, maintain, and manage Spark Structured Steaming jobs, including using the newer Delta Live Tables and/or DBT.
  • Research existing data in the data lake to determine best sources for data.
  • Create, manage, and maintain ksqlDB and Kafka Streams queries/code
  • Data driven testing for data quality.
  • Maintain and update Python-based data processing scripts executed on AWS Lambdas.
  • Unit tests for all the Spark, Python data processing and Lambda codes.
  • Maintain PCIS Reporting Database data lake with optimizations and maintenance (performance tuning, etc).
  • Streamlining data processing experience including formalizing concepts of how to handle lake data, defining windows, and how window definitions impact data freshness.

Qualifications
  • 5+ years of IT experience focusing on enterprise data architecture and management.
  • Must have an active Secret security clearance.
  • Bachelor degree required.
  • CompTIA Security+ certification preferred. If selected, must be able to obtain a CompTIA Security+ certification prior to begin supporting the program.
  • Experience in Conceptual/Logical/Physical Data Modeling & expertise in Relational and Dimensional Data Modeling.
  • Experience with Databricks and Python Development, Structured Streaming, Delta Lake concepts, and Delta Live Tables required.
    • Additional experience with Spark, Spark SQL, Spark DataFrames and DataSets, and PySpark.
    • Data Lake concepts such as time travel and schema evolution and optimization.
    • Structured Streaming and Delta Live Tables with Databricks a bonus.
  • Knowledge of Python (Python 3.X) for CI/CD pipelines required.
    • Familiarity with Pytest and Unittest a bonus.
  • Experience leading and architecting enterprise-wide initiatives specifically system integration, data migration, transformation, data warehouse build, data mart build, and data lakes implementation / support.
    • Advanced level understanding of streaming data pipelines and how they differ from batch systems.
    • Formalize concepts of how to handle late data, defining windows, and data freshness.
    • Advanced understanding of ETL and ELT and ETL/ELT tools such as SSIS, Pentaho, Data Migration Service etc.
    • Understanding of concepts and implementation strategies for different incremental data loads such as tumbling window, sliding window, high watermark, etc.
    • Familiarity and/or expertise with Great Expectations or other data quality/data validation frameworks a bonus.
    • Understanding of streaming data pipelines and batch systems.
    • Familiarity with concepts such as late data, defining windows, and how window definitions impact data freshness.
  • Advanced level SQL experience (Joins, Aggregation, Windowing functions, Common Table Expressions, RDBMS schema design, Postgres performance optimization).
  • Indexing and partitioning strategy experience.
  • Debug, troubleshoot, design and implement solutions to complex technical issues.
  • Experience with large-scale, high-performance enterprise big data application deployment and solution.
  • Understanding how to create DAGs to define workflows.
  • Familiarity with CI/CD pipelines, containerization, and pipeline orchestration tools such as Airflow, Prefect, etc a bonus but not required.
  • Architecture experience in AWS environment a bonus.
    • Familiarity working with Kinesis and/or Lambda specifically with how to push and pull data, how to use AWS tools to view data in Kinesis streams, and for processing massive data at scale a bonus.
    • Experience with Docker, Jenkins, and CloudWatch.
    • Ability to write and maintain Jenkinsfiles for supporting CI/CD pipelines.
    • Experience working with AWS Lambdas for configuration and optimization.
    • Experience working with DynamoDB to query and write data.
    • Experience with S3.
  • Experience working with JSON and defining JSON Schemas a bonus.
  • Experience setting up and management Confluent/Kafka topics and ensuring performance using Kafka a bonus.
    • Familiarity with Schema Registry, message formats such as Avro, ORC, etc.
    • Understanding how to manage ksqlDB SQL files and migrations and Kafka Streams.
  • Ability to thrive in a team-based environment.
  • Experience briefing the benefits and constraints of technology solutions to technology partners, stakeholders, team members, and senior level of management.
  • Proficiency using Git for version control, including repository management, branching, merging, and pull requests.
    • Repository setup and management.
    • Branching strategies (feature, develop, main).
    • Merging and resolving conflicts.
    • Creating and reviewing pull requests.
    • Commit best practices (clear messages, atomic commits).
    • Tagging and release management.

About Sparibis
Sparibis LLC is a professional solution firm that Clients rely on to access the best talent to drive their business success.
Sparibis is an equal opportunity employer that values diversity at all levels. All individuals, regardless of personal characteristics, are encouraged to apply.

Apply