First American Bank
Operations Innovation Analyst II - Remote
First American Bank, Elk Grove Village, Illinois, United States, 60007
Operations Innovation Analyst II
First American Bank was founded in Chicago, and over the years has expanded throughout Wisconsin and Florida. As the largest privately held bank in Illinois, we now have over 60 locations and assets of $5+ billion. We are a community bank at heart with international expertise, traditional values, and a forward-looking philosophy. Our employees have the experience and vision to meet the needs of savers, borrowers, and businesses in the 21st century. First American Bank can offer employees a level of visibility, career growth, and stability that is difficult to find in many larger corporations. The Operations Innovation Analyst II is a remote position responsible for designing, revising, and publishing advanced Power BI reports and dashboards and Microsoft Access databases by integrating data from diverse sources and applying complex queries, DAX measures, and automated workflows. The position maintains proficiency in Power Platform, SharePoint, and data management tools, along with the ability to document processes, collaborate across teams, and support report development and analysis. Additionally, the analyst contributes to process improvement and supports business decision-making through data-driven insights, with continuous learning and proactive problem-solving being essential to success. Duties & Responsibilities: Create, revise, and publish complex Power BI reports and dashboards, involving linking to various data sources. Leverage Power Query to establish data relationships, develop DAX for calculated measures, and utilize Power Automate to design and implement automated workflows. Create highly organized Microsoft Access databases using numbered queries and consistent naming conventions. Link Access databases to a variety of data sources. Create detailed 'Build Notes' using Microsoft Word or OneNote. Build and manage various query types. Design user-friendly forms, reports, embedded sub-reports, and macros. Develop advanced query definitions and criteria. Manage SharePoint environments. Proactively utilize internal procedures. Pursue ongoing professional development. Regularly utilize in-house resources. Work independently, alongside other department staff members. Provide insight and recommendations on process improvements. Understand project stakeholders' needs. Assist with training and coaching for less experienced support staff. Work alongside the department management and other First American Bank departments. Take ownership of errors. Conduct and complete additional assignments/projects. Qualifications: High School Diploma or equivalent required. Bachelor's Degree preferred. Minimum three years of experience applying business analysis skills. Knowledge of retail lending, mortgage loans, GSE loans and experience in loan servicing and investor reporting preferred. Strong organizational skills. Demonstrate initiative and the ability to work independently within a deadline. Ability to introduce concepts, discuss analyses, and present conclusions. Must be professional, comfortable speaking with external and internal contacts. Demonstrated ability to convey thoughts and ideas effectively. Maintain credibility through professional demeanor. Must be able to simultaneously work on multiple assignments. Ability to exercise sound judgment. Maintain good working relationships with internal partners. Use sound professional judgment. Proficiency with Microsoft 0365 products. Proficiency with Microsoft Power Platform required. Demonstrated ability to learn new systems. A strong aptitude for database management. Prior design experience with MS Access is required. Prior experience with Jack Henry Silverlake is preferred. This position may require periodic travel. Typical scheduled hours are Monday through Friday. Punctuality is required.
First American Bank was founded in Chicago, and over the years has expanded throughout Wisconsin and Florida. As the largest privately held bank in Illinois, we now have over 60 locations and assets of $5+ billion. We are a community bank at heart with international expertise, traditional values, and a forward-looking philosophy. Our employees have the experience and vision to meet the needs of savers, borrowers, and businesses in the 21st century. First American Bank can offer employees a level of visibility, career growth, and stability that is difficult to find in many larger corporations. The Operations Innovation Analyst II is a remote position responsible for designing, revising, and publishing advanced Power BI reports and dashboards and Microsoft Access databases by integrating data from diverse sources and applying complex queries, DAX measures, and automated workflows. The position maintains proficiency in Power Platform, SharePoint, and data management tools, along with the ability to document processes, collaborate across teams, and support report development and analysis. Additionally, the analyst contributes to process improvement and supports business decision-making through data-driven insights, with continuous learning and proactive problem-solving being essential to success. Duties & Responsibilities: Create, revise, and publish complex Power BI reports and dashboards, involving linking to various data sources. Leverage Power Query to establish data relationships, develop DAX for calculated measures, and utilize Power Automate to design and implement automated workflows. Create highly organized Microsoft Access databases using numbered queries and consistent naming conventions. Link Access databases to a variety of data sources. Create detailed 'Build Notes' using Microsoft Word or OneNote. Build and manage various query types. Design user-friendly forms, reports, embedded sub-reports, and macros. Develop advanced query definitions and criteria. Manage SharePoint environments. Proactively utilize internal procedures. Pursue ongoing professional development. Regularly utilize in-house resources. Work independently, alongside other department staff members. Provide insight and recommendations on process improvements. Understand project stakeholders' needs. Assist with training and coaching for less experienced support staff. Work alongside the department management and other First American Bank departments. Take ownership of errors. Conduct and complete additional assignments/projects. Qualifications: High School Diploma or equivalent required. Bachelor's Degree preferred. Minimum three years of experience applying business analysis skills. Knowledge of retail lending, mortgage loans, GSE loans and experience in loan servicing and investor reporting preferred. Strong organizational skills. Demonstrate initiative and the ability to work independently within a deadline. Ability to introduce concepts, discuss analyses, and present conclusions. Must be professional, comfortable speaking with external and internal contacts. Demonstrated ability to convey thoughts and ideas effectively. Maintain credibility through professional demeanor. Must be able to simultaneously work on multiple assignments. Ability to exercise sound judgment. Maintain good working relationships with internal partners. Use sound professional judgment. Proficiency with Microsoft 0365 products. Proficiency with Microsoft Power Platform required. Demonstrated ability to learn new systems. A strong aptitude for database management. Prior design experience with MS Access is required. Prior experience with Jack Henry Silverlake is preferred. This position may require periodic travel. Typical scheduled hours are Monday through Friday. Punctuality is required.