Vacancy expired!
Title: Business/Data Analyst
Mandatory skills:Microsoft Office, MS Access, Excel, Word, PowerPoint,Google, gmail, calendar, chat, sheets, docs, slides,Visual Basic, SSIS packages, Power BI, Tableau, SSIS, MS Visual Studio,business requirements, functional requirements, diagram business process,SQL, Standard Query Language, T SQL, DB2,laws, rules, security policies, privacy, data confidentiality management,strategic objectives and goals, ad hoc reports, report specifications,Engineering workflow, IT lifecycle, technical solutions and reports, query and view objects,project management Description: Under limited supervision performs complex tasks to support the division by performing data analysis, data mining, design, development, testing activities, and execution of AdHoc, Standard, and Customized reports to achieve strategic objectives and goals. Has working experience in writing and working with SQL (Standard Query Language), T-SQL, Visual Basic, and MS Access to develop queries to gather appropriate data from multiple systems and create reports in multiple technology applications (Excel, Tableau, etc.), write SSIS packages, and complete paperwork/documentation to move reports into Production. Serves on projects and/or pilots to develop and/or provide input for requirements, provide technical guidance for design or enhancements to systems/reports, and develop Work Plans, schedule, monitor, etc. to ensure successful and timely completion.Responsibilities include but are not limited to:Designing reports requiring analysis, writing of SQL, data mining, and presentation to technical and non-technical audiences in a variety of technical platforms (Power BI, Tableau, Excel, etc.)Prioritize business and operational needsExtract, import, clean, transform, and validate dataWriting queries using SQL, T-SQL, and MS AccessExperience with DB2Identify, analyze, and interpret trends or patterns in complex data setsCreate standard and ad-hoc reports including detail, summary, history, snapshots, drill down, and other reportsDevelop report specifications, test plans, prepare test data, execute tests, supporting documentation, and coordinate production implementationEstablish data connections with various data sourcesSetup report schedule, subscription, access process and procedures, and delivery methodPresent data in lists, tables, charts, graphs, snapshots, crosstab, and other formatsTailor the analysis and reporting methods by the type of data as well as to the intended audienceReview key indicators to locate and correct problemsFollow up and track remediation of issuesWrite and present Desk-Aids and Work-Flows for both technical and non-technical audiences.Knowledge, Skills & Abilities:Knowledge of Service Level Agreement (SLA); laws, rules, security policies, privacy, data confidentiality management.Knowledge of Engineering workflow, IT lifecycle and system design, performance tuning, and Business Intelligence tools and features.Knowledge of Statistical and business analysis and research and analysis methodologies.Knowledge of multiple business intelligence software applications (SQL, SSIS, MS Visual Studio, Tableau, Visual Basic, MS Access, etc.) and multidimensional and relational database design.Knowledge of project management concepts, principles, and practices.Skilled in dimensional and relational database design.Skilled in analysis, design review, troubleshooting, implementation, and integration for applications.Skilled in keyboarding and use of Microsoft Office programs such as Excel, Word, Access, and PowerPoint and Google for gmail, calendar, chat, sheets, docs, slides, etc.Problem and negotiation skills to research and resolve issues.Good time management and organizations skills with attention to detail.Skilled in effective listening, oral and written communications skills to communicate technical and non-technical concepts to a variety of audiences.Ability to write business and functional requirements and diagram business processes, translate into technical solutions and reports, query and view objects, and present in a meaningful format.Ability to work at least 40-hours per week and maintain satisfactory attendance and punctuality standards.Ability to work independently and collaboratively and under stress/pressure.Ability to analyze data, develop and execute queries and reports, and proficiently manipulate data.Ability to adapt to changing needs and priorities quickly while contributing feedback based on rules and regulations.Ability to multi-task and make good decisions balancing competing deadlines and priorities. 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 for any complaints, comments and suggestions. Contact Details:Please send your resumes and one of our recruiter will get in touch with you. VIVA USA INC.3601 Algonquin Road, Suite 425Rolling Meadows, IL 60008http://www.viva-it.comVacancy expired!