Database Analyst

Description:

Database Analyst 

Typical Day in Role:

• Conduct data, application, and workflow analysis

• Perform data modeling to define the appropriate structures for new requirements

• Design database objects (tables, views, functions, stored procedures)

• Develop and optimize T‑SQL code

• Ensure high-performance execution of queries and procedures

• Participate in meetings, requirement discussions, development, and debugging

• Work primarily in Microsoft SQL Server environments

Candidate Requirements/Must Have Skills:

1. 8+ years SQL Server Database development and advanced T‑SQL programming

2. 7+ years experience in Data Modeling, Data Architecture, Data Integration, Data Interfaces, or Database Design

3. 7+ years hands-on Database/SQL performance tuning

4. 5+ years experience working with data models in ERP, CRM, or other large OLTP applications

Nice-To-Have Skills:

1. Experience with ETL or BI tools such as SSIS, SSAS, Informatica, or DataStage

2. Experience with BI visualization tools: Power BI, Tableau, OBIEE

3. Solid understanding of Web Services, .NET, XML, SOAP, REST, APIs, or Java

4. Prior experience in financial services or banking