First American Bank
Operations Innovation Analyst II - Remote
First American Bank, Miami, Florida, United States, 33101
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 an hourly (non-exempt) 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. This is a remote position. 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 various 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, departmental documentation, Google, GitHub, and Copilot. Pursue ongoing professional development. Regularly utilize in-house resources, LinkedIn Learning, and Microsoft Learning. Work independently, alongside other department staff members. Provide insight and recommendations on process improvements. Understand project stakeholders' needs and requirements. Assist with training and coaching for less experienced support staff. Work alongside the department management and other 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 and a desire to work in a fast paced, ever-changing environment. Demonstrate initiative and the ability to work independently. 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 and dexterity to navigate daily challenges. Maintain good working relationships with internal partners. Use sound professional judgment to balance interests. Proficiency with Microsoft 0365 products and applications. Proficiency with Microsoft Power Platform required. Demonstrated ability to learn new systems and applications. 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 8:00 a.m. to 5:00 p.m. CST. 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 an hourly (non-exempt) 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. This is a remote position. 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 various 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, departmental documentation, Google, GitHub, and Copilot. Pursue ongoing professional development. Regularly utilize in-house resources, LinkedIn Learning, and Microsoft Learning. Work independently, alongside other department staff members. Provide insight and recommendations on process improvements. Understand project stakeholders' needs and requirements. Assist with training and coaching for less experienced support staff. Work alongside the department management and other 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 and a desire to work in a fast paced, ever-changing environment. Demonstrate initiative and the ability to work independently. 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 and dexterity to navigate daily challenges. Maintain good working relationships with internal partners. Use sound professional judgment to balance interests. Proficiency with Microsoft 0365 products and applications. Proficiency with Microsoft Power Platform required. Demonstrated ability to learn new systems and applications. 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 8:00 a.m. to 5:00 p.m. CST. Punctuality is required.