Senior Business Intelligence Data Architect (Remote)

Ameris Bank; Atlanta (GA); Remote; USD 90,000 - 130,000; Full time

Job summary

Join a purpose-driven company as a Senior Business Intelligence Data Architect, where your expertise in data modeling and Power BI will be pivotal in shaping data solutions. This role offers an opportunity to develop shared datasets, mentor team members, and enhance data accessibility across the organization. You'll work in a collaborative environment focused on delivering financial peace of mind to communities. If you're passionate about data and eager to make a difference in the banking sector, this position is perfect for you. Embrace the chance to influence a data-driven culture and contribute to impactful projects.

Benefits

Medical, Dental and Vision Insurance

Life Insurance

Long-Term Disability Coverage

Paid Sick and Vacation Leave

Employee Stock Purchase Plan

401(k) Retirement Plan

Flexible Spending Accounts

Health Savings Account

Education Assistance

Employee Assistance Program

Qualifications

• 8+ years of experience in Business Intelligence or Data Warehousing.
• Strong knowledge of Microsoft Power BI and SQL.
• Experience in the banking or financial industry preferred.

Responsibilities

• Develop shared data models from the Enterprise Data Warehouse.
• Assist with migrating data to Power BI from other platforms.
• Mentor team members and promote a data-driven culture.

Skills

Microsoft Power BI

DAX

PowerQuery/M

SQL Queries

Dimensional Modeling

Data Governance

Performance Optimization

Excel

Agile & Scrum Methodologies

Python

Education

Bachelor’s degree in a technology field

Tools

Microsoft Azure

Visual Studio

SSIS

Job description

Senior Business Intelligence Data Architect (Remote)

Job Category: Data and Analytics

Requisition Number: SENIO005695

Posted: January 16, 2025

Employment Type: Full-Time

Location

Atlanta, GA 30305, USA

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.

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:

1. Develops Shared Data Models from the Enterprise Data Warehouse.
2. Assists with migrating from other reporting platforms, including SSAS & Business Objects, by making the data available in Power BI.
3. Creates Prototype Data Solutions to help validate user requests & shape Data Warehouse requirements.
4. Investigates & analyzes data sources to identify relevant information for inclusion in our data solutions.
5. Assists with creating requirements & user-stories to bring additional data into the Enterprise Data Warehouse.
6. 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.
7. Manages and administers Power BI Premium Capacities.
8. Performs routine maintenance and performance tuning as required.
9. May assist with creating various reports, including exploratory and explanatory analysis packages.
10. Provides production support as needed.
11. Knowledge shares and mentors other members of the team & bank.

Required Knowledge, Skills and Competencies:

1. Advanced knowledge working with Microsoft Power BI, including a strong knowledge of DAX, and PowerQuery/M.
2. Experience working with Microsoft Fabric and/or Microsoft Azure.
3. Advanced knowledge writing SQL Queries & Views & Stored Procedures, with the ability to use CTEs, Temp Tables, Indexes.
4. Expertise in dimensional modeling and star-schema design for BI applications.
5. Excellent initiative, innovative thinking skills, and the ability to analyze details and properly organize them into the overall data strategy.
6. Strong understanding of data governance, security and compliance in the financial sector.
7. Proven ability to optimize performance for large-scale datasets.
8. Proficient with using Excel for basic data quality & validation checks.
9. Understanding of software development standards & practices, including the Agile & Scrum methodologies, versioning & source control, and change management.
10. Familiarity with development tools & languages including Visual Studio, C#, SSIS and Python.
11. Excellent communication and collaboration skills, with the ability to explain complex technical concepts to non-technical stakeholders.
12. Familiarity with data visualization techniques and best practices.
13. Familiarity with banking & financial industry terminology & practices.

Industry and Work Experience:

1. 8+ years of experience in a Business Intelligence and/or Data Warehousing Environment.
2. 1+ year of experience managing Premium Capacities within the Power BI service preferred.
3. Banking and/or financial industry experience strongly preferred.
4. Microsoft Certified: Data Analyst Associate or Azure Data Engineer Associate certifications are a plus.
5. Bachelor’s degree in a technology field or commensurate work experience required.

Benefits Available to Employees:

• Medical, Dental and Vision Insurance
• Life Insurance provided at no additional cost to employees
• Long-Term Disability Coverage
• Paid Sick and Vacation Leave
• 11 Holidays
• Employee Stock Purchase Plan
• 401(k) Retirement Plan
• Flexible Spending Accounts
• Health Savings Account
• Health Reimbursement Arrangement
• Supplemental Life & Other Insurance Plans
• Identity Theft Protection
• Pet Insurance
• Legal Insurance
• Employee Assistance Program
• Employee Advocacy Program
• Education Assistance
• Employee Resource Groups

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.