Client Process Analyst - ETL / Database

We are seeking a self-motivated professional with strong technical support skills, proficient in SQL databases and ETL technologies. The ideal candidate will have excellent problem-solving abilities and will be responsible for maintaining data currency, managing the command center, and providing post-implementation support to clients.

Key Responsibilities:

Database Management

• Troubleshoot and maintain SQL scripts using MySQL
• Develop automated scripts, including:
• Providing clear explanations for processing report errors
• Classifying errors, especially where client action is required
• Automate identified business processes by applying best practices in coding, design, quality, and performance
• SQL Performance Tuning: Adjust SQL queries to improve efficiency, including basic indexing and optimizing query execution to handle larger data sets smoothly.

ETL

• Act as the ETL resource for implementation and support tasks
• Build and test scripts to validate data and file integrity
• Create reusable objects such as Pentaho jobs and reusable transformations for business logic
• Error Handling and Monitoring: Set up basic error handling in ETL processes, including logging and notifications to catch issues early and troubleshoot them effectively.

Operational Processes

• Maintain data currency across clients by loading files on time via ETL scripts or the Command Center
• Adjust backend logic to ensure data consistency across all clients
• Create technical documentation for the ETL build-out process
• Collaborate with Product Owners and Business Analysts to execute project plans for implementations

Qualifications:

• Bachelor’s Degree in Business, Computer Science, Information Systems, or related field
• Strong programming and configuration skills with MySQL and Pentaho
• Knowledge of RPA, with preference given to candidates experienced in UiPath programming
• Experience creating ETL transformations and jobs using Pentaho Spoon Designer and Pentaho Data Integration and Scheduling
• Ability to understand business needs and assess impacts on complex operations and systems
• Excellent communication skills, able to collaborate effectively with IT and business teams
• Creative and analytical problem-solving abilities
• Flexibility to support multiple time zones when necessary
• Proficiency in Microsoft Office, including Excel, Word, PowerPoint, Access, and Project

Bonus Qualifications(Not Required):

• Use Git for managing ETL scripts, including tracking changes, collaborating with team members, and maintaining version history for database and ETL processes.
• Leverage tools such as Jenkins for automating ETL processes within a continuous integration and delivery (CI/CD) pipeline, ensuring efficient and reliable deployment of scripts and configurations.

Benefits:

• Comprehensive medical plan
• A culture of open discourse that values new ideas and a self-starter attitude
• Tremendous career growth opportunities

Job Types: Full-time, Permanent

Pay: $65,000.00 - $75,000.00 per year

Benefits:

• 401(k)
• 401(k) matching
• Dental insurance
• Health insurance
• Tuition reimbursement
• Vision insurance

Compensation Package:

• Bonus opportunities
• Performance bonus

Schedule:

• 8 hour shift
• Day shift
• Monday to Friday

Experience:

• ETL: 2 years (Required)
• UiPath / SQL: 2 years (Preferred)

Language:

• English (Required)

Location:

• Chicago, IL 60606 (Required)

Shift availability:

• Day Shift (Required)

Ability to Commute:

• Chicago, IL 60606 (Required)

Ability to Relocate:

• Chicago, IL 60606: Relocate before starting work (Required)

Willingness to travel:

• 25% (Required)

Work Location: Hybrid remote in Chicago, IL 60606

Salary : $65,000 - $75,000