Overview
Come Find Your Spark at Quartz! Quartz seeking a Senior ETL Developer to join our Enterprise Data Management (EDW) Team. This position will be responsible for the creation and maintenance of extract, transform, and load (ETL) logic necessary to cleanse and move data from various source systems into the corporate data warehouse. This role will be responsible for the analysis, design, development, and maintenance of complex ETL processes in the support of data warehouses, data marts, and operational data stores. This position will determine appropriate design for ETL applications and gather information to determine data sources, data targets, data transformation rules, data relationships, and business rules.
The Senior ETL Developer will utilize the following skills on a regular basis :
- Proficiency in working with the Informatica ETL Tool
- 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, Python, and Azure environmentStarting salary range based upon skills and experience : $83,800 - $104,800 plus robust benefits packageResponsibilities
Translate data movement needs into technical ETL designs.Map source systems to logical and physical data models.Monitor and take appropriate steps to maintain integrity of the data warehouse databases including content, security, and privacy issues.Identify opportunities for improving efficiency and / or effectiveness of processes and controls.Work closely with Data Warehouse Team to develop conceptual, logical, and physical data models as needed to meet requirements.Independently design complex Data Warehouse workflows and mappings to extract, transform, and load data into target environments.Design and develop data extraction and transmissions to external vendors.Develop test plans and perform unit testing of own work and that of junior developers.Act as a senior developer by directing junior developers on company protocols, ETL design and coding.Provide technical expertise on ETL design, data modeling, data warehousing, and data integration.Review technical designs, application code and other documentation created by junior developers; provide feedback and remediation to drive completion of a solid design and deployment.Assist in directing priorities and remove obstacles for junior developers according to project plans and known business priorities.Participate in on-call rotation (after hours, nights and weekends).Qualifications
Bachelor's degree in Computer Science or related field with 4 years of Information Technology experienceOR Associate's degree in Computer Science or related field with 7 years of Information Technology experienceOR High School equivalency with 10 years of Information Technology experienceInformation Technology experience is defined as : 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 solutionsAdvanced proficiency in Informatica PowerCenter ETL toolAdvanced proficiency in SQL development, preferably on multiple database management platformsAdvanced knowledge of data warehousing concepts, structures, and ETL best practicesIntermediate experience with query tools (BusinessObjects, Cognos, MS Query or SAS) is beneficialAdvanced 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 othersMust be inquisitive and seek answers to questions without being askedAbility 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 : $83,800 - $104,800
