← back to jobs
> job detail
A
📊Analyst

Business Intelligence Database Administrator

Amerisbank ¡ FL-Jacksonville-DeerwoodP
// classified as
Analyst (Dashboards, reporting, ad-hoc analysis.)
posted
2d ago
location
FL-Jacksonville-DeerwoodP
languages
go, sql
tools
ssrs
> stack
gosqlssrs
> description

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 purpose and how you can bring it to life as an Ameris Bank teammate.

Job Summary

The Business Intelligence Database Administrator is responsible for monitoring and administering the underlying SQL Servers that support the Enterprise Data Warehouse. This position requires the ability to secure and optimize SQL Server performance, develop ETL processes to move data from various sources and targets, and support and develop reporting in Power BI and SSRS as needed to support the overall team. This position will interact and work extensively within the Microsoft SQL Server Business Intelligence stack including SQL Server, SSIS, SSRS, and Power BI. Performs other projects and duties as assigned.

Essential Functions, Duties and Responsibilities

  • Analyze and document business reporting requirements and identify the appropriate reporting mechanism that can meet those requirements.
  • Work with the Business Intelligence Architect to design appropriate solutions to ensure that systems can meet stakeholder expectations.
  • Create functional requirements and design documents to ensure business requirements are accurately recorded.
  • Continually strive to improve the efficiency and usability of our BI solutions and other systems by leveraging ongoing research and understanding of business needs.
  • Assist other developers, analysts, and designers in conceptualizing and developing business intelligence solutions.
  • Provide expertise and support to end users and other members of the IT support team.
  • Conduct research on emerging development tools and strategies.
  • Work with all levels of business both verbally and in writing to determine business needs and how to address them with business intelligence tools and platforms.
  • Work with Business Intelligence Architect to create models within the data warehouse and/or changes to existing data stores.
  • Design and manage data warehouse improvement and growth projects.
  • Identify data discrepancies and data quality issues, and work to ensure data consistency and integrity.
  • Diagnose and resolve data warehouse access and performance issues.
  • Execute data warehouse configuration and performance tuning.
  • Monitor system details within the data warehouse, including stored procedures, indexes, partitions, query execution time, and implement efficiency improvements.
  • Work closely with Information Security team to ensure that appropriate measure are being taken to secure data.

Required Knowledge, Skills and Competencies

  • Uses intuition and experience to complement data.
  • Identifies and resolves problems in a timely manner; Gathers and analyzes information skillfully; Develops alternative solutions.
  • Responds promptly to customer needs.
  • Listens and gets clarification; Responds well to questions.
  • Able to deal with frequent change, delays, or unexpected events.
  • Follows instructions, responds to management direction; Takes responsibility for own actions.
  • Exhibits sound and accurate judgment.
  • Approaches others in a tactful manner; Reacts well under pressure; Treats others with respect and consideration regardless of their status or position.
  • Demonstrates accuracy and thoroughness; Looks for ways to improve and promote quality.
  • Observes safety and security procedures.

Industry and Work Experience

  • Minimum 3+ years of experience with SQL Server versions 2016 or above components including integration services, reporting services (Native Mode), and index creation and management required.

Academic

  • Bachelor's degree required.

Benefits Available to Employees:

Ameris Bank provides a comprehensive employee benefit package to all eligible employees.

  • Medical, Dental and Vision Insurance

  • Ameris Bank absorbs a major portion of the cost of healthcare. You become eligible for coverage on the first of the month following 30 days of employment

  • 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

  • Ameris Bank matches 50% of your first 8% of contributions to the 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 

  • 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

Banking Advantages for Employees:

In addition to a wide array of benefits, Ameris Bank employees are also eligible for special bank services.

  • Free Interest Checking

  • Free Safe Deposit Box

  • Free Money Orders, Travelers’ Checks and Cashier Checks

  • Discount on Mortgage Origination Fee

  • Free Online Banking and Free Unlimited Online Bill Payment

  • Employee Banking Perks

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.

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

This employer is required to notify all applicantss of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.