Ameris Bank is a purpose-driven company, dedicated to bringing financial peace of mind to communities, one person at a time. Whether a customer wants to grow their business, buy a home, or feel confident in their retirement plan, they have a partner in Ameris Bank. We serve customers in our locations across the Southeast, Mid-Atlantic and nationwide through our extensive digital offerings and mobile app.
Delivering financial peace of mind starts with a team that values integrity and rewards ingenuity. At Ameris, you’ll find teammates who are inclusive, collaborative problem-solvers who go the extra mile to support one another and to meet every customer’s needs. When teammates are empowered and bring their diverse perspectives to the table, we create the best possible outcomes for our customers. At Ameris, we know that a growth mindset is key for high performance and fosters an environment that prioritizes continuous improvement. Teammates have access to Employee Resource Groups that serve as advocates and allies as well as professional development opportunities to drive ongoing education. Learn more about our purpose and how you can bring it to life as an Ameris Bank teammate.
The Senior Business Intelligence Data Architect is primarily responsible for the creation and maintenance of shared datasets within Power BI. The role will focus on making data from the Enterprise Data Warehouse and other systems available for consumption in reports & for self-service users. Other functions will include mentoring other team members, identifying relevant data for inclusion in the data warehouse, and furthering the development of a data-driven culture within the Bank. Performs other projects and duties as assigned.
Essential Functions, Duties, and Responsibilities:
· Develops Shared Data Models from the Enterprise Data Warehouse.
· Assists with migrating from other reporting platforms, including SSAS & Business Objects, by making the data available in Power BI.
· Creating Prototype Data Solutions to help validate user requests & shape Data Warehouse requirements.
· Investigating & analyzing data sources to identify relevant information for inclusion in our data solutions.
· Assists with creating requirements & user-stories to bring additional data into the Enterprise Data Warehouse.
· Develops and maintains technical documentation and standards documents to ensure consistency, promote best practices, and facilitate knowledge sharing across the Enterprise Data Team and wider organization.
· Manage and administer Power BI Premium Capacities.
· Performs routine maintenance and performance tuning as required.
· May assist with creating various reports, including exploratory and explanatory analysis packages.
· Provides production support as needed.
· Will knowledge share and mentor other members of the team & bank.
Required Knowledge, Skills and Competencies:
· Advanced knowledge working with Microsoft Power BI, including a strong knowledge of DAX, and PowerQuery/M.
· Experience working with Microsoft Fabric and\or Microsoft Azure.
· Advanced knowledge writing SQL Queries & Views & Stored Procedures, with the ability to use CTEs, Temp Tables, Indexes.
· Expertise in dimensional modeling and star-schema design for BI applications.
· Excellent initiative, innovating thinking skills, and the ability to analyze details and properly organize them into the overall data strategy.
· Strong understanding of data governance, security and compliance in the financial sector.
· Proven ability to optimize performance for large-scale datasets
· Proficient with using Excel for basic data quality & validation checks.
· Understanding of software development standards & practices, including the Agile & Scrum methodologies, versioning & source control, and change management.
· Familiarity with development tools & languages including Visual Studio, C#, and SSIS and Python.
· Excellent time management & prioritization skills.
· Excellent communication and collaboration skills, with the ability to explain complex technical concepts to non-technical stakeholders.
· Familiarity with data visualization techniques and best practices.
· Familiarity with banking & financial industry terminology & practices.
Industry and Work Experience:
· 8+ years of experience in a Business Intelligence and/or Data Warehousing Environment.
· 1+ year of experience managing Premium Capacities within the Power BI service preferred.
· Banking and/or financial industry experience strongly preferred.
· Microsoft Certified: Data Analyst Associate or Azure Data Engineer Associate certifications are a plus.
Academic:
· Bachelor’s degree in a technology field or commensurate work experience required.
Benefits Available to Employees:
Ameris Bank provides a comprehensive employee benefit package to all eligible employees.
Banking Advantages for Employees:
In addition to a wide array of benefits, Ameris Bank employees are also eligible for special bank services.
Disclaimer:
The above job description is meant to describe the general nature and level of work being performed; it is not intended to be construed as an exhaustive list of all responsibilities, duties, and skills required for the position.
All job requirements are subject to possible modification to reasonably accommodate individuals with disabilities. Some requirements may exclude individuals who pose a direct threat or significant risk to the health and safety of themselves or other employees.