Join a modernization-focused team automating reporting and building scalable data products. Lead high-visibility BI and ETL delivery while shaping cloud migration patterns to AWS. Partner closely with stakeholders to create reliable, well-governed insights with real operational impact.
As an Associate within Operations Automation, you lead the automation and optimization of reporting workflows and deliver scalable, low-touch ETL/data integration solutions. You translate business needs into governed BI products, balancing strategic modernization with hands-on execution. You drive migration of legacy/manual processes and data workflows from on-premises platforms to AWS.
Job Responsibilities
- Own end-to-end delivery of BI and ETL initiatives across requirements, design, build, test, deploy, and production support.
- Lead stakeholder engagement by managing expectations, driving decisions, providing status updates, and escalating risks/issues.
- Design robust Pentaho ETL workflows optimized for reliability, performance, reusability, and maintainability.
- Develop Qlik Sense/Tableau dashboards, reporting layers, and automated refresh/validation routines.
- Drive on-prem to AWS workflow migration by recommending target-state patterns and optimizing for cloud operations.
- Implement documentation standards including process flows, runbooks, and data definitions, keeping artifacts current.
- Perform advanced SQL development and query performance tuning using T-SQL and/or PL/SQL.
- Deliver ad-hoc data analysis and production support with strong reconciliation and data integrity checks.
- Identify process gaps, control/risk issues, and automation opportunities, proposing solutions with measurable impact.
- Coordinate cross-functionally to meet deliverables and support change management for new reporting requirements.
- Mentor junior team members through code/design reviews, knowledge sharing, and engineering best practices.
Required qualifications, capabilities and skills
- Bring at least 8 years of hands-on experience in ETL development and BI/reporting delivery.
- Demonstrate strong experience with Oracle and/or SQL Server in enterprise environments.
- Apply advanced SQL and query optimization skills in T-SQL and/or PL/SQL to troubleshoot complex data issues.
- Build BI solutions using Qlik Sense and/or Tableau, including dashboard development and data validation.
- Execute on-premises to AWS migration for data workflows with attention to design, operations, and risk controls.
- Use Unix/Linux effectively, including shell scripting to automate and schedule workflows.
- Deliver strong ownership and execution skills while communicating clearly with technical and non-technical stakeholders.
Preferred qualifications, capabilities and skills
- Use Python for automation, data processing, and tooling.
- Leverage experience implementing CI/CD and release controls for ETL/BI assets.
- Apply knowledge of cloud-native AWS services to improve monitoring, resiliency, and cost efficiency.
- Strengthen data governance through metadata, lineage, and data quality controls.
- Optimize performance across ETL, database, and BI layers using systematic tuning approaches.
- Automate operational checks, reconciliations, and alerting to enable low-touch production support.
- Contribute domain expertise from financial services or consulting to translate business needs into scalable solutions.
