ETL Architect

ETL Architect

Job Locations

US-WI

ID

2025-2285

Category

Enterprise Data Management

Type

Regular Full-Time

Overview

Come Find Your Spark at Quartz The ETL Architect will be responsible for the architecture, design, and implementation of data integration solutions and pipelines for the organization. This position will partner with multiple areas in the Enterprise Data Management team and the business to successfully translate business requirements into efficient and effective ETL implementations. This role will perform functional analysis, determining the appropriate data acquisition and ingestion methods, and design processes to populate various data platform layers. The ETL Architect will work with implementation stakeholders throughout the business to evaluate the state of data and constructs solutions that deliver data to enable analytics reporting capabilities in a reliable manner.

Skills this position will utilize on a regular basis:

• Informatica PowerCenter
• Expert knowledge of SQL development
• Python

Benefits:

• Opportunity to work with leading technology in the ever-changing, fast paced healthcare industry.
• Opportunity to work across the organization interacting with business stakeholders.
• Starting salary range based upon skills and experience: $107,500 - $134,400 - plus robust benefits package.

Responsibilities

• Architects, designs, enhances, and supports delivery of ETL solutions.
  • Architects and designs data acquisition, ingestion, transformation, and load solutions.
  • Identifies, develops, and documents ETL solution requirements to meet business needs.
  • Facilitates group discussions and joins solution design sessions with technical subject matter experts.
  • Develops, implements, and maintains standards and ETL design procedures.
  • Contributes to the design of the data models, data flows, transformation specifications, and processing schedules.
• Coordinates ETL solution delivery and supports data analysis and information delivery staff in the design, development, and maintenance of data implementations.
  • Consults and provides direction on ETL architecture and the implementation of ETL solutions.
  • Queries, analyzes, and interprets complex data stored in the systems of record, enterprise data warehouse, and data marts.
  • Ensures work includes necessary audit, HIPAA compliance, and security controls.
• Data Management
  • Collaborates with infrastructure and platform administrators to establish and maintain scalable and reliable data processing environment for the organization.
  • Identifies and triages data quality and performance issues from the ETL perspective and see them through to resolution.
  • Tests and validates components of the ETL solutions to ensure successful end-to-end delivery.
  • Participates in support rotation.

Qualifications

• Bachelor's degree with 8+ years of experience translating business requirements into business intelligence solutions, data visualization, and analytics solution design and development experience in a data warehouse and OLTP (Online Transaction Processing) environments, semantic layer modeling experience, and SQL programming experience.
  • OR associate degree with 11+ years of experience translating business requirements into business intelligence solutions, data visualization, and analytics solution design and development experience in a data warehouse and OLTP environments, semantic layer modeling experience, and SQL programming experience.
  • OR high school equivalence with 14+ years of experience translating business requirements into business intelligence solutions, data visualization, and analytics solution design and development experience in a data warehouse and OLTP environments, semantic layer modeling experience, and SQL programming experience.
• Expert understanding of ETL concepts and commercially available enterprise data integration platforms (Informatica PowerCenter, Python)
• Expert knowledge of SQL development
• Expert knowledge of data warehousing concepts, design principles, associated data management and delivery requirements, and best practices
• Expert problem solving and analytical skills
• Ability to understand and communicate data management and integration concepts within IT and to the business and effectively interact with all internal and external parties including vendors and contractors
• Ability to manage multiple projects simultaneously
• Ability to work independently, under pressure, and be adaptable to change
• Inquisitive and seek answers to questions without being asked

Hardware and equipment will be provided by the company, but candidates must have access to high-speed, non-satellite Internet to successfully work from home.

We offer an excellent benefit and compensation package, opportunity for career advancement and a professional culture built on the foundations of Respect, Responsibility, Resourcefulness and Relationships. To support a safe work environment, all employment offers are contingent upon successful completion of a pre-employment criminal background check.

Quartz values and embraces diversity and is proud to be an Equal Employment Opportunity employer. All qualified applicants will receive consideration for employment without regard to race, religion, color, national origin, sex, gender identity or expression, sexual orientation, age, status as a protected veteran, among other things, or status as a qualified person with disability.

Need help finding the right job?

We can recommend jobs specifically for you
Click here to get started.

---