Lead Data Analyst
Location: East Pittsburgh, PA
Client is a national financial services firm.
Position Overview:
This crucial role will be responsible for leading system enhancements and modifications to the deposit insurance calculator ETL processes. The candidate will collaborate closely with business subject matter experts and technology teams to refine calculator logic and processes, develop actionable requirements, and oversee thorough testing to ensure accurate and successful deployment of updates into production.
This role demands a blend of technical expertise, project management capabilities, and a profound understanding of financial services.
Key Responsibilities:
- Lead the development and implementation of system enhancements and corrections for the deposit insurance calculator ETL.
- Collaborate with business subject matter experts and technology teams to identify opportunities for process improvement.
- Create and communicate detailed business requirements and action plans.
- Manage multiple projects, ensuring timely completion of all phases, from development to testing and production deployment.
- Perform SQL queries on the calculator’s database to support enhancements and troubleshooting.
- Transition from project-based responsibilities to business-as-usual (BAU) support functions over time.
Qualifications:
Experience:
- 5–7 years of relevant experience, preferably within the financial services industry.
- Extensive experience with SQL for querying databases.
- Hands-on experience working with developers in a production environment.
- Knowledge of bank regulatory reporting, including Axiom, is highly desirable.
Technical Skills:
- Proficiency in SQL and Python.
- Database experience within financial services, with a solid understanding of banking products and bank balance sheets.
Education:
- Master’s Degree required.
Preferred Skills:
- Strong project management skills with the ability to handle multiple priorities concurrently.
- Excellent written and verbal communication skills to clearly articulate business requirements.
- Self-motivated individual with the ability to lead initiatives from inception to completion with minimal supervision.