ETL Developer - Wisconsin Rapids, United States - Quartz

Description

Overview

Join the forefront of healthcare innovation at Quartz, a provider-sponsored health plan dedicated to enhancing member care through advanced analytics and technology-driven solutions. Our commitment to improving healthcare outcomes and driving operational excellence is at the core of everything we do. If you're passionate about leveraging data to revolutionize healthcare, Come Find Your Spark at Quartz

Quartz seeking an ETL Developer to join our Enterprise Data Management (EDW) Team. This position will collaborate with members of the Team to develop and deliver ETL (Extract, Transformation, and Load) applications using data warehouse design best practices. This role will also analyze data requirements, complex source data, target data models and is responsible for the design, development, and maintenance of ETL processes for the EDW (Enterprise Data Warehouse), data marts, and outbound data delivery. This position will also document data flows, provide supporting documenting, and communicate impact of changes and required development to technical and non-technical staff.

Benefits:

• Work in new cloud-based data architecture leveraging snowflake and Azure environment
• Develop data solutions for growing analytic needs across the organization
• Collaborative work environment that fosters high performance with a customer focus, while ensuring a healthy work-life balance
• Full-time in-person, hybrid, or remote work options available
• Starting salary range based upon skills and experience: $71,000 - $90,000 plus robust benefits package

Responsibilities

• Translate data movement requirements into technical ETL design.
• Develop ETL workflows and mappings to extract, transform, and load data into target environments.
• Develop test plans and perform unit testing of own work.
• Create supporting documentation for new ETL processes.
• Identify opportunities for improving efficiency and effectiveness of processes and controls.
• Use standard ETL toolsets to develop and test ETL workflows.
• Work closely with data analysts within Data Warehouse Team to gain an understanding of the business processes and corporate data.
• Determine impacts of data warehouse structures and information flows due to changes in business or technical requirements.
• Perform, root cause analysis, and contribute to the remediation planning and implementation.
• Perform data quality analysis, report data quality issues, and propose solutions for data quality management.
• Participate in on-call rotation (after hours, nights and weekends).

Qualifications

• Bachelor's degree in computer science or related field or comparable experience and continuing education related to the position
• 2+ years of Information Technology experience, industry ETL software or equivalent integration processes, normalized relational databases and dimensional data warehouse implementations, complex SQL query development, and translating business and data requirements into technical solutions
• Proficiency in ETL tools (Informatica PowerCenter, IBM InfoSphere DataStage, Pentaho, Talend or similar)
• Proficiency in SQL development preferably on multiple database management platforms
• Working knowledge of data warehousing concepts, data structures, and ETL best practices concepts
• Intermediate experience with query tools (BusinessObjects, Cognos, MS Query or SAS) is very beneficial
• Effective problem solving and analytical skills
• Ability to manage multiple projects simultaneously and delivery results in a timely manner
• Ability to understand and discuss technical software issues with others
• Ability to work independently, under pressure, and be adaptable to change
• Effective interaction with external and internal parties, including vendors and contractors

This position can work 100% remotely or from our office in Madison, WI in a hybrid or full-time on-site arrangement, if preferred. 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, Affirmative Action 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.