Database Analyst

Database Analyst is responsible for designing and creating metadata, database architecture and data repository. Develops and maintains company's data repositories and related data marts. Performs data mining and analysis. Determines business information needs, identifies and documents system requirements. Analyzes business intelligence data and provides reports or dashboards as required. Acts as liaison between information technology and business units. Ensures data accuracy. Assesses data extraction, report generation and bugs appearing in operations involving the data warehouse. Develops, maintains and enhances reporting for the credit union working with IT management and end users directly. Drive self-service BI adoption. Performance tunes, troubleshoots, system monitors and administers database servers. 

Essential Functions

1. Program complex SSIS packages to unify separate data sources into a single warehouse.  
2. Design, administer and support in-house and industry standard database, business intelligence and analytics tools, including Microsoft SQL Analysis Services.
3. Automate and optimize routine processes associated to SQL server, SSIS, and data exports. 
4. Document all standard operating procedures related to SQL environment. 
5. Lead efforts to standardize how data is structured, defined, and retained within the data warehouse.   
6. Resolve issues to restore service and maintain optimal performance. 
7. Assist in the management of vendors involved in suppling source data, maintenance of the SQL environment, and systems displaying data outputs.
8. Responsible for designing, implementing, and supporting complex report requests utilizing multiple data sources.
9. Work with different areas of the business to identify data needs, translate into technical requirements and create output able to be understood by all levels of staff.  
10. Interprets results using a variety of techniques, ranging from simple data aggregation via statistical analysis to complex data mining independently.
11. Correlate data results to real world business impact.
12. Manage support desk ticket queues and application requests. 
13. Architect and implement enterprise database design for high availability and disaster recovery.
14. Manage infrastructure and operation changes such as SQL server upgrades, code migrations and application/infrastructure upgrades. 

Additional Functions

1. Assist with additional projects and other duties as assigned by departmental leadership.

Job Specifications

1. A minimum of five (5) years of hands on experience in IT operations with a strong understanding of database structures, theories, principles and practices.
2. A minimum of three (3) years of hands on experience with Microsoft SQL server, including Analysis Services (SSAS).
3. Experience designing ETL processes.
4. Experience writing reports and fulfilling reporting requests for business users. Hands on experience with Microsoft PowerBI (or similar BI tools) is a plus.
5. Bachelor’s degree or equivalent combination of experience and education.
6. Must have experience with replication, mirroring, archiving, query tuning and database design.
7. Must have an understanding of DNS and TCP/IP networking, storage area networks (SAN), MS clustering, virtualized environments, DCP, DTS or SSIS, reporting/SSRS, and data warehousing.
8. Knowledge of reporting, query tools and practices.
9. Knowledge of SSIS packages.
10. Experience automating SQL jobs and administrative tasks.
11. Migration knowledge on SQL server platform.
12. Experience with multiple database platforms is strongly preferred.
13. Experience in a supporting a financial institution a plus.
14. Ability to think creatively.
15. Excellent communication skills.
16. Enjoys working in a team environment.