Associate Automation Analyst - EDM Operations
Madison, WI  / Onalaska, WI  / Sauk City, WI 
Posted 5 days ago
Job Description
Associate Automation Analyst - EDM Operations
Job Locations US-WI-Madison | US-WI-Onalaska | US-WI
ID 2022-1637
Category Data Warehouse & Data Analysis
Type Regular Full-Time

Are you a problem solver with an analytical mind set? Do you have a passion for understanding and discussing technical software with others? Do have enjoy translating business requirements into technical solutions?

If so, Quartz is looking for you! Quartz is seeking an Associate Automation Analyst - EDM Operations to join our Data Warehouse Team. This position will collaborate with the Enterprise Data Warehouse (EDW) Team, IT staff, and various business units to design, develop, and deliver applications to automate end to end processes. This role will analyze process requirements, work across teams and with vendors to ensure data delivery and data encryption standards are met for all scheduled and ad-hoc data flows. This role will also be responsible for the design, development, and maintenance of automated processes that support our EDW, data marts, outbound delivery, and integration with other applications. This position will also provide support and monitoring for automation systems during core business hours and after hours as needed. Document process flows, provide supporting documentation, and communicate impact of changes and required development or modifications to technical and non-technical personnel.


    Opportunity to work in a collaborative, team environment
  • Option to work in-person or hybrid, available
  • Starting Salary Range based upon skills and experience: $55,300 - $64,000/year
  • Own and update system components that automate workflows, encryption, delivery, and integration of internal applications, and other business processes as needed.
  • Translate process requirements into technical process design
  • Develop automated workflows and basic to moderately complex custom scripts to support the EDW, data marts, outbound data delivery, and integration with other applications.
  • Execute process simulations and perform unit testing of own work. Perform code review for peers.
  • Create supporting documentation for new automation processes and prepare final process documentation for product deployments.
  • Provide support/monitoring for automation systems during core business hours and after hours as needed. Handle planned and unplanned outages.
  • Basic complexity process automation development and solution delivery. Work closely with the Enterprise Data Warehouse Teams to gain and understanding of the business process.
  • Use custom scripting, workload automation and file transfer tools to develop and test end to end process automation.
  • Develop and maintain automated test scripts used in deployment between environments.
  • Provision and deploy lower level environments as a part of quarterly SDLC (Software Development Life Cycle)
  • Perform root cause analysis and contribute to the remediation planning and implementation.
  • Diagnose and resolve application, configuration, and code level technical issues. Propose solutions for process improvements.
  • Bachelor's Degree in Computer Science or related field and 2 + years of information technology experience
  • OR Associate's degree in Computer Science ore related field and 5 + years of information technology experience
  • Experience with process automation
  • Experience with automation script development
  • Experience translating business requirements into technical solutions
  • Strong communication skills with a passion for bridging the gap between business and technical users
  • Experience with requirements and process documentation
  • Basic experience with some components of enterprise architecture including file transfer and encryption, databases, networking, application servers
  • Basic knowledge of scripting languages (shell scripting, batch scripting, JavaScript, Python, etc)
  • Intermediate knowledge of transmission protocols (XML, JSON, SMTP, SFTP, EDI)
  • Basic knowledge of APIs including REST
  • Basic experience with scheduling, automation tools, and managed file transfer tools
  • Basic knowledge of CI/CD and DevOps tools
  • Exposure to data acquisition and ingestion process and tools
  • Effective interaction with internal and external parties, including vendors and contractors
  • Ability to manage multiple projects simultaneously and deliver results in a timely manner
  • Ability to work independently, under pressure, and be adaptable to change
  • Ability to participate in on-call rotation

This position has the option full-time in the office or in a hybrid capacity at one of our offices located in Madison, WI or Onalaska, WI. 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.

Quartz offers an excellent benefit and compensation package, opportunity for professional growth and a professional culture built upon the foundations of Respect, Responsibility & Relationships. All employment offers are contingent upon successful completion of a pre-employment criminal background check and drug screening.

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.

Need help finding the right job?
We can recommend jobs specifically for you! Click here to get started.

Equal Opportunity Employer of Minorities, Females, Protected Veterans, and Individual with Disabilities


Job Summary
Start Date
As soon as possible
Employment Term and Type
Regular, Full Time
Required Education
Associate Degree
Required Experience
2+ years
Email this Job to Yourself or a Friend
Indicates required fields