ETL Architect

Bright Vision Technologies; Short Hills (NJ); In loco; USD 96.000 - 165.000; Tempo pieno

Descrizione del lavoro

Bright Vision Technologies is seeking an experienced ETL Architect for a 100% onsite role in the United States. The candidate will lead enterprise data integration, data warehousing, and analytics delivery with hands-on leadership and strong communication skills.

Requirements include 10+ years in ETL/data warehousing, expertise in Informatica PowerCenter or IICS, SQL Server, IBM Netezza, and experience with Databricks, Power BI, and cloud platforms.

Competenze

• Over 10 years in ETL, data warehousing, or analytics delivery.
• Experience leading technical teams and coordinating offshore resources.
• Strong hands-on with Informatica PowerCenter and/or IICS.
• Strong SQL Server expertise, advanced SQL, stored procedures, and performance tuning.
• Experience with IBM Netezza data warehouses.
• Knowledge of data integration patterns, dimensional modeling, and batch processing.
• Databricks, Delta Lake, lakehouse patterns experience.
• Power BI dashboards, semantic models, and data refresh.
• Cloud data services on Azure, AWS, or Google Cloud.
• Experience in Agile/Scrum and SDLC environments.
• Excellent communication, leadership, planning, and stakeholder management.

Conoscenze

ETL & Data Warehousing

Team Leadership

Communication Skills

Stakeholder Management

Agile/Scrum

Strumenti

Informatica PowerCenter

Informatica IICS

Microsoft SQL Server

IBM Netezza

Databricks

Power BI

Azure/AWS/GC

Descrizione del lavoro

ETL Architect - Onsite

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 Architect

Location:100% Onsite (U.S.)

Position Type: Contract

Experience Required:10+ years

Sponsorship:U.S. Citizens, Green Card Holders, EAD Holders, 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, hands-on ETL, Data Warehouse Architect to lead enterprise data integration, data warehousing, and analytics delivery. The role will serve as the primary bridge among business users, Product Owners, Project Managers, QA teams, upstream and downstream application partners, and offshore development teams. The ideal candidate combines strong expertise in Informatica, SQL Server, and Netezza with proven technical leadership, delivery management, and stakeholder engagement skills. Experience with Databricks, Power BI, and cloud platforms is a plus. The successful candidate will be a self-starter who can translate business needs into reliable technical solutions and drive execution from requirements through production deployment.

Required Qualifications

• Experience in data warehousing, ETL, databricks, data integration, or enterprise analytics delivery.
• Experience leading technical teams and coordinating work with offshore delivery resources.
• Strong hands-on experience with Informatica PowerCenter and/or Informatica Intelligent Cloud Services (IICS).
• Strong experience with Microsoft SQL Server, advanced SQL development, stored procedures, query optimization, and performance tuning.
• Experience developing or supporting enterprise data warehouse solutions on IBM Netezza.
• Solid understanding of data integration patterns, dimensional modeling, batch processing, data quality, and production support.
• Experience with Databricks, including data engineering, Delta Lake, lakehouse patterns, or ETL modernization.
• Experience with Power BI, including enterprise dashboards, semantic models, data refresh, and reporting solutions.
• Experience with cloud data services on Microsoft Azure, AWS, or Google Cloud Platform.
• Experience working within Agile/Scrum and structured SDLC delivery environments.
• Excellent communication, leadership, planning, organization, problem-solving, and stakeholder-management skills.

Bright Vision Technologies is an Equal Opportunity Employer.

Equal Employment Opportunity (EEO) Statement

Bright Vision Technologies (BV Teck) is committed to equal employment opportunity (EEO) for all employees and applicants without regard to race, color, religion, sex, sexual orientation, gender identity or expression, national origin, age, genetic information, disability, veteran status, or any other protected status as defined by applicable federal, state, or local laws. This commitment extends to all aspects of employment, including recruitment, hiring, training, compensation, promotion, transfer, leaves of absence, termination, layoffs, and recall.

BV Teck expressly prohibits any form of workplace harassment or discrimination. Any improper interference with employees' ability to perform their job duties may result in disciplinary action up to and including termination of employment.