Sr. Architect - R01557361 at Brillio

Edison, New Jersey, United States

Apply Now

Not SpecifiedCompensation

Senior (5 to 8 years), Expert & Leadership (9+ years)Experience Level

Full TimeJob Type

UnknownVisa

Pharmaceutical, TechnologyIndustries

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
Very strong SQL and Informatica (PowerCenter & IICS) capabilities
Deep understanding of Pharma datasets and commercial analytics
Proven consultative approach with ability to drive thought leadership and business impact
Excellent stakeholder management

Responsibilities

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

Skills

Key technologies and capabilities for this role

ETLSQLAlationTalendMatillionPythonData WarehousingIICSSnowflakeInformatica PowerCenterData ModellingPLSQLT-SQLStored Procedures

Questions & Answers

Common questions about this position

What experience level is required for this Sr. Architect role?

The role requires 8+ years of experience in data engineering and ETL, with hands-on expertise in Informatica (PowerCenter and IICS).

What are the primary technical skills needed for this position?

Key skills include ETL fundamentals, SQL (basic and advanced), Informatica PowerCenter and IICS, Snowflake Data Warehouse, data modeling, Python, data warehousing, and tools like Alation, Talend, Matillion.

Is this a remote position or does it require office work?

This information is not specified in the job description.

What is the salary or compensation for this role?

This information is not specified in the job description.

What does Brillio's company culture emphasize?

Brillio emphasizes attracting exceptional talent through contemporary technologies, exclusive digital projects, dedication to client satisfaction, nurturing employee potential, and holds Great Place to Work® certification year after year.

Brillio

Technology consulting for digital transformation

About Brillio

Brillio helps businesses with their digital transformation by providing technology consulting services. The company focuses on creating customized digital solutions that utilize artificial intelligence and cloud technologies to meet the specific needs of each client. This includes improving operational efficiency and enhancing user experiences through real-time responses and better workflows. Brillio serves a variety of clients, including large Fortune 500 companies, with a strong emphasis on the healthcare sector. Unlike many competitors, Brillio's approach is centered on developing bespoke solutions that give clients a competitive advantage, aiming to help them evolve into 'generative enterprises.' The company's goal is to drive significant improvements in business operations and outcomes through its consulting services and technology implementations.

Edison, New JerseyHeadquarters

2014Year Founded

LATE_VCCompany Stage

Consulting, AI & Machine Learning, HealthcareIndustries

1,001-5,000Employees

Benefits

Remote Work Options

Risks

High competition in tech may impact Brillio's talent acquisition and service scaling.

Over-reliance on healthcare exposes Brillio to sector-specific regulatory and funding risks.

Expansion into new markets may stretch resources, leading to potential operational inefficiencies.

Differentiation

Brillio specializes in bespoke digital solutions for diverse industries, focusing on AI and cloud.

The company is recognized as an Enterprise Innovator in healthcare payer services.

Brillio's Cloud and AI Studio aims to modernize enterprise IT systems and optimize workflows.

Upsides

Increased demand for AI-driven healthcare solutions boosts Brillio's market potential.

Expansion in India enhances service delivery and innovation through a growing tech talent pool.

Recognition in Open Banking IT Services highlights Brillio's role in financial digital transformation.

Land your dream remote job 3x faster with AI

Try Jobo Free