Data Analytics Senior Associate : Oracle, SQL, SSIS : Dallas, TX
1/11/2017 12:16:47 PM
Data Analytics Senior Associate
Requires a Bachelor's degree in Information Technology, Information Systems, Mathematics, Finance, Computer Science or related field (willing to accept foreign education equivalent) as well as two (2) years of experience in the job offered or two (2) years of experience performing Oracle and SQL database analysis. Two (2) years of experience must include: utilizing SQL and SSIS to perform database development, capture and retrieve data from multiple data sources, and perform extensive data mining and analysis to generate reports for clients and answer specific business questions; performing data reporting utilizing Oracle, Excel, and MS-Access to create database research reports and industry analysis for client delivery; utilizing SQL and SQL Server Analysis Service to create complex queries and stored procedures to ensure accuracy of data extracted from the database and the reports generated; analyzing and gathering business requirements and business rules, and translating requirements into database queries and data extraction to meet client requests; creating visualizations with the data using Tableau, QlikView and Excel to provide graphical/visual reports and dashboards for clients; working with large data sets of up to 500 gigabytes of data, including unstructured data and structured data, including transactional and reporting data; and performing database design by leveraging business logic to incorporate data from different sources, including company's ERP system, vendor data, invoice data, OCR data, standalone tracking system, and linking various data together.