Position: Trainee/Junior Data Analyst
Company: ELEKS
Category: Data Analyst
Experience required: no_exp
English level: upper

Our client located in the USA/East Cost is the largest and most experienced Asset Liability Management (ALM) solutions provider in the USA. The company helps banks and credit unions to manage balance sheets effectively. The company's proprietary credit union and bank deposit analysis solutions transform data into intelligence by combining strategic insights, industry data, and predictive analytics to enable users to enhance ALM model assumptions and make more informed deposit decisions.

REQUIREMENTS
BS/BA in Information Systems, Finance, Computer Science, Statistics, Mathematics, or related
SQL
Python
Microsoft Excel
Tableau, Power BI, Crystal Reports, or similar report-writing experience
ETL
 Strong analytical skills
 Effective time management and communication skills
Upper-Intermediate level of English
WOULD BE A PLUS
Financial Modeling and/or Analysis
Data Warehousing/Relational
Database Management
System design, development, support, testing, and documentation
RESPONSIBILITIES
Work with a wide variety of data formats (Excel, text, etc.), mapping, cleaning, and loading the data into the project's SQL data warehouse
Validate and analyze data output for the project's suite of analytics software, remediating data quality issues and gaps through data scrubs and/or working with stakeholders to correct and enrich data
Support existing data pipelines, working with a wide variety of flat file data formats from hundreds of financial institutions
Effectively communicate data project objectives with stakeholders, gathering all necessary data items to deliver to product consultants
Utilize business intelligence and reporting tools (e.g. Python, SQL, Tableau), the data warehouse, and financial institution call report data sources to develop ad hoc and standardized reports for internal and external client needs
 Provide data help desk product support to the product management, consulting, financial analytics, and risk management teams
 Assist in the design, documentation, and implementation of the project's next-gen automated data pipelines
 Build, maintain, and execute data quality and data integration test plans using tools such as OwlDQ, SQL, and Python
 Identify gaps and opportunities in data infrastructure and design and build appropriate solutions
 Collaborate with peers and management to identify opportunities to improve client experience