Senior Business Intelligence Data Architect (Remote)

Ameris Bank - Atlanta, GA

Full-time - Senior

Remote - Atlanta, GA

Credit Intermediation and Related Activities

About the position

The Senior Business Intelligence Data Architect at Ameris Bank is responsible for creating and maintaining shared datasets within Power BI, focusing on making data from the Enterprise Data Warehouse accessible for reporting and self-service users. This role involves mentoring team members, identifying relevant data for inclusion in the data warehouse, and promoting a data-driven culture within the organization. The position requires advanced technical skills in data modeling, SQL, and Power BI, along with a strong understanding of data governance and compliance in the financial sector.

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.

Requirements

• 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.
• 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.
• Bachelor's degree in a technology field or commensurate work experience required.

Nice-to-haves

• Microsoft Certified: Data Analyst Associate or Azure Data Engineer Associate certifications are a plus.

Benefits

• Medical, Dental and Vision Insurance
• Life Insurance provided at no additional cost to employees
• Accidental Death & Dismemberment Coverage
• Long-Term Disability Coverage
• Paid Sick and Vacation Leave
• 11 Holidays
• Volunteer/Service Day
• Employee Stock Purchase Plan
• 401(k) Retirement Plan with 50% match on first 8% contributions
• 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
• Tickets at Work (Entertainment discounts for Ameris Bank Employees)
• AT&T Employee Discount
• Wellness Discounts for Medical Premiums and Other Rewards
• Employee Referral Incentive
• Education Assistance
• Employee Resource Groups