Business Intelligence Database Administrator

Job Summary

The Business Intelligence Database Administrator is responsible for monitoring and administering SQL Servers supporting the Enterprise Data Warehouse. Key duties include securing and optimizing SQL Server performance, developing ETL processes, and supporting and developing reports in Power BI and SSRS.

Essential Functions, Duties And Responsibilities

• Analyze and document business reporting requirements and identify appropriate reporting mechanisms.
• Work with the Business Intelligence Architect to design solutions meeting stakeholder expectations.
• Create functional requirements and design documents.
• Strive to improve BI solutions and other systems through ongoing research and understanding of business needs.
• Assist developers, analysts, and designers in conceptualizing and developing BI solutions.
• Provide expertise and support to end users and other IT support team members.
• Conduct research on emerging BI tools and strategies.
• Communicate with business stakeholders to understand needs and develop BI solutions.
• Design and manage data warehouse improvement and growth projects.
• Identify and resolve data discrepancies and issues ensuring data consistency and integrity.
• Diagnose and resolve data warehouse access and performance issues.
• Execute data warehouse configuration and performance tuning.
• Maintain system details within the data warehouse, including stored procedures, indexes, partitions, query execution time, and implement efficiency improvements.
• Collaborate with the Information Security team to ensure data security measures are in place.

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, and 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.
• Bachelor's degree required.

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
• 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