Senior ETL Architect – Onsite Data Warehouse Lead

Bright Vision Technologies; Short Hills (NJ); Presencial; USD 140.000 - 210.000; Jornada completa

Descripción de la vacante

Bright Vision Technologies is seeking an experienced ETL Architect to lead enterprise data integration, data warehousing, and analytics delivery on a 100% onsite basis in the United States. The role requires deep hands-on expertise with Informatica PowerCenter or IICS, SQL Server, Netezza, and strong leadership to coordinate cross-functional teams and offshore resources.

The ideal candidate will translate complex business needs into reliable data solutions, drive delivery from requirements

Formación

• 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.

Responsabilidades

• Lead enterprise data integration, data warehousing, and analytics delivery.
• Serve as the primary bridge among business users, Product Owners, Project Managers, QA teams, and offshore development resources.
• Translate business needs into reliable technical solutions and drive execution from requirements through production deployment.
• Collaborate with stakeholders to manage delivery within an Agile/Scrum SDLC framework.

Conocimientos

Leadership

Stakeholder management

Communication

Problem solving

Project planning

Agile/Scrum

Herramientas

Informatica PowerCenter

Informatica Intelligent Cloud Services

Microsoft SQL Server

IBM Netezza

Databricks

Power BI

Azure

AWS

GCP

Delta Lake

Descripción del empleo

Bright Vision Technologies is seeking an experienced ETL Architect to lead enterprise data integration, data warehousing, and analytics delivery on a 100% onsite basis in the United States. The role requires deep hands-on expertise with Informatica PowerCenter or IICS, SQL Server, Netezza, and strong leadership to coordinate cross-functional teams and offshore resources.

The ideal candidate will translate complex business needs into reliable data solutions, drive delivery from requirements