Data Analyst

Company: First National Bank of America
Location: East Lansing
Posted on: January 22, 2023

Job Description:

OverviewFirst National Bank of America is seeking an individual who enjoys extracting and presenting meaningful data to management and co-workers to assist in the daily management of their areas. As a Data Analyst, you will work closely with all departments within the bank from the mailroom to the board room to provide meaningful insight into the Bank's portfolio and processes through the metadata management, development of reports, and ad hoc queries.ResponsibilitiesDaily work would include:

• Identify, extract, and integrate data from multiple sources
• Conduct trend and predictive analysis
• Document and maintain data presentation/visualization requirements, mockups, and wireframes
• Design SQL queries, DAX expressions, and Power BI reports for departments throughout the organization to assist with departmental work-flow, portfolio management, and historical reporting
• Participate in work stream planning process including inception, technical design, development, testing and delivery of BI solutions
• Identify and document metadata issues across all assigned data domains
• Understanding of the metadata captured to manage data and participate in the creation and maintenance of metatdata in the metadata tool
• Validate that a project's requirements have been thoroughly tested to prevent any negative impact to existing programsQualificationsA preferred candidate will have:
  • Minimum of 3 years' experience in business intelligence, data management, dashboard development, and digital analytics
  • A passion for technology and initiative in using creative approaches to analyze business data
  • Proficiency reading and writing SQL queries
  • Proficiency reading and writing PowerQuery M and DAX
  • Proficiency with Microsoft Azure, SQL Server, SSRS, and Power BI Desktop/Services
  • Experience with the translation of user requirements, existing SSRS reports and/or SQL queries into organized dynamic Power BI datasets, reports, dashboards, and inherent drill-paths
  • Experience with data catalog, glossary, dictionary, and lineage maintenance
  • Experience with formal SDLC controls and processes (e.g., Source Control, Change and Release Management, Quality Assurance, etc.)
  • Experience/knowledge with ITIL, DevOps, and CI/CDEmployee benefits
    • Medical - Multiple plans to choose from including HSA and traditional. Premiums as low as $0.00
    • Dental - Premiums as low as $0.00
    • Vision - Low premium Plan
    • Paid Time Off (PTO)
    • 401k with employer match
    • Adjustable desks that can be raised or lowered to sit or stand First National Bank of America recognizes that the quality of our people is the foundation for our success. Attracting exceptional individuals who value a challenging work environment that rewards the contributions of its people is the cornerstone of our hiring philosophy.Job Type: Full-time Location: East Lansing, MI - not a remote position Note: These statements are intended to describe the general nature and level of work involved for this job. It is not an exhaustive list of all responsibilities, duties, and skills required for this job.First National Bank of America is an Equal Opportunity Employer.

Keywords: First National Bank of America, East Lansing , Data Analyst, Professions , East Lansing, Michigan