Data Integration & Analytics - Onsite Technical Lead

Bright Vision Technologies; Short Hills (NJ); On-site; USD 115,000 - 180,000; Full time

Job summary

Bright Vision Technologies in Short Hills, NJ is seeking an experienced Onsite Technical Lead to drive enterprise data integration, data warehousing, and analytics delivery. You will bridge business users, Product Owners, and offshore teams to ensure successful outcomes.

The ideal candidate combines hands-on Informatica PowerCenter/IICS, SQL Server, and Netezza expertise with strong leadership, delivery management, and stakeholder engagement.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Engineering, or related field.
• 8+ years in data warehousing, ETL, data integration, or analytics delivery.
• 3+ years leading technical teams and coordinating offshore 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.
• Experience working in Agile/Scrum and SDLC environments.

Responsibilities

• Own end-to-end delivery of data integration and analytics initiatives, from planning to production stabilization.
• Lead offshore development teams; set priorities, monitor progress, remove blockers, ensure high-quality delivery.
• Manage milestones, risks, dependencies, issues, and communications with stakeholders.
• Provide technical direction, mentoring, and hands-on support to development team members.
• Collaborate with business users, Product Owners, QA, and vendor teams to ensure successful delivery.

Skills

SQL Server

Data warehousing

ETL development

Agile/Scrum

Technical leadership

Stakeholder management

Education

Bachelor's degree in Computer Science / Information Systems / Engineering

Tools

Informatica PowerCenter

Informatica Intelligent Cloud Services (IICS)

Microsoft SQL Server

IBM Netezza

Databricks

Power BI

Cloud platforms (Azure/AWS/GCP)

Job description

Data Integration & Analytics - Onsite Technical Lead – 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

Data Integration & Analytics - Onsite Technical Lead

Location

Short Hills, NJ (Onsite)

Position Type

Full-time, Direct W2

Salary Range

$115,000–$180,000 Annually

Experience Required

8+ 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, hands‑on Onsite Technical Lead 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.

Key Responsibilities

Delivery & Team Leadership

• Own end-to-end delivery of data integration and analytics initiatives, from planning and requirements through implementation, testing, release, and production stabilization
• Lead and coordinate offshore development teams; establish clear priorities, monitor progress, remove blockers, and ensure timely, high-quality delivery
• Manage milestones, risks, dependencies, issues, and action items while communicating status and decisions clearly to stakeholders
• Provide technical direction, mentoring, and hands‑on support to development team members
• Demonstrate strong ownership, accountability, and the ability to work effectively with minimal supervision

Business & Stakeholder Collaboration

• Partner with business users to understand business processes, data needs, reporting requirements, and expected outcomes
• Work closely with Product Owners and Project Managers to refine scope, prioritize work, support planning, and drive delivery commitments
• Collaborate with QA teams on test strategy, defect triage, user acceptance testing, regression testing, and release readiness
• Coordinate with upstream and downstream partners to manage interfaces, data dependencies, sequencing, and production impacts
• Facilitate requirements workshops, technical design reviews, sprint ceremonies, status discussions, and implementation checkpoints

Technical Leadership

• Lead the design, development, enhancement, and support of ETL, data warehouse, and analytics solutions
• Review solution designs, Informatica mappings and workflows, SQL code, data models, and technical specifications for quality, scalability, and performance
• Drive root‑cause analysis and resolution of data quality, performance, batch‑processing, and production‑support issues
• Promote reusable design patterns, coding standards, peer reviews, technical documentation, and operational readiness

Required Qualifications

• Bachelor's degree in Computer Science, Information Systems, Engineering, or a related field, or equivalent professional experience
• 8+ years of experience in data warehousing, ETL, data integration, or enterprise analytics delivery
• 3+ years of 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 working within Agile/Scrum and structured SDLC delivery environments
• Excellent communication, leadership, planning, organization, problem-solving, and stakeholder‑management skills

Preferred Qualifications

• 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
• Knowledge of cloud data lakes, lakehouse architecture, CI/CD, DevOps, or DataOps practices
• Insurance industry experience, preferably within Property & Casualty (P&C;) insurance
• Exposure to policy, claims, billing, underwriting, finance, reinsurance, or regulatory reporting data
• Experience delivering solutions in a regulated environment with awareness of audit, compliance, data governance, privacy, security, and data‑retention requirements

Leadership Profile

Self-Starter

Operates independently, anticipates needs, and takes initiative.

Delivery Leader

Drives commitments to completion and addresses risks early.

Collaborative Partner

Builds trust across business, technology, QA, and vendor teams.

Technical Problem Solver

Brings structure and sound judgment to complex issues.

Work Arrangement

• This position requires regular in-person work from the Short Hills, New Jersey office.
• The Technical Lead will collaborate closely with onsite stakeholders while coordinating delivery across distributed and offshore teams

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.