Job Description
Job Overview
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 Type: Full-time
Pay: $65,000.00 - $75,000.00 per year
Benefits:
• 401(k)
• 401(k) matching
• Dental insurance
• Health insurance
• Paid time off
• Vision insurance
Compensation Package:
• Bonus opportunities
• Performance bonus
Schedule:
• Day shift
• Monday to Friday
Application Question(s):
• Are you a U.S. Citizen or hold a valid VISA?
Education:
• Bachelor's (Required)
Experience:
• ETL: 5 years (Required)
• Pentaho: 4 years (Required)
Language:
• English (Required)
Shift availability:
• Day Shift (Required)
Ability to Commute:
• Chicago, IL 60606 (Required)
Willingness to travel:
• 50% (Required)
Work Location: Hybrid remote in Chicago, IL 60606