Job SummaryThe Business Intelligence (BI) Reporting Developer is responsible for designing, developing, and maintaining enterprise reporting in support of data-driven decision making across the organization This role will partner closely with business stakeholders and data teams to translate business requirements into scalable solutions that achieve strategic objectives. The BI Reporting Developer will design and develop reports using Power BI and Power BI Report Builder using SQL queries, published datasets, and DAX. This role will also play a lead role in strategic projects as needed. Performs other projects and duties as assigned.
Essential Functions, Duties and Responsibilities- Design, develop, and maintain Power BI reports in accordance with documented procedures.
- Work with various business units on requests that require data analysis, business analysis and documentation of processes.
- Optimize report performance and design to improve usability and encourage enterprise-scale adoption.
- Gather business requirements and translate into technical requirements for the development teams.
- Dig deep into various systems using SQL queries to validate that the requested data exists and can be accessed.
- Upon discovery of data, document process and work with development team and other BI Developers to integrate into reporting systems.
- Act as a mentor for other BI Developers that are heavy business focused and provide technical expertise to the team with SQL and data analysis.
- Support report deployment, testing, and promotion through development, UAT, QA, and production environments.
- Documents process and findings and provide updates to stakeholders.
- Performs custom report or application development on an as-needed basis.
Required Knowledge, Skills and Competencies- Strong proficiency with SQL queries required. Familiarity with MDX and/or DAX preferred.
- Familiarity with Visual Studio & Microsoft programming languages preferred.
- Proficient with using Excel for basic data quality and data validation checks, with strong data analysis skills.
- Ability to communicate with technical and non-technical users. Ability to present and discuss technical information in a way that establishes rapport, persuades others, and gains understanding from non-technical audiences.
- Strong written and verbal communication skills, with the ability to communicate with internal customers at all levels.
- Experience working within banking, financial services, lending, risk management, or other regulated industries preferred.
- Excellent initiative, innovative thinking skills, and the ability to analyze details and place them into the big picture.
Industry and Work Experience- 5 years of experience in a business intelligence and/or data analytics environment required.
- 2-5 years of experience developing business intelligence, analytics, or reporting solutions required.
- 2+ years of hands-on Power BI development experience required.
Academic- Bachelor's degree in Information Systems, Computer Science, Data Analytics, Finance, Business, or a related field required.
- Microsoft Certified: Power BI Data Analyst Associate preferred.
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.
