Business Intelligence Engineer

Overview

The Business Intelligence Engineer will be responsible for the design, development, maintenance, and enhancement of reports that are executed on an automated subscription schedule or on demand by users in various business areas. You will become familiar with data and business processes supported by the data warehouse and operational computer applications as needed to support report development and resolve technical issues. You will be working independently and within a team and will be responsible for tracking the work assigned to reporting team members, resolve technical issues and estimate and schedule tasks. Business matters will be treated with the utmost urgency and focus on results and deadlines until each task or project is completed is key. The qualified candidate will display excellent problem solving, analytical, communication, coordination, and task management skills. Daily activities will include reviewing existing production reports, participating in daily planning meetings, providing estimates, handling ad-hoc requests, and tracking and communicating daily progress on projects and initiatives. This position will also take on various responsibilities throughout the department as assigned. Essential FunctionsReasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

•  Assists new developers in understanding ACA’s processes, procedures, and workflow; hold knowledge sessions to assure clarity and content of training materials
• Identify and recommend technical and process trainings
• Assist the manager in driving department initiatives
• Define and document standards, guidelines and processes for report development and support
• Ensure that Reporting, Data Warehouse and Database standards, guidelines and processes are followed
• Provide architecture and design guidance to the developers; perform design and code reviews
• Resolve technical issues in the report environment and provide alternate solutions
• Lead reporting projects tasks, estimate effort, schedule tasks and drive project deliverables and schedules
• Lead the requirement gathering from business users, review requirements
• Work with business users to understand Reporting problems and provide solutions
• Architect and Design solutions to meet reporting requirements
• Ensure that the Reporting documentation is kept up to date
• Optimize report performance and enhance Reporting Environment
• Communicate project status with management
• Suggest Process improvements across data warehouse and reporting systems
• Administration of report server applications
• Monitor and support (includes On-Call Support) IT Reporting Environment
• Stay up to date on changes in reporting technology landscape, recommend software upgrades and evaluate and adapt to new technologies
• Other tasks as assigned

Qualifications

• Bachelor’s degree (Business, Math, Economic, Finance, Statistics, Science, Engineering, IT) preferred
• 5 years of Experience with modern reporting software – SSRS & Power BI Preferred
• Solid understanding of relational databases and business data; ability to write SQL queries
• Fluent in Microsoft Office applications (Access, Word, Excel)
• Experience with Redshift, SQL Server & TSQL preferred
• Experience with Bit Bucket preferred
• Lending Experience is a plus
• Ability to work independently or in a group
• Ability to prioritize and manage multiple responsibilities
• Flexibility and openness to change; demonstrates high levels of professionalism and organizational skills
• Communicating clearly and concisely to individuals from various backgrounds
• Ability to influence others through verbal and written communication
• Ability to learn new technology and quickly adapt to technology changes
• Demonstrates excellent leadership and coaching abilities  

Supervisory ResponsibilityTeam Lead Work Environment and Physical DemandsThis job operates in a professional office environment. This role routinely uses standard office equipment such as computers, phones, photocopiers, filing cabinets and fax machines. Position Type/Expected Hours of WorkThis is a full-time position. Days of work are Monday through Friday. The daily schedule may vary from 8 am to 5 pm or 9 am to 6 pm. Hours may vary or exceed 40 in any given week depending on the needs of the business.

TravelNo travel is expected for this position. EEO StatementACA provides equal employment opportunities (EEO) to all applicants for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state and local laws. ACA complies with applicable state and local laws governing non-discrimination in employment in every location in which the company has facilities. Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.

#LI-BP1