ETL/SQL Data Analyst

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