Overview
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, and target data models. The ETL Developer 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.
The ETL Developer will utilize the following skills on a regular basis :
- Proficiency in SQL development
- Operational Support of production and monitoring processes, including being part of on-call rotation
- Collaboration and communication skills to work in a team environment with other Enterprise Data Management Teams (Analysts, testers, and other developers)
Benefits :
Work in new cloud-based data architecture leveraging snowflake and Azure environmentOpportunity to utilize Informatica Power Center and Python toolsDevelop data solutions for growing analytic needs across the organizationStarting salary range based upon skills and experience : $71,000 - $90,000 plus robust benefits packageResponsibilities
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 with 2 years of relevant Information Technology experienceOR Associate degree with 5 years of relevant Information Technology experienceOR High School equivalency with 8 years of relevant Information Technology experienceRelevant Information Technology experience is defined as industry standard ETL software or equivalent data 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, SSIS, IBM InfoSphere DataStage, Pentaho, Talend or similar)Experience with Python is preferredProficiency in SQL development preferably on multiple database management platformsWorking knowledge of data warehousing concepts, data structures, and ETL best practices conceptsIntermediate experience with query tools (BusinessObjects, Cognos, MS Query or SAS) is very beneficialEffective problem solving and analytical skillsAbility to manage multiple projects simultaneously and delivery results in a timely mannerAbility to understand and discuss technical software issues with othersAbility to work independently, under pressure, and be adaptable to changeEffective interaction with external and internal parties, including vendors and contractorsWe 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.
Salary : $71,000 - $90,000
