Database Analyst - Onsite at Viva USA Inc.
Chicago, IL 60601
About the Job
Title: Database Analyst - Onsite
Mandatory skills:
MS SQL Server, SSIS,
SQL programming,
PC windows-based applications, Excel, Access, VBA, SQL, VB,
Tableau, SharePoint,
data requirements, data parameters, data reports.
Description:
Database Analyst
Job Purpose:
This position is responsible for designing and developing applications, databases and reports based on long-term business strategy including major enhancements to existing functionality and user tools.
Job Responsibilities:
Develop, maintain, and enhance complex databases used for a variety of areas and functions using SQL, VB, VBA, Access, Excel and other software as applicable.
Work with users to capture and analyze business and data requirements necessary to meet business needs and corporate strategies/goals.
Write programs, develop and maintain distributed architecture databases for major corporate functions and develop required reporting.
Evaluate and recommend to management appropriate hardware/software platform upgrades.
Maintain documentation of all requests, data parameters and reports in an accurate and accessible manner.
Streamline reporting as much as possible by automating queries, etc. and/or placing reports in production to minimize manual efforts.
Required Job Qualifications:
Bachelors degree and 5 years experience in areas of information technology and 2 years of relevant database and application development experience.
Strong SQL expertise with the ability to write complex queries.
MS SQL Server & SSIS experience
Create, update, and maintain indexes, stored procedures, and triggers.
Demonstrated experience in troubleshooting, resolving database problems, and tuning database/objects
Design, implement, and maintain database objects (tables, views, indexes, etc.)
Understanding of database design practices, including database normalization concepts
Must be analytical, results-driven and able to employ the right approach and methods to make the maximum use of time and resources.
Interprets business issues and recommends business solutions. Takes initiative to solves complex problems that have a far-reaching impact on the business. Works independently with minimal guidance.
Verbal and written communication skills as well as interpersonal skills necessary to work in team environment.
Organizational skills and experience managing completion of multiple projects.
Preferred Job Qualifications:
Bachelors degree with concentration in Business, Math or Computer Science.
Experience with Azure DevOps, PowerBI, Tableau
VIVA USA is an equal opportunity employer and is committed to maintaining a professional working environment that is free from discrimination and unlawful harassment. The Management, contractors, and staff of VIVA USA shall respect others without regard to race, sex, religion, age, color, creed, national or ethnic origin, physical, mental or sensory disability, marital status, sexual orientation, or status as a Vietnam-era, recently separated veteran, Active war time or campaign badge veteran, Armed forces service medal veteran, or disabled veteran. Please contact us at hr@viva-it.com for any complaints, comments and suggestions.
Contact Details :
Account co-ordinator: Nivas Palanisamy, Phone No : (847) 786-5908 Extn : 282, Email: staffing10@viva-it.com
VIVA USA INC.
3601 Algonquin Road, Suite 425
Rolling Meadows, IL 60008
staffing10@viva-it.com | http://www.viva-it.com