Architectural Staff at CetraRuddy collaborating on various cultural, institutional, and residential projects. Seeking to learn from experienced professionals in a supportive environment.
About the role
- ETL Lead architecting data integration solutions with deep experience in data warehousing for pharmaceutical companies. Collaborating with stakeholders to drive insights and optimize ETL workflows.
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.
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
Job title
Job type
Experience level
Salary
Not specified
Degree requirement
Tech skills
Location requirements
Experienced Project Architect at CetraRuddy leading design processes for diverse projects. Overseeing project development and team workflow within a collaborative architecture firm.
Architect Lead at INTEGRIS Health managing application implementations and upgrades while supporting governance and transitions. Leading the Applications team in Oklahoma City, OK.
Project Designer developing conceptual and schematic designs at Ware Malcomb. Fostering client relationships and ensuring design quality with a collaborative team approach.
Leads the design and implementation of enterprise applications for a leader in wire and cable production. Drives integration and compliance for Salesforce and SAP solutions.
Digital System Architect in semiconductor industry writing specifications and leading cross - functional teams on designs. Based in UK, Switzerland, or Germany in a hybrid model.
Customer Value Architect advancing the adoption of Neara platform with enterprise clients. Driving customer engagement and translating solutions into quantifiable ROI.
Principal Hardware Domain Architect overseeing architectural projects for hearing aid accessories. Collaborating with external partners and ensuring architecture meets business and technology opportunities in hearing solutions.
Landscape Architect leading impactful urban design projects with a focus on walkable urbanism. Driving growth and collaboration in a senior leadership role within Arcadis' Placemaking team.
Senior Project Architect providing technical design leadership across architectural disciplines at Stantec. Leading innovation in design and encouraging collaboration with various architectural teams.