Sr Data Analyst

About Client:
The client provides information technology (IT) services, including business outsourcing, infrastructure technology, and application services. The application service offered by the company includes application development, maintenance, and support. The markets served by the company are financial services and insurance, healthcare, manufacturing, government, transportation, communications, and consumer and retail industries.
Rate Range: $55-$60 per hour on C2C (All Inclusive)
Job Description:

• Seeking a Senior Data Analyst to help with the data needs to support the Commercial Lending Portfolio Migration. Must have Commercial lending and lending accounting systems specifically AFS Level III, technical expertise for analyzing the data, designing, and presenting in a way to assist the businesses, project teams.
• Performing analysis to assess the quality and meaning of data required.
• Understanding and working with various table structures as well as the data warehouses, lakes that are either primary or secondary sources such as Snowflake.
• Knowledge of programming languages like Python , ETL framework , reporting packages
• Using tools like Tableau, Microsoft Tools (excel) to represent the data in a visual format that is easy to understand.
• Reviewing, ensuring accuracy of the data and recognizing anomalies in data between the data warehouse, data tapes and the loan accounting systems
• Research and documentation of the data analysis against each of the commercial portfolio from the loan accounting system specifically AFS Level III
• Map the fields, tables from AFS Level III to a target accounting system for migration purposes.
• Assist in the on-going monitoring and review of existing transactions to support servicing teams as part of the ongoing production support.
• Preferably experience with Heritage First Republic Commercial Lending Core Systems i.e AFS Level III , Loan Vantage ; Enterprise Data Marts
• Familiar with the full SDLC and with production support experience.
• Agile experience required.

• Perform duties and responsibilities specific to department functions and activities.
• Bachelor’s Degree in Computer Science required.
• Strong technical skills and demonstrated ability to quickly learn and adapt to and use new technologies.
• Demonstrated analytical and problem-solving skills; including experience analyzing business problems, identifying solutions and driving the team to the solution.
• Excellent Verbal and Written Communication skills; meeting facilitation and experience communicating and presenting solutions for business problems to business stakeholders;
• Outstanding organization and prioritization skills
• Experience with multitasking and to function efficiently in a high volume, high risk and fast paced deadline-oriented environment.
• Self-starter requiring minimal oversight to achieve defined goals.

• Scala
• SQL

About ApTask:
Join ApTask, a global leader in workforce solutions and talent acquisition services, as we shape the future of work. We offer a comprehensive suite of offerings, including staffing and recruitment services, managed services, IT consulting, and project management, providing unparalleled opportunities for professional growth and development. As a member of our dynamic team, you'll have the chance to connect businesses with top-tier professionals, optimize workforce performance, and drive success for our clients across diverse industries. If you are passionate about excellence, collaboration, and innovation, and aspire to make a meaningful impact in the world of work, come join us at ApTask and be a part of our mission to empower organizations to thrive.
Applicants may be required to attend interviews in person or by video conference. In addition, candidates may be required to present their current state or government issued ID during each interview.
Candidate Data Collection Disclaimer:
At ApTask, we prioritize safeguarding your privacy. As part of our recruitment process, certain Personally Identifiable Information (PII) may be requested by our clients for verification and application purposes. Rest assured, we strictly adhere to confidentiality standards and comply with all relevant data protection laws. Please note that we only collect the necessary information as specified by each client and do not request sensitive details during the initial stages of recruitment.
If you have any concerns or queries about your personal information, please feel free to contact our compliance team at businessexcellence@aptask.com