What are the responsibilities and job description for the IT Data Analyst position at Merchants Capital Corporation?
Description
Our Data Analyst will help assist our Systems Administration team by conducting a full lifecycle analysis to include requirements, activities, and design. Data analysts will develop analysis and reporting capabilities and will also monitor performance and quality control plans to identify improvements. You will independently provide support to internal end-users and assist with projects related to the movement, storage, and access of data. Effective communication and excellent customer service are equally important to technical skills and experience. The ideal person will deliver timely solutions the first time while leaving excellent impressions with users.
After one year as our Data Analyst, you will know you were successful if you are…
- Using automated tools to extract data from primary and secondary sources
removing corrupted data, fixing coding errors, and related problems. - Preparing reports for the management stating trends, patterns, and predictions using relevant data.
- Preparing final analysis reports for the stakeholders to understand the data-analysis steps, enabling them to take important decisions based on various facts and trends.
- Filter Data by reviewing reports and performance indicators to identify and correct code problems.
- Developing and maintaining databases, and data systems – reorganizing data in a readable format.
- Performing analysis to assess the quality and meaning of data.
- Using statistical tools to identify, analyze, and interpret patterns and trends in complex data sets could be helpful for diagnosis and prediction.
- Assigning numerical value to essential business functions so that business performance can be assessed and compared over periods of time.
Requirements
What we are looking for…
- Bachelor’s degree is preferred from an accredited institution and at least 2 years of SQL experience in a corporate environment.
- SSRS and Transact SQL experience required
- Experience with Data Warehouse / Data Lake preferred
- Functional knowledge of Microsoft PowerBI or Tableau required
- Expert-level knowledge of Excel required
- Data-related Certifications desired
Ranked as the top-performing U.S. public bank by S&P Global Market Intelligence, Merchants Bancorp is a diversified bank holding company headquartered in Carmel, Indiana, operating multiple lines of business, including multifamily housing and healthcare facility financing and servicing, mortgage warehouse financing, retail, and correspondent residential mortgage banking, agricultural lending, and traditional community banking. Merchants Bancorp conducts its business through its direct and indirect subsidiaries, Merchants Bank of Indiana, Merchants Capital Corp., Farmers-Merchants Bank of Illinois, and Merchants Mortgage, a division of Merchants Bank of Indiana.
Merchants understands the positive impact of making employees feel valued and is proud to once again be recognized by the Indiana Chamber of Commerce’s Best Places to Work Program. This is the seventh year in a row that Merchants was recognized as a Best Places to Work organization.
PM20
