ETL Architect
About The Position
Bright Vision Technologies is seeking an experienced, hands-on ETL and Data Warehouse Architect to lead enterprise data integration, data warehousing, and analytics delivery. The role serves as a primary bridge among business users, Product Owners, Project Managers, QA teams, upstream and downstream application partners, and offshore development teams. The position combines expertise in Informatica, SQL Server, and Netezza with technical leadership, delivery management, and stakeholder engagement. The architect will translate business needs into reliable technical solutions and drive execution from requirements through production deployment. Experience with Databricks, Power BI, and cloud platforms is also relevant.
Requirements
- 10+ years of experience required.
- 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.
Responsibilities
- Lead enterprise data integration, data warehousing, and analytics delivery.
- Serve as a primary bridge among business users, Product Owners, Project Managers, QA teams, application partners, and offshore development teams.
- Lead technical teams and coordinate work with offshore delivery resources.
- Translate business needs into technical solutions and drive execution from requirements through production deployment.
- Develop or support enterprise data warehouse solutions and data integration using the specified technologies.
- Support analytics delivery, including enterprise dashboards, semantic models, data refresh, and reporting solutions.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Career Level
Senior
Education Level
No Education Listed
