Application Observability Architect, Engineer
Bank of America
AnsibleAWSCloudJenkinsLinuxPythonSDLCShell ScriptingTerraform
Architect
Brillio
full-time
Posted on:
Location Type: Hybrid
Location: Edison • New Jersey • 🇺🇸 United States
Visit company websiteJob Level
SeniorLead
Tech Stack
ETLInformaticaSQL
About the role
- Lead the design, development, and optimization of ETL workflows using Informatica PowerCenter and IICS
- Architect high-performance, scalable solutions on Snowflake Data Warehouse
- Design robust data models with strong understanding of facts and dimensions
- Act as a strategic advisor to business stakeholders, using data to drive insights and business outcomes
- Partner with line-of-business leaders to identify and prioritize opportunities where data engineering can deliver measurable value
- Lead a team of data engineers through complex integration efforts with a problem-solving attitude
- Translate unstructured problems into structured, scalable data solutions
- Deliver high-quality business presentations and solution documentation tailored to technical and executive audiences
- Ensure alignment between technical delivery and business value realization
- Optimize performance through effective data modeling, partitioning, and indexing.
- Lead data migration and integration projects to move legacy data systems to Snowflake.
- Collaborate with business analysts, data engineers, and stakeholders to define requirements and deliver data solutions.
Requirements
- 8+ years of experience in data engineering and ETL, with hands-on expertise in Informatica (PowerCenter and IICS)
- Advanced SQL skills and experience with performance tuning
- Proven experience designing and optimizing solutions in Snowflake
- Strong foundation in data warehouse design, with a focus on dimensional modeling
- Prior experience in pharma domain with exposure to IQVIA datasets strongly preferred
- Exceptional communication and stakeholder engagement skills
- Demonstrated consultative mindset, capable of influencing and leading cross-functional discussions on data-driven value generation
- Experience writing business process and technical documentation
- Strong project management, organization, and team leadership skills
- Ability to work in fast-paced environments with ambiguity and shifting priorities
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
ETLInformatica PowerCenterInformatica IICSSnowflake Data WarehouseSQLdata modelingperformance tuningdata migrationdata integrationdimensional modeling
Soft skills
communicationstakeholder engagementconsultative mindsetproblem-solvingteam leadershipproject managementorganizationinfluencingcollaborationadaptability