The Role
Design, develop, optimize, and support enterprise ETL and ELT pipelines for data integration, analytics, reporting, and cloud modernization. Build ingestion and transformation workflows, implement CDC and SCD strategies, improve SQL and pipeline performance, and ensure data quality, security, governance, and compliance. Collaborate with architects, engineers, analysts, and BI teams on cloud migrations, architecture, deployments, production support, and scalable data warehousing solutions.
Summary Generated by Built In
ETL Developer – Remote
Bright Vision Technologies is a technology consulting and software development company delivering cloud, AI, data, and enterprise solutions across the United States.
This is a fantastic opportunity to join an established and well-respected organization offering tremendous career growth potential.
Job Title: ETL Developer
Location: 100% Remote (U.S.)
Position Type: Full-time, Direct W2
Salary Range: $115,000–$175,000 Annually
Experience Required: 5+ years
Sponsorship: U.S. Citizens, Green Card Holders, EAD Holders, and H-1B transfer candidates are encouraged to apply. We are unable to sponsor new H-1B visa petitions for this position.
Job Summary
We are seeking an experienced ETL Developer to design, develop, and optimize enterprise-scale data integration solutions supporting business intelligence, analytics, regulatory reporting, and cloud data modernization initiatives. This role focuses on building high-performance ETL pipelines that ingest, transform, validate, and deliver data from diverse operational systems into enterprise data warehouses and cloud-based analytics platforms.
You will collaborate with data architects, data engineers, business analysts, cloud engineers, and BI developers to develop scalable data integration frameworks, automate complex workflows, and ensure the delivery of high-quality, trusted data across the organization. The ideal candidate combines strong ETL development expertise with advanced SQL skills, cloud data platform experience, and a deep understanding of data warehousing and enterprise data governance.
Key Responsibilities
Required Skills
Preferred Qualifications
Project Environment
You will be joining an enterprise data engineering team responsible for modernizing data integration and analytics platforms supporting multiple business units across financial services, healthcare, insurance, and retail industries. Current initiatives include:
This is a hands-on engineering role where you will contribute to data architecture, ETL development, cloud migration, performance optimization, production support, and continuous improvement of enterprise data integration solutions.
How to Apply
Would you like to know more about this opportunity? For immediate consideration, please send your resume to [email protected] or contact us at (908) 676-4399. Learn more about Bright Vision Technologies at www.bvteck.com.
Bright Vision Technologies is an Equal Opportunity Employer
Bright Vision Technologies is a technology consulting and software development company delivering cloud, AI, data, and enterprise solutions across the United States.
This is a fantastic opportunity to join an established and well-respected organization offering tremendous career growth potential.
Job Title: ETL Developer
Location: 100% Remote (U.S.)
Position Type: Full-time, Direct W2
Salary Range: $115,000–$175,000 Annually
Experience Required: 5+ years
Sponsorship: U.S. Citizens, Green Card Holders, EAD Holders, and H-1B transfer candidates are encouraged to apply. We are unable to sponsor new H-1B visa petitions for this position.
Job Summary
We are seeking an experienced ETL Developer to design, develop, and optimize enterprise-scale data integration solutions supporting business intelligence, analytics, regulatory reporting, and cloud data modernization initiatives. This role focuses on building high-performance ETL pipelines that ingest, transform, validate, and deliver data from diverse operational systems into enterprise data warehouses and cloud-based analytics platforms.
You will collaborate with data architects, data engineers, business analysts, cloud engineers, and BI developers to develop scalable data integration frameworks, automate complex workflows, and ensure the delivery of high-quality, trusted data across the organization. The ideal candidate combines strong ETL development expertise with advanced SQL skills, cloud data platform experience, and a deep understanding of data warehousing and enterprise data governance.
Key Responsibilities
- Design, develop, and maintain enterprise ETL/ELT pipelines for large-scale data integration projects.
- Build scalable data ingestion workflows that extract data from relational databases, cloud applications, APIs, flat files, and enterprise systems.
- Develop transformation logic for cleansing, standardizing, validating, and enriching large datasets.
- Design and optimize batch and near real-time data processing pipelines supporting business-critical reporting and analytics.
- Implement Slowly Changing Dimensions (SCD), Change Data Capture (CDC), incremental loading strategies, and data reconciliation processes.
- Develop reusable ETL frameworks, metadata-driven workflows, and parameterized jobs to improve maintainability.
- Perform source-to-target mapping, data profiling, and data quality analysis during project implementation.
- Optimize ETL job performance by improving SQL queries, partitioning strategies, indexing, and parallel processing.
- Monitor ETL workflows, troubleshoot production failures, and implement proactive alerting and recovery mechanisms.
- Collaborate with cloud engineers to migrate legacy ETL workloads to Azure or AWS cloud platforms.
- Participate in data architecture discussions, code reviews, deployment planning, and production support.
- Ensure data security, governance, auditability, and regulatory compliance across enterprise data pipelines.
Required Skills
- Five or more years of professional experience developing enterprise ETL solutions.
- Strong hands-on experience with ETL platforms such as Informatica PowerCenter, SSIS, Talend, IBM DataStage, or Pentaho.
- Advanced SQL development skills with SQL Server, Oracle, PostgreSQL, Snowflake, or Teradata.
- Strong understanding of relational databases, dimensional modeling, star schema, snowflake schema, and data warehousing principles.
- Experience designing ETL workflows involving complex transformations, joins, aggregations, lookups, and data validation.
- Hands-on experience implementing Change Data Capture (CDC), Slowly Changing Dimensions (SCD Type 1 & Type 2), and incremental loading techniques.
- Experience working with cloud data platforms including Azure Data Factory (ADF), AWS Glue, or Google Cloud Data Fusion.
- Experience integrating structured and semi-structured data formats including JSON, XML, CSV, Parquet, and Avro.
- Familiarity with scripting languages such as Python, PowerShell, or Shell scripting for ETL automation.
- Experience scheduling workflows using Control-M, Autosys, Apache Airflow, Azure Data Factory, or enterprise schedulers.
- Experience with Git, Azure DevOps, Jenkins, or other CI/CD tools for ETL deployments.
- Strong debugging, troubleshooting, and ETL performance tuning skills.
- Experience working with Agile Scrum teams and enterprise SDLC processes.
Preferred Qualifications
- Experience with cloud data warehouses including Snowflake, Azure Synapse Analytics, Amazon Redshift, or Google BigQuery.
- Knowledge of Apache Spark, Databricks, PySpark, or distributed data processing frameworks.
- Experience implementing enterprise Master Data Management (MDM) and Data Quality solutions.
- Familiarity with streaming technologies including Apache Kafka, Azure Event Hub, or Amazon Kinesis.
- Experience developing metadata-driven ETL frameworks and reusable integration components.
- Knowledge of Data Vault 2.0 architecture and modern data lakehouse concepts.
- Familiarity with DevOps practices for data engineering and automated ETL deployments.
- Experience with BI platforms including Power BI, Tableau, or Qlik for downstream reporting integration.
- Understanding of data governance frameworks, lineage, cataloging, and regulatory compliance.
- Cloud certifications in Azure, AWS, Snowflake, or Informatica are highly desirable.
Project Environment
You will be joining an enterprise data engineering team responsible for modernizing data integration and analytics platforms supporting multiple business units across financial services, healthcare, insurance, and retail industries. Current initiatives include:
- Enterprise data warehouse modernization to Snowflake and Azure Synapse
- Cloud-based ETL migration from legacy on-premises platforms
- Real-time data ingestion and analytics pipelines
- Customer 360 and Master Data Management initiatives
- Regulatory reporting and compliance data solutions
- Data Lake and Lakehouse architecture implementation
- Enterprise reporting platforms supporting executive dashboards and operational analytics
- High-volume data pipelines processing billions of records from ERP, CRM, HR, and financial systems
This is a hands-on engineering role where you will contribute to data architecture, ETL development, cloud migration, performance optimization, production support, and continuous improvement of enterprise data integration solutions.
How to Apply
Would you like to know more about this opportunity? For immediate consideration, please send your resume to [email protected] or contact us at (908) 676-4399. Learn more about Bright Vision Technologies at www.bvteck.com.
Bright Vision Technologies is an Equal Opportunity Employer
Skills Required
- Five or more years of professional experience developing enterprise ETL solutions
- Hands-on experience with Informatica PowerCenter, SSIS, Talend, IBM DataStage, or Pentaho
- Advanced SQL development skills with SQL Server, Oracle, PostgreSQL, Snowflake, or Teradata
- Understanding of relational databases, dimensional modeling, star schema, snowflake schema, and data warehousing principles
- Experience designing ETL workflows with transformations, joins, aggregations, lookups, and data validation
- Experience implementing CDC, SCD Type 1 and Type 2, and incremental loading techniques
- Experience with Azure Data Factory, AWS Glue, or Google Cloud Data Fusion
- Experience integrating JSON, XML, CSV, Parquet, and Avro data
- Familiarity with Python, PowerShell, or Shell scripting
- Experience scheduling workflows with Control-M, Autosys, Apache Airflow, Azure Data Factory, or enterprise schedulers
- Experience with Git, Azure DevOps, Jenkins, or other CI/CD tools
- Strong debugging, troubleshooting, and ETL performance tuning skills
- Experience working with Agile Scrum teams and enterprise SDLC processes
- Experience with Snowflake, Azure Synapse Analytics, Amazon Redshift, or Google BigQuery
- Knowledge of Apache Spark, Databricks, PySpark, or distributed data processing frameworks
- Experience implementing enterprise MDM and data quality solutions
- Familiarity with Apache Kafka, Azure Event Hub, or Amazon Kinesis
- Experience developing metadata-driven ETL frameworks and reusable integration components
- Knowledge of Data Vault 2.0 and modern data lakehouse concepts
- Familiarity with DevOps practices for data engineering and automated ETL deployments
- Experience with Power BI, Tableau, or Qlik for downstream reporting integration
- Understanding of data governance, lineage, cataloging, and regulatory compliance
- Cloud certification in Azure, AWS, Snowflake, or Informatica
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Bright Vision Technologies is a minority-owned organization founded in July 2020 and based in New Jersey, USA. The company specializes in delivering top-tier staffing and IT consulting services, including custom computer programming and systems design. Additionally, they are a product engineering firm with a flagship AI-powered talent intelligence and enterprise automation platform called Lumina, which helps transform IT into a strategic asset for their valued partners.
