Top Data Analyst Skills

Below we've compiled a list of the most important skills for a Data Analyst. We ranked the top skills based on the percentage of Data Analyst resumes they appeared on. For example, 12.4% of Data Analyst resumes contained Database as a skill. Let's find out what skills a Data Analyst actually needs in order to be successful in the workplace.

The six most common skills found on Data Analyst resumes in 2020. Read below to see the full list.

1. Database

high Demand
Here's how Database is used in Data Analyst jobs:
  • Supervised activities of database developer, proficiently maintaining and enhancing database for operational use in all areas of the company.
  • Collaborated with sales representatives to identify names, address, and pertinent information on physicians within the internal databases.
  • Create corporate structure using new Data Portal Management databases and queries to keep research information organized using Microsoft Access.
  • Reviewed electronic documents and information for accuracy and completeness prior to entering information into multiple Department of Justice databases.
  • Used partitioning, indexing and performance tuning after extending existent database design at logical level using extended ERD.
  • Analyzed crimes by category and created/maintained a database that cataloged data by type of criminal offense.
  • Create and maintain litigation and administrative databases in accordance with client requirements and operational best practices.
  • Worked collaboratively with the Database Administration Team in providing and executing recommendations on key maintenance programs.
  • Included automated description writing, vendor mapping, and item matching against proprietary reference database.
  • Survey respondents from call center Collect and document demographic data Review databases for accuracy and completeness
  • Developed database queries and reports in support of internal audit process for senior management reporting/forecasting.
  • Developed database applications for managing IT staffing requirements and monitoring the status of outstanding requisitions.
  • Developed normalized Logical and Physical database models to design OLTP system for finance applications.
  • Performed database maintenance including updates and upgrades to ensure safety and security of data.
  • Identified data anomalies and recommended appropriate strategies for auditing, database construction and reporting.
  • Integrated the data collected during several business processes into a holistic Master Data Database.
  • Maintained and updated database for client and hospital contacts on customized company software.
  • Queried a database for information concerning searches and associated advertisements to compile reports.
  • Investigated, archived and maintained content in extensive multiple, technology-based databases.
  • Maintained Provider Directory database including provider changes, additions and terminations.

Show More

2. Pl/Sql

high Demand
Here's how Pl/Sql is used in Data Analyst jobs:
  • Developed PL/SQL stored procedures to provide interfaces for Java applications and other accounting processes.
  • Enforced business rules using PL/SQL in Database Triggers/Stored Procedures/Functions.
  • Implemented procedures/functions in PL/SQL for Stored Procedure Transformations.
  • Generated PL/SQL scripts for data manipulation and validation.
  • Developed production applications using Oracle PL/SQL.
  • Performed back-end testing extensively using PL/SQL.
  • Identify, modify implement changes in database objects and PL/SQL procedures for migration of system from Oracle 8i to Oracle 9i.
  • Design, develop, and unit test source code to meet the needs of the project and business, using PL/SQL.
  • Involved in implementation of UNIX shell scripts to copy files among different servers and to invoke PL/SQL scripts, DataStage jobs.
  • Developed functions in order to process data to be entered in the interface in PL/SQL 2000 according to company's methodologies.
  • Constructed a web application using PHP and PL/SQL as tool for sales to select the correct plan bases on customer trends.
  • Created batch job in regular maintenance, email notification and production support to load the data using shell scripts and PL/SQL.
  • Optimized the SQL and PL/SQL queries by using different tuning techniques like using hints, parallel processing, and optimization rules.
  • Design and generation of different database objects like Tables, Views, Synonyms and Sequences, Pl/SQL packages and Database Triggers.
  • Developed Oracle PL/SQL scripts that produced reports of converted data, to be used by the users during data validation.
  • Design and Generate monthly Enterprise SLA reports (Custom Wireless Performance Report) using PL/SQL, Excel, MS Access.
  • Developed complex SQL queries, extensive knowledge of unions, multiple table joins, views and database programming in PL/SQL.
  • Facilitated efficient delivery of application upgrades by preparing & deploying SQL & PL/SQL in support of projects & maintenance releases.
  • Converted PL/SQL to Java within the Eclipse IDE, in order compare script effectiveness and computational extensiveness through ADT development.
  • Designed & developed various departmental reports by using SAS, Micro Strategy, SQL, PL/SQL, MS Excel.

Show More

3. Data Warehouse

high Demand
Here's how Data Warehouse is used in Data Analyst jobs:
  • Designed, implemented, and operated comprehensive data warehouse systems to balance optimization of data access with batch loading.
  • Created automated reports on inventory defect and associate behavioral trends using Amazon's Data Warehouse and proprietary ETL manager.
  • Assist in setting up an accurate data warehouse comprising high quality fundamental and market data covering international equities.
  • Implemented a data warehouse through an Oregon consortium of schools, providing the interface between programmers/developers and teachers/administrators.
  • Gathered and consolidated data from diverse data sources into a uniform Business Intelligence SQL Server data warehouse.
  • Ensured production data being replicated into data warehouse without any data anomalies from the processing databases.
  • Pioneered Scrum methods for Agile software development for Data Warehouse team to support Digital Marketing initiatives.
  • Developed knowledge of data warehouse data structure design definitions, capabilities, and programming languages.
  • Involved in requirement gathering and database design and implementation of star-schema/dimensional data warehouse using Erwin.
  • Work closely with data warehouse modeler and Risk Management VP providing insight into company operations.
  • Performed data analysis, quality assessment and processing in support of Finance data warehouse.
  • Developed dimensional model for Data Warehouse/OLAP applications by identifying required facts and dimensions.
  • Define specifications for a centralized data warehouse normalizing data from 10 legacy systems.
  • Aggregated data from different sources into Master data warehouse and performed data profiling.
  • Managed a complex consolidated data warehouse, particularly customer base maintenance and troubleshooting.
  • Source Data Integration across various heterogeneous systems into one Enterprise wise data warehouse.
  • Operate comprehensive data warehouse systems to balance optimization of data access.
  • Designed and developed reports by extracting data from data warehouse.
  • Worked with Data Warehouse team in developing Dimensional data Model.
  • Managed and maintained data warehouse to ensure data accuracy.

Show More

4. Data Analysis

high Demand
Here's how Data Analysis is used in Data Analyst jobs:
  • Conducted data analysis and trend interpretation for developing statistical process control methods in support of aviation information and readiness reporting requirements.
  • Performed data analysis for the Operations Compliance & Control department assisting with training management and data analysis for regulatory reporting.
  • Provided data analysis and portfolio stratification across entire credit risk portfolio in support of capital modeling and credit risk reporting.
  • Involved in requirements gathering and source data analysis and identified business rules for data migration and for developing data warehouse.
  • Performed preliminary analysis of statistics produced to identify patterns requiring report specificity by utilizing critical thinking with data analysis.
  • Mentored over ten internal and external stakeholders on the fundamentals of data analysis and the proprietary counterfeit software deployed.
  • Perform data analysis/reconciliation on various participant data reports by researching, comparing, and gathering results from several databases.
  • Performed data analysis that corresponded to federal policies toward: certification requirements, transferable credits and earned degrees.
  • Perform detailed data analysis, including data profiling, system source analysis and auditing under strict tolerance levels.
  • Conducted comprehensive data analysis work, translating data from business documents and other platforms into Oracle Sterling databases.
  • Provided data analysis, identified trends, summarized results and generated reports for Card Solutions Delivery reorganization effort.
  • Generated data and business validation reports using Excel to present data analysis reports for each marketing campaign.
  • Conduct data analysis and establish procedures to advance the data quality of the Minnesota Immunization Information Connection.
  • Shuffled normalized data into Microsoft Access, created relational database and wrote specific query for data analysis.
  • Solved a wide range of problems by developing and refining processes which encompassed data analysis and visualization.
  • Automated financial data analysis, computing information utilizing statistical formulas and inputting into database for report generation.
  • Collaborated with the Procurement and Marketing team by providing data analysis to assist in their strategic decisions.
  • Performed data loads and data validation using Apex Data Loader to ensure authentication of data analysis.
  • Integrated data analysis and variable to develop and maintain company's strategic vision and organizational goals.
  • Work with clients to develop quality improvement plans based on opportunities identified through market data analysis.

Show More

5. Financial Statements

high Demand
Here's how Financial Statements is used in Data Analyst jobs:
  • Collected financial reports including company financial statements and industry reports; extracted and entered needed data into database using Microsoft Access.
  • Analyze financial statements and internal cost accounting records of manufacturing enterprises in terms of ratio analysis and account balance reconciliations.
  • Analyzed historical financial statements in order to calculate government regulated subsidies given for developing future telecommunication infrastructures in rural areas.
  • Analyzed and interpreted financial statements of various domestic and international corporations then loaded the data into the MGFS database.
  • Developed and maintained financial statements using Microsoft Excel in order to provide financial statements and reports to management.
  • Perform industry classification for revenue streams and business segments of public companies as researched through financial statements.
  • Maintained the integrity and accuracy of financial statements in an intense deadline driven environment.
  • Performed analysis and reconciliation of financial statements, account and banking reports.
  • Evaluated corporations financial statements to determine the companies corporate rating.
  • Generated and analyzed financial statements monthly, quarterly and annually.
  • Facilitate the conversion of foreign financial statements before processing.
  • Balance financial statements and prepared documentation for daily reports.
  • Consolidated financial statements and conduct financial statement analysis.
  • Assisted Controller in preparation of monthly Financial Statements.
  • Analyze financial data reported on financial statements.
  • Created custom financial statements in accounting software.
  • Prepared financial statements and staff performance grading.
  • Prepared financial statements and account reports.
  • Reconcile reports with published financial statements.
  • Prepared financial statements for customers.

Show More

Job type you want
Full Time
Part Time
Internship
Temporary

6. Business Requirements

high Demand
Here's how Business Requirements is used in Data Analyst jobs:
  • Trouble-shoot, and resolved hardware, software and connectivity problems, including user access and component configuration to support business requirements.
  • Gather functional/business requirements and collaborate closely with Development and QA teams throughout the UAT process to ensure requirements are fully satisfied.
  • Participated in the identification, understanding, and documentation of business requirements, including the applications capable of supporting those requirements.
  • Analyzed and collected business requirements, generated business models, identified system interfaces and created Business Requirement Document (BRD).
  • Identified and implemented operational improvements, developed business requirements when system solutions are required, and performed special projects as required.
  • Developed reports as per business requirements and created various reports like Summary reports, Tabular reports based on routine analysis.
  • Conducted analysis on the ITG current data and technology environment and addressed new business requirements based on ITG market-data capability.
  • Defined and documented clear and complete detailed business requirements and functional specifications using the SDLC methodology from the Business team.
  • Identified and defined business requirements by extracting business needs from applicable resources and translating them into complex designs and recommendations.
  • Created and Reviewed Business Requirements, Functional Specifications, Project Schedules, and Documentation while working in an agile environment.
  • Presented best practices for proper user story decomposition to begin meeting project objectives and align with overall business requirements.
  • Analyzed business requirements, system requirements, data mapping requirement specifications interacting with client, developers and QA team.
  • Worked with Corporate Controller, Regional Finance Directors, and Hyperion consultants to produce business requirements and technical specifications.
  • Analyzed the Business requirements and developed Test cases based on functional requirements, general requirements and system specifications.
  • Produced documentation including detailed Business Requirements, Functional Requirements and assisted to produce Technical Specification and Operations Manual.
  • Participated with Business on SAP IT functionality to identify and prioritize SAP/ Business requirements and supporting business cases.
  • Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for reports.
  • Created Business Requirements and converted them into detailed Use Cases, Report Specifications and Non Functional Requirements.
  • Verified & Validated high-level business requirements through interviews and requirements workshop and decomposed them into functional requirements.
  • Enhanced and Customized MDM repositories per business requirements including Repository Design and definition to accommodate their needs.

Show More

7. Data Entry

high Demand
Here's how Data Entry is used in Data Analyst jobs:
  • Interpret medical source documents for data entry into the safety database, including extraction of appropriate laboratory data and diagnostic testing.
  • Provided timely and accurate administrative and data entry support to service Professionals while performing daily NASA activities related to order entry.
  • Support a variety of administrative activities, including data entry/cleanup of electronic data spreadsheets and electronic archiving of EPA documentation.
  • Provided data entry support for Work item Specifications, Material Requirement List Requisitions and Ship Alteration and Repair Packages.
  • Created reports and maintained database modifications, additions for data entry, and generated Accounting Financial/Statistical end-of-month reporting status.
  • Generated data queries based on validation checks or errors and omissions identified during data entry to resolve identified problems.
  • Worked with a data entry specialist to reconcile inventory on-hand in warehouse and inventory listed on computer.
  • Process applications; data entry and send out deficiency letters to notify providers of incomplete applications.
  • Designed user-friendly, web-based graphical user interface registration screens for in-house and on-site data entry use.
  • Implemented new methodologies to enhance productivity and accuracy in the data entry and analysis process.
  • Resolved data discrepancies and ensured complete and accurate data entry by reviewing source documents.
  • Experience with hospital downloads and data entry of hospital patient demographic and billing information.
  • Completed accurate data entry of key information, while overseeing verification and information research.
  • Performed accurate data entry of serious and non-serious adverse events into safety database.
  • Created update processes using Foxtrot Automation simulating data entry to customer account information.
  • Developed and implemented Data Entry which resulted in increased company efficiency and productivity.
  • Provided direction to clerical personnel responsible for data entry and maintenance of records.
  • Analyzed data entry reports, resolved material variances and monitored inventory levels.
  • Crafted sequences for data entry and created modules to verify information/data accuracy.
  • Maintained data entry requirements by following data programs techniques and procedures.

Show More

8. SQL

high Demand
Here's how SQL is used in Data Analyst jobs:
  • Designed Web-based Internet applications linked to firm-wide SQL databases.
  • Monitored performance and optimized SQL queries for maximum efficiency.
  • Developed complex SQL queries to validate MicroStrategy results.
  • Involved in migration of various objects like, stored procedures, tables, views from various data source to SQL Server.
  • Created Bullet graphs to determine profile generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
  • Created complex conditions (Dates), Prompts and free hand custom SQL to create Derived tables in the universe.
  • Created SQL queries to extract data from the Maine Immunization Oracle database to fulfill internal and external data report requests.
  • Used SQL queries for organizing and abstracting data from MS access databases, created reports, forms on MS Access.
  • Centralized the role of SQL queries in the creation of the alternative investments procedures for Commonwealth's new accounting platform.
  • Analyze the accounts between Quest s and Dell s databases by using SQL and MS Access to identify any discrepancies.
  • Performed database migration from SQL Server 2005 to 2008 and also migrated databases from 2008R2 to 2008 using import/export wizard.
  • Maintained a repository of data controls (SQL queries, stored procedures) to monitor data quality and mitigate issues.
  • Worked closely with multiple data base systems, using quarries and SQL commands - Responsible for testing and implementing new products
  • Import, cleanse, analyze, export and visualize internal and client data (SQL Server, Excel).
  • Set up & configured DB mail and created jobs to send out an email whenever any SQL jobs fails.
  • Worked with Development DBA to assist and support developers with SQL performance tuning, query tuning and code reviews.
  • Assisted Corporate Office with the preparation and analysis of reports utilizing database management tools and techniques, including SQL.
  • Used internal databases, Excel, SQL, and Microsoft tools to pull data and reformat for business use.
  • Reviewed and analyzed data, and generated reports using a variety of tools including SQL and GeoAccess software.
  • Support ERP system users by providing troubleshooting, report generating, SQL/PLSQL query writing and system analysis services.

Show More

9. ETL

high Demand
Here's how ETL is used in Data Analyst jobs:
  • Assisted Business Analyst in documenting business requirements, technical specifications and implementation of various ETL standards in the Mappings.
  • Created Functional design documents and Technical design specification documents for ETL Process based on Business Requirements.
  • Created a PowerBuilder user interface application to import collection portfolios using ETL processing techniques.
  • Collaborate closely with ETL developers on technical specification for integration component development.
  • Developed data integration tasks using ETL on scheduling application transaction information.
  • Analyzed quality issues, providing ETL with updated transformation requirements.
  • Conduct technical/application/MetLife overview sessions for new joiners in MetLife account.
  • Designed Data Stage ETL jobs for extracting data from heterogeneous source systems, transforming and finally loading into the data marts.
  • Executed SQL queries to identify and manage to eliminate Duplicate and Improper data that would load into the RDBMS via ETL.
  • Extracted the data from the different sources and stored the data into the intermediate Staging Database using the SSIS ETL tool.
  • Worked on Master Data Management (MDM) for maintaining the customer information and for the ETL rules to be applied.
  • Develop, test and execute SQL scripts for analyzing and troubleshooting ETL processes, and software solutions from the back end.
  • Work with a Java-based ETL tool to do complex data cleansing, loading, extracting, updating, and file creations.
  • Developed SQL queries for ETL (Extract, Transformation and Loading) mappings to extract the data from multiple sources.
  • Design, build and deploy high quality, performance, integrated, and documented ETL solutions while following established standards.
  • Tuned the application by rewriting the queries utilizing the database parameters, modifying the transformations and mappings in ETL process.
  • Developed ETL scripts for processing and transferring of raw data from the legacy systems into the warehouse daily and weekly.
  • Automated an ETL job to facilitate daily, weekly and monthly loading of material prices, quantities to the warehouse.
  • Created ETL Jobs and Custom Transfer Components to move data from Oracle Source Systems to SQL Server using SSIS.
  • Experience in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS).

Show More

10. SAS

high Demand
Here's how SAS is used in Data Analyst jobs:
  • Developed SAS program to auto generate PDF school specific reports for educational facilities participating in the vaccination assessment.
  • Documented SAS programs, created and maintained organized project directories according to strict standard operating procedures.
  • Managed projects and oversaw data management and analysis of internal air quality projects using SAS software.
  • Conducted statistical analyses such as Logistic Regression, Binary Classification and Power Analysis using SAS.
  • Developed processes for account profitability reporting, SAS programming, inventory and trend analysis.
  • Prepared database for Southern Arkansas University Mule-riders yearly Magazine from 1930 to present.
  • Provide analyst support to president of a national disaster non profit organization.
  • Imported Data from relational database into SAS files per detailed specifications.
  • Identified appropriate economic predictors using data mining techniques and SAS programming.
  • Provided grants management analysis and support for major federally declared disasters.
  • Developed applications for user-generated reporting and dashboards with QlikView and SAS.
  • Performed statistical analysis for scientific paper and presented results using SAS/GRAPH.
  • Translated user data and reporting requirements into SAS programming language.
  • Authored documentation for all new accounting processes and disaster recovery.
  • Developed monthly and yearly data reports for Arkansas legislative committees.
  • Participated in Disaster Recovery planning and tests.
  • Performed validation/quality control check of SAS programs.
  • Maintained and updated SAS Programming Documentation.
  • Develop Disaster recovery and backup solutions.
  • Provided statistical analysis using SAS for.

Show More

11. Test Cases

high Demand
Here's how Test Cases is used in Data Analyst jobs:
  • Developed new and updated existing Automation test cases using selenium WebDriver and TestNG for java based web application.
  • Supplied production support including Implemented user acceptance testing with a focus on documenting defects and executing test cases.
  • Prepared and executed Test cases with different Test Sets for different objectives based on the Business/Functional requirements.
  • Performed test cases and validation testing and other project management activities for system data migration project.
  • Prepared requirement specification, functionality trace matrix, quality assurance plan and designed test cases.
  • Prepared test cases and test plans performed unit/system testing and coordinated functional acceptance testing.
  • Implemented iterative testing using agile methodologies on positive and negative test cases.
  • Create and maintain Data Test Cases/Scenarios ensuring testing coverage.
  • Created test case scenarios, executed test cases and maintained defects in Clear Quest and ETL graphs from Source to Target.
  • Analyzed and verified critical algorithms with system experts Developed test plans, test cases to validate the adherence to system requirements.
  • Created Unit test plan, system integration plan, wrote functional test cases and participated in module checking using SQL queries.
  • Supported the Risk projects by explaining detailed scenarios to IT developers, created test cases, and helped test the enhancements.
  • Involved in preparing Test Plans based on User Requirements Document (URD) and prepared the Test Cases and Test Procedures.
  • Involved in developing detailed test plan, test cases and test scripts using Test Director for Functional and Regression Testing.
  • Developed automated test scripts from manual test cases for Regression testing based on the requirement documents using Quick Test Professional.
  • Defined test cases including input and expected results, analyzed bugs and interacted with team members in fixing errors.
  • Developed test cases and test plans for unit and system tests for new or modified programs and job streams.
  • Verify development of rule-set test scenarios, test cases, expected results and test scripts using mercury Quality center.
  • Ensured data quality requirements were covered in test scenarios and test cases and that the test cases were automated.
  • Reviewed the test scenarios, test cases prepared by the offshore testing team and ensured test coverage is achieved.

Show More

12. Data Management

high Demand
Here's how Data Management is used in Data Analyst jobs:
  • Participated in data analysis, data dictionary and metadata management, collaborating with business analysts, developers and database administrators.
  • Performed Data management and re-structured/derived important parameters using clinical data based on the Emory Cardiovascular patient registry for future analyses.
  • Contributed to development of new products and functionality by working in conjunction with editorial, data management and technology groups.
  • Collaborated with executives along with management for data management proposals to potential clients, and participated in vendor management.
  • Established system of data management for clinical and research studies and generate computerized family history pedigrees and risk assessments.
  • Provided technical and business consultation services; including inventory analysis, troubleshooting, data management, and customer support.
  • Maintained and recommended improvements for departmental processes while following all Standard Operating Procedures for data management and documentation.
  • Drive US/China/Brazil/Mexico Product Data Management Teams to benchmark global business processes and achieve data management efficiency and accuracy.
  • Develop and present training materials, providing consultation for departmental users related to Data Management and Payroll Functions.
  • Define government Top Secret documents and interpret product requirements relevant to certification, configuration and data management.
  • Performed data analysis and developed methodologies for effective client data management for document execution and attorney performance.
  • Project Manager responsible for developing an enhanced Data Management and Governance process for all externally hosted data.
  • Provided program documentation numbers and maintained data management database of numbers assigned and utilized in Microsoft Access.
  • Synthesized and summarized findings from 11 data management requirements gathering interviews in program offices throughout CBP\OIT.
  • Analyzed, designed, and implemented moderately complex computer-based systems for statistical analysis and data management.
  • Design, develop, and modify data management infrastructure to expedite data analysis and reporting.
  • Analyze current data management procedures, including reporting methods, and make recommendations for improvements.
  • Collaborated with business partners to identify areas for continuous improvement of data management processes.
  • Provided data management to the Clinical Operations team for study-specific data reviews and transfers.
  • Develop prototype entry/edit form for data management of a warehouse consisting of eight databases.

Show More

13. Windows XP

high Demand
Here's how Windows XP is used in Data Analyst jobs:
  • Used Microsoft office applications including Excel, Word, PowerPoint, Access, and Lotus Notes in a Windows XP/UNIX environment.
  • Have the experience in configuring, implementing, and supporting of Windows XP, Microsoft Office, Microsoft Outlook.
  • Moved User Accounts and Computers to their proper containers for functionality between Windows 7 and Windows XP environments.
  • Migrated Windows 2000 environment to Windows XP on a LAN connected to a TCP/IP, WAN.
  • Verified compatibility testing to see how compatible is the application in Windows 98/2000, Windows XP
  • Supported the following platforms: Windows XP, Vista, Mac OS.
  • Facilitated the successful documentation of the complete conversion of Windows XP.
  • Installed and maintained Windows XP.
  • Install basic software on systems (Windows XP, Office 2003, etc.)
  • Overhauled the database to track the progress of the process to upgrade 2000 computers from Windows XP toWindows 7.
  • Contributed to the development of Standard Operating Procedures (SOPs) Environment: SAS 9, Windows XP.

Show More

14. Unix

high Demand
Here's how Unix is used in Data Analyst jobs:
  • Authored detailed patient management/clinical system specifications/reports on UNIX based ERP platform (CMHC/NetSmart).
  • Developed Unix scripts to process incoming files and implemented pattern matching using regular expressions.
  • Provided support and maintenance for production applications, including UNIX based applications.
  • Microsoft-based, and Unix-based operating system and network environment.
  • Automated data loading, extraction, reports generation using UNIX Shell scripting and loading data using SQL* Loader to custom tables.
  • Worked extensively in sorting, merging, concatenating and modifying SAS Data sets in different environments (Windows and UNIX).
  • Involved in writing Unix Shell Scripts for automation to ensure that data captured and stored in database is correct and accurate.
  • Administer MPE/X and Unix commands to run (stream) jobs, modify jobs and enhance system productivity and system/application files.
  • Created and used Unix scripts to provide an up to date list of all active users and to audit inactive accounts.
  • Used PMCMD command to start, stop and ping server from UNIX and created UNIX Shell scripts to automate the process.
  • Designed and developed UNIX shell scripts to move data between quality, test and development environments using Oracle export/import utilities.
  • Generated Integrated Summaries Safety and Integrated Summaries Efficacy tables as per the SAP and migrated SAS from UNIX to Windows.
  • Work with Unix systems daily reviewing reports generated based on utilization of resources and alerting teams to resolve issues found.
  • Researched and resolved data problems propagated from the database system into a front-end Oracle-10g processor running in the UNIX environment.
  • Utilized programs BC Slick, Prism, Access, Excel, some Unix, and other software for creating reports.
  • Developed complex SQL queries to perform the back end testing of the Oracle database using SQL and UNIX shell commands.
  • Created triggers, stored procedures, and shell scripts, T/SQL for an MS SQL Server database and UNIX.
  • Moved SAS jobs from Mainframe to UNIX server and modified and enhanced the codes to execute in UNIX platform.
  • Develop and customize already existing Unix-based application templates for end users (Credit Unions) through Spectrum and/or UC4.
  • Developed Control files for SQL Loader to populate database tables, UNIX shell scripts to process the Flat Files.

Show More

15. Data Collection

average Demand
Here's how Data Collection is used in Data Analyst jobs:
  • Maintained leadership responsibility to ensure data consistency and quality across the end to end process from data collection through metric reporting.
  • Developed and implemented Six Sigma data collection and reporting infrastructure resulting in a 700 hours-per -year reduction in report production.
  • Devised innovative strategies that streamlined data collection, daily deposits and decreasing daily backlog process to drive team member productivity.
  • Participated in improving organizational performance through recommending areas or approaches for elevating activities and performing new data collection procedures.
  • Assisted Database Analyst group in market data collection; participated in data analysis; generated data based graphs independently.
  • Created and implemented Evaluation Plan that established and communicated team goals to outside team members to facilitate data collection.
  • Assist the information technician in using electronic databases to improve data collection, compilation, presentation and reporting.
  • Initiated process improvements through data collection, analysis and reporting, resulting in timely access to information.
  • Developed and introduced a computerized database system to facilitate the data collection and to improve assessment quality.
  • Identify deficiencies in staff processes and data collection; offer recommendations for improved data management and collection.
  • Developed and implemented methodology for data collection, analysis and reporting for several nationally funded research projects.
  • Determined more efficient data collection procedures and ensured that all data gathered was entered per corporate standards.
  • Developed current data collection systems, thus maximizing data entry efficiency, data accuracy and report quality.
  • Piloted a project for overall data collection for all production lines and maintained database for future analysis
  • Prepared technical work, including financial analysis, computer modeling, data collection and industry research.
  • Participate in the development of study protocols including guidelines for administration or data collection procedures.
  • Applied both primary and secondary data collection procedures to obtain the necessary data for analysis.
  • Improved data collection by incorporating insight specific variables to resolve chronic failures with high incidents.
  • Supported data collection, analysis and submission required for project budget improvements monitoring and reporting.
  • Assisted with Data collection and analysis, identified problem areas and recommended revising existing processes.

Show More

16. Data Integrity

average Demand
Here's how Data Integrity is used in Data Analyst jobs:
  • Analyzed purchasing patterns and trends to identify incremental revenue opportunities, improve data integrity, and facilitate product and program compliance.
  • Improved data integrity by detecting and correcting data input errors and mathematical errors included in the original/published corporate financial reports.
  • Maintained system data integrity by contacting government tax offices for updated/confirmed information, as needed and on a rolling schedule.
  • Reviewed and edited reports to determine omissions and/or errors and made the appropriate correction to ensure data integrity and accuracy.
  • Minimized operational errors by deep diving in root case causes, investigating potential database issues and maintaining data integrity.
  • Assisted information technology directors with website creation; designed process improvements for data integrity and database search and retrieval.
  • Performed monthly database review to maintain vendor data integrity by avoiding and/or deleting any duplicate or invalid data records.
  • Provided responsibility for well data integrity and well data management processes that feed both corporate and project databases.
  • Analyze and identify potential solutions to synchronization issues between multiple data systems and ensure data integrity between systems.
  • Maintained data integrity organization-wide by training front-line staff on definitions provided by county and developing training materials.
  • Used various integrity constraints for data integrity like Referential integrity using primary key and foreign key relationships.
  • Coordinate master data requirements with other functional data owners and ensure functional master data integrity with SAP.
  • Validated data by performing data integrity checks, reporting anomalies and coordinating with internal users for resolution.
  • Managed vendors to mitigate data integrity risk by ensuring adherence of procurement management processes and contract terms.
  • Decreased extraneous expenses by ensuring data integrity and consistency for Public Finance through collaboration with database teams.
  • Maintained high-level customer satisfaction adhering to project time-lines, data integrity guidelines, and data reporting requirements.
  • Establish catalog backup policies to ensure data integrity, availability, and efficient recovery on demand.
  • Monitor data integrity, manage data cleaning/quality control, and perform data validation and integrity checks.
  • Handled data cleaning and manipulation process using Excel to ensure data integrity and report accuracy.
  • Preformed defined data processing steps while insuring data integrity and quality to prepared print files.

Show More

17. Customer Service

average Demand
Here's how Customer Service is used in Data Analyst jobs:
  • Provide exceptional customer service to internal and external data product customers by troubleshoot hardware and software issues and identify network/applications issues.
  • Partnered with customers that provided Verizon with a low customer service rating to identify center and organizational opportunities.
  • Executed customer service strategies by speaking with personnel one-on-one to allow compensation for victims of identity theft.
  • Provided exceptional customer service and technical support for internal and external voice and data product customers.
  • Provided customer service and support by answering dealer inquiries and calling customers to monitor fraudulent activities.
  • Analyzed call volume and average call time to monitor Customer Service Representative Performance and productivity.
  • Served as Primary liaison between customer service associates, information security analyst and account managers.
  • Completed all new hires paperwork and provided orientation training for all potential customer service associates.
  • Piloted and implemented cost savings programs and delivered superior customer service to ensure successful campaigns.
  • Provided customer service and processing to credit unions affiliated with Southern Regional Data Corporation.
  • Coordinated with shipping department on all incoming data entry projects in customer service department.
  • Elevated all personnel performance and related concerns to the manager of customer service immediately.
  • Created and facilitated BlackBerry needs analysis and follow-up training for all customer service teams.
  • Provided exemplary customer service and professional demeanor for internal and external clients.
  • Analyzed retail surveillance video data and identified weak areas in customer service.
  • Prepared Board/Executive presentations, and updated monthly customer service goals tracking metrics.
  • Developed customer service department operations department and manual for a start up.
  • Work with Executive Management to develop Customer Service and Account management strategies.
  • Assist Customer Service Manager Supervisor in tracking performance data for respective team.
  • Greet walk-in residents and/or prospective residents and provide superior quality customer service.

Show More

18. Pivot Tables

average Demand
Here's how Pivot Tables is used in Data Analyst jobs:
  • Conducted Statistical Modeling of data on how providers submit outpatient authorizations using Pivot Tables in Excel.
  • Use sensitivity analysis and pivot tables to understand company performance.
  • Performed Excel import/analysis using pivot tables for call statistics.
  • Used pivot tables and advanced formulas to provide daily reporting covering 7000+ cell tower projects covering 60+ project milestones per project.
  • Prepared and maintained the various MS Excel workbooks used to manage advertising budget; all made extensive use of PIVOT TABLES.
  • Created Excel pivot tables, which showed a table of users that, have not performed scanning of journal voucher documents.
  • Create pivot tables, analyses, graphs and charts to view trends in forensic data related to Chevron's business operations.
  • Deliver complex Excel reporting, pivot tables and charts to Cisco's distributors and provide trending in all segments and technologies.
  • Created views in SQL linked in excel and access to generated reports which include charts, graphs, and pivot tables.
  • Analyze HR department's Occupational Health data, document, survey data processes and procedures, create reports with Excel Pivot Tables
  • Designed, built and implemented Access database to house all departmental data to be easily managed through pivot tables in Excel.
  • Performed dicing and slicing on data using Pivot tables to acquire the churn rate pattern and prepared reports as required.
  • Analyzed company's client zip code data and created revenue reports with pivot tables & charts for North America Markets.
  • Extracted, compiled tracked and analyzed data to generate reports using advanced Excel functions to generate spreadsheets and pivot tables.
  • Run queries to acquire information request and the development of data update strategies using pivot tables, Access and SQL.
  • Created charts, pivot tables, VBA macros to provide data analysis and build dashboards for Systems Engineers Operation group.
  • Utilized Microsoft Excel pivot tables and formulas for data manipulation, financial reporting, metrics reporting, and data analysis.
  • Advanced knowledge of Excel for using Pivot tables, Power Pivot, Complex formulas on the top of Tabular model.
  • Leverage strong knowledge of Tableau and Pivot tables to create KPI dashboards used in key decision-making by the executive team.
  • Manipulated data received from clients in Excel using functions such as v-look-up, slicers, dashboards and pivot tables.

Show More

19. Powerpoint

average Demand
Here's how Powerpoint is used in Data Analyst jobs:
  • Produce graphical analysis and PowerPoint presentations for director level management and litigation team to be utilized as legal documentation of compliance.
  • Developed PowerPoint presentations and various marketing collateral for Membership Director to present at Chamber budget meetings and Women in Commerce conferences.
  • Experience with preparing and submitting manuscripts to medical and scientific journals and preparing PowerPoint presentations for the Supervisor of Regulatory.
  • Streamlined existing processes to increase timeliness and decrease errors; developed PowerPoint presentations and communicated weekly dashboard status to management.
  • Perform detailed data analysis, synthesize results into PowerPoint decks for presentations at hospital committee and environment of care meetings.
  • Prepared training and presentations using PowerPoint concerning performance related issues and workforce trends; and provided recommendations for improvement.
  • Managed multiple projects simultaneously and developed Excel tables and PowerPoint presentations from patient-level data to answer client specific questions.
  • Performed extra projects for divisional process improvement such as Annual Hospital PowerPoint Presentations and Divisional travel auditing and reconciliation.
  • Created PowerPoint presentations depicting data analysis concerning health issues for use at City Council and Community meetings.
  • Performed competitive analysis for MasterCard on organizational structure and employment practices and presented key findings in PowerPoint.
  • Conceptualized and designed PowerPoint presentations to provide management with an understanding of various daily operational processes.
  • Created PowerPoint decks to produce clear concise and professional presentations quickly for management and other analysts.
  • Maintained research library, collected industry information, and created PowerPoint presentations for fourteen managers.
  • Generated weekly PowerPoint presentations to identify bottlenecks and continuously improve Supply Chain planning and compliance.
  • Co-developed training manual for new computer reporting system and created PowerPoint presentation for new employees.
  • Update monthly executive PowerPoint presentation for management, as well as create additional material as needed
  • Processed the Group's PowerPoint quarterly and annual presentations and proposal preparations and distribution.
  • Created and lead presentations on products, product enhancements and processes utilizing Microsoft PowerPoint.
  • Analyzed data and developed PowerPoint presentation for the management boards and senior managers/directors.
  • Prepare neat and well-organized PowerPoint presentations for executive management using charts and graphs.

Show More

20. Teradata

average Demand
Here's how Teradata is used in Data Analyst jobs:
  • Used SAS/ACCESS and SAS/SQL to extract Data from different RDBMS like TeraData, Oracle, SQL Server and merging them efficiently.
  • Extracted data from different relational database managements such as, (TERADATA, ORACLE and SQL Server) systems using SAS.
  • Worked on CONVERSION of SAS code originally in ORACLE to TERADATA compatible SAS code.
  • Used SAS/ACCESS to access and manipulate different databases like TeraData, Oracle etc.
  • Created Teradata specific physical data models which included primary indexes, secondary indexes and joined indexes.
  • Provide Teradata support for software to life-cycle development working on some Unix/Linux and Windows utilizing Java.
  • Implemented various Archiving and purging process in accordance to business for better management of Teradata environment.
  • Accumulated data for merges and splits to effectively manage data analysis using Teradata SQL Assistant.
  • Distributed data residing in heterogeneous data sources is consolidated into the target Teradata database.
  • Define data element requirements including history, timeliness and frequency of data in Teradata.
  • Performed data analysis for massive transactions during the integration of Cassandra and Teradata engagement.
  • Analyzed business requirements and developed Tableau reports by writing Teradata and custom SQL.
  • Assisted various business units with data analysis support utilizing Teradata and Tableau.
  • Involved in database consolidation carried out along with migration between Teradata servers.
  • Led implementation for Teradata Metadata Services, metadata web application.
  • Worked with Teradata, advanced Excel and crated PowerPoint presentations
  • Perform summary statistics on data before extracting from Teradata.
  • Maintain and Tune Teradata Production and Development systems.
  • Worked on transformation logic using Teradata queries.
  • Created Teradata DEV/TEST/UAT/PROD environments using Physical model.

Show More

21. Visio

average Demand
Here's how Visio is used in Data Analyst jobs:
  • Thrived in this Remote-Location/Telecommute position due to disciplined Organizational/Time Management Skills along with the ability to work independently with little supervision.
  • Maintained product configuration by ensuring accuracy of Bill of Materials and maintaining item revision control by incorporation of all EC changes.
  • Provided technical supervision to junior developers and mentoring to other team members for database development and maintenance;.
  • Managed multiple tasks and effectively prioritize work with limited supervision in a dynamic, fast-paced environment.
  • Participated and coordinated the creation, modification and maintenance of database structures with minimal supervision.
  • Maintained Key relationships with division to insure proper data interpretations and modification for reporting requirements.
  • Participate in disease investigations and public health emergency responses under the supervision of epidemiologist.
  • Ensured that confidential information typically consisted of PHI information that was company/division sensitive information.
  • Participated in critical review and revision of existing systems for updates and enhancements.
  • Facilitated communications between divisional freight calculation software users and AR Traffic Consultants.
  • Enhanced and documented Hyperion production system queries for reporting to company divisions.
  • Verify that user application access provisioned and digital certificates issued matches requests.
  • Updated participant communication in relation to plan revisions and ensured standardized formatting.
  • Demonstrated ability to work with minimal supervision to meet and exceed deadlines
  • Contacted vendor/manufacturer for pertinent information to ensure Division compliance with WHMIS.
  • Participated in continuous quality improvements for technical support and provisioning teams.
  • Allowed customers and agents to directly enter provisioning and billing information.
  • Support relationship manager and communications division of futures volume reporting.
  • Investigate and enter resolutions and/or revisions received across operational systems.
  • Communicated with technical and provisioning staff regarding areas for improvement.

Show More

22. Informatica

average Demand
Here's how Informatica is used in Data Analyst jobs:
  • Involved in INFORMATICA log readouts and diagnoses to trouble shoot loading errors and develop internal processes.
  • Developed InformaticaSCD Type-I, Type-II and Type III mappings and tuned them for better performance.
  • Use INFORMATICA to map and transform data from Core Govt Agency database/file sources.
  • Worked with development team to evaluate loader requirements during INFORMATICA development stages.
  • Assisted in the development of the INFORMATICA scripts.
  • Developed and implemented data quality improvement strategies, worked within cross functional teams including technical and business professionals Utilized PL/SQL, Informatica
  • Assisted ETL developers in Data Analysis and Mapping the extracted data and also applying required Transformation using Informatica.
  • Developed in-depth data analysis reports using Informatica Analyst tool to improve the data management process.
  • Evaluate data modeling with Oracle and Informatica in building efficient and accurate data warehousing solutions.
  • Communicated and worked extensively with Informatica to improve provision processes and technical response time.
  • Developed and documented data Mappings/Transformations, and Informatica sessions as per the business requirement.
  • Project Summary: - Target Corporation implemented Informatica Master Data Management tool for guests.
  • Helped in creating useful information from both structured and unstructured data using Informatica.
  • Experience testing data conversions and migrations in cross platform scenarios Informatica Power Center.
  • Experienced in Converting user defined functions of business process into Informatica defined functions.
  • Incorporated the Informatica Velocity approach for Mapping design, development and Data Governance.
  • Maintained stored definitions, transformation rules and targets definitions using Informatica repository manager.
  • Developed acceptance criteria for federated write-back across systems through Informatica IDS services.
  • Prepared a handbook of standards and Documented standards for Informatica code development.
  • Designed number of mappings with complex transformations using Informatica Power Designer.

Show More

23. R

average Demand
Here's how R is used in Data Analyst jobs:
  • Created spreadsheets; manipulated data, copy/pasted information, utilized formulas and scanned forms into imagery for accurate input into system.
  • Developed and maintained applications using extensive knowledge of Microsoft SQL Server and Visual Basic for automation of data import/export processes.
  • Planned and developed constant interface with other federal officials and agencies, stakeholders in the community and private sector individuals.
  • Supported company's procurement organizations by negotiating pricing structure and specifications with vendors on new and existing material purchases.
  • Resolved inconsistencies by using standard data entry procedures, and requested further information for documents that were incomplete.
  • Processed customer and account source documents by reviewing data for deficiencies and resolving discrepancies by using standard procedures.
  • Supported customers with effective resolution or execution of any issues, providing superior quality assurance at all times.
  • Trained security personnel through video and computer modules and managed vital information for company employees and contractors.
  • Maintained compliance with configuration management policies through implementation and review of any changes or statistics.
  • Created and generated targeted reports which contributed insightful audit data facilitating a successful annual audit.
  • Provided credible, evidence based arguments and recommendations to support research proposals and grant application.
  • Documented and communicate findings, verbally and visually, easily understood by business partners.
  • Created entity relationship diagrams and multidimensional data models, reports and diagrams for marketing.
  • Update systems with changes and modifications to support report accuracy and management of documentations.
  • Deliver all assigned tasks before deadlines with excellent detailed orientation and time management skills.
  • Conducted verification of customer data credit from subscriber companies, reconciling balances as needed.
  • Designated IT Liaison coordinating department requests, providing specialized reporting, and technical consultation.
  • Process raw LiDAR data by utilizing LiDAR point/polygon editing tools and feature code manipulation
  • Monitor and maintain securities and daily reports to identify and modify securities products.
  • Provide software support and pro-actively work toward greater customer satisfaction and quality maintenance.

Show More

24. VBA

average Demand
Here's how VBA is used in Data Analyst jobs:
  • Create Excel VBA applications that automatically generate over 4 million latitude and longitude coordinates for multiple facility locations.
  • Developed internal systems with VBA and automation, fully incorporating and integrating the Microsoft Office and Windows environments.
  • Collected requirements, performed analysis and designed database applications with user interfaces created using VBA.
  • Developed VBA/Excel Macros for daily reporting delivered to end-users.
  • Convert legacy CSV and Excel flat files into MS Access data warehouse for querying by creating VBA macros and other techniques.
  • Develop Add-ins, GUI (Graphical User Interface) and performed data management task using the ADO library (VBA).
  • Performed forecasting of growth and volume of our credit card unit on a monthly basis using Excel spreadsheets and VBA macros.
  • Used SQL, VBA, Business Objects, Excel, and MS Visual Studio to automate many daily and weekly tasks.
  • Worked extensively with C++, Excel VBA, and R to manipulate and report on data set of merchant cash advances.
  • Used VBA and Excel macros with ODBC to SQL server databases to design and program input forms and reports for studies.
  • Developed Excel 2010 VBA solutions format and proof data in Excel workbooks that were going to be imported in Access daily.
  • Developed the VBA Integration with Excel feeds and SQL database, SQL Extraction, Transformations of Excel Data into SQL database.
  • Maintained client database (Access and VBA) assisting in client retention and program performance analysis while maintaining HIPAA compliance.
  • Designed, developed, implemented and supported Access and SQL Server databases for various departments throughout the organization utilizing VBA.
  • Utilized Excel VBA, Macros, and pivot charts to conduct portfolio attribution return analysis and built agency pricing models.
  • Created custom macros in Excel using VBA to help facilitate in the grooming, formatting, and analysis of data.
  • Design and create macros, formulas, and queries in Access and Excel using VBA and SQL to automate processes.
  • Developed Access 2010 VBA automation to import and proof daily data files to eliminate as much human intervention as possible.
  • Developed VBA macros, T-SQL scripts, stored procedures, and functions to facilitate ETL processes and in generating reports.
  • Reviewed data sources and redesigned the Access database structure including macros (VBA) used to generate Excel reports.

Show More

25. Sharepoint

average Demand
Here's how Sharepoint is used in Data Analyst jobs:
  • Manage weapon system project websites via SharePoint, including troubleshooting technical issues and developing guidelines for public/private information and user permissions.
  • Developed on-line portal sites utilizing Microsoft SharePoint 2007, enabling the organization to collaborate more effectively with external customers.
  • Improved workload delegation and customer satisfaction maintenance by creating metrics dashboards in Excel that automatically published results to SharePoint.
  • Served as Administrator on SharePoint portal ensuring quality assurance, maximum portal functionality, and secure access.
  • Served as Home Care SharePoint site administrator including management and overall maintenance of entity policies and procedures.
  • Served as the team's SharePoint Administrator, administering and conceptualizing SharePoint solutions for data management.
  • Provided SharePoint administration and maintenance support through site restructuring, document standardization, and access control.
  • Migrated Plan View software from Small Business Portfolios into Microsoft SharePoint Reporting and Project collaboration.
  • Maintained team SharePoint and associated reports and distribution lists to more effectively reach internal customers.
  • Utilized Microsoft SharePoint to manage and collaborate portal content, project documentation and report data.
  • Maintained department SharePoint site modifying inventory tracking spreadsheets and uploading new documents as required.
  • Manage Customer-Insight SharePoint website including employee access, content management, and storage capacity.
  • Worked closely with Project Managers to update and maintain SharePoint/Google docs with accurate information.
  • Uploaded and managed customer facing documentation on SHAREPOINT regarding the end-to-end data quality process.
  • Experience utilizing SharePoint for project management and developing a proof of concept demonstration.
  • Increased communication with customers by creating and monitoring the current department SharePoint site.
  • Updated content displayed on department specific SharePoint sites used for document collaboration.
  • Created organizational and project level SharePoint websites including PowerPoint training materials.
  • Administered SharePoint libraries between local government offices and summer associates.
  • Maintain and Upload Raw Materials Specifications documents to SharePoint database.

Show More

26. QA

average Demand
Here's how QA is used in Data Analyst jobs:
  • Procured documentation for utilization management rebuttal of NCQA ruling resulting in 3-year accreditation status for company.
  • Developed project documentation including use case scenarios, test plans and coordinated project implementation with QA.
  • Designed and implemented product QA process that significantly improved employee efficiency and improved data accuracy.
  • Provided information graphics during committee meeting presentations and participated in NCQA SNP surveys.
  • Assisted the case manager/administrator/QA Director/Director of Nurses with patient care as needed.
  • Delivered thorough QA testing reports that determined product quality and release readiness.
  • Deployed separate development and QA environments, increasing production system performance.
  • Contributed to Quality Assurance process development and QA process documentation.
  • Restructured QA department to provide efficient coverage while reducing expenses.
  • Coordinated all QA activities and enhancements using Agile Methodology.
  • Recommend new QA/QC techniques across operational business units.
  • Performed Data QA on electronic automotive catalog data.
  • Developed/executed QA and Security plans.
  • Used and trained others to use Microsoft Access databases for data entry, QA/QC, data retrieval and summary product generation.
  • Prepared and tested data loads into internal systems as well as communicated with developers regarding requirements, testing and QA processes.
  • Provide data management discrepancy reporting, and perform internal QA/QC audits to ensure operations are in compliance with Performance Work Statement.
  • Assessed QA performance - Retrieved and analyzed QA information to identify root causes of performance gaps and other QA problems.
  • Provided control, support, and analysis of reporting upgrades for canned, QA, NYA, and custom reports.
  • Prepared productive spreadsheets for various functions which included RQA, URS, manual billing, quarterly and various other reports.
  • Collaborated with QA teams on-shore and off-shore to set up data links for assisting with application testing on production data.

Show More

27. Analyze Data

average Demand
Here's how Analyze Data is used in Data Analyst jobs:
  • Collect and analyze data to identify financial representatives based on incomplete/inaccurate information
  • Gathered requirements, analyze data and create functional/technical specifications to functionality required by new business rules, regulations or standards change.
  • Research and analyze data anomalies utilizing analytic skills and cross referencing different vendor data feeds, publications, and financial websites.
  • Collaborate with other areas to coordinate research and analyze data for planning and development of Quality Management Initiatives.
  • Analyze database imported into Oracle to ensure data validity, remove duplicates and resolve inconsistencies and inaccuracies.
  • Utilized strong problem solving and trouble-shooting skills to analyze data and develop solutions to complex business objectives.
  • Developed and conducted student surveys to analyze data regarding student engagement and participation at the university.
  • Developed milestone testing procedures that were utilized to properly analyze data, incorporated the use of SalesForce.com
  • Updated Infection Control data and coordinated with Quality Department to analyze data for accuracy.
  • Collaborated with Infection Prevention team to compile/analyze data and identify areas for improvement.
  • Analyze data and forward recommendations and proposed solutions to the upper management.
  • Analyze data to identify current or emerging trends linked to illegal activity.
  • Develop statistical reports and analyze data for report to management.
  • Monitor and analyze data for utility billing/CRM systems supporting 200+ users
  • Research and analyze data to provide process improvement opportunities.
  • Maintain and analyze data for quarterly presentations to executives.
  • Collect and analyze data for Centralized Monitoring Program.
  • Analyze data, develop and implement reports/ visualization.
  • Used automatic applicant tracking system to analyze data!
  • Analyze data to provide department with Maintenance analysis.

Show More

28. Ssis

average Demand
Here's how Ssis is used in Data Analyst jobs:
  • Reviewed and assisted in updating various documents; Business Requirements, Data Modeling Documents, and Application Functional Design Documents.
  • Modified database structures as directed by developers for test/develop environments and assist with coding, design and performance tuning.
  • Assisted with fund management by collaborating closely with management to ensure proper expense management and documentation of funds generated.
  • Develop programs and databases to assist staff in accurately capturing and recording data for study and validation.
  • Assisted finance managers in operations and services department with monthly reconciliation of quality assurance and warranty reports.
  • Assist in the development and enforcement of quality control methods/standards necessary to maintain data integrity and security.
  • Assisted regional sales representatives by providing expertise in customer and vendor contractual agreements and product research.
  • Provide administrative information and assistance concerning case to other investigative agencies, local law enforcement agencies.
  • Designed and implemented operations reports for Equity Derivatives Department that assisted department head in budgeting issues.
  • Created SSIS packages according to client-facing specific requirements to ensure data accuracy and timely processing.
  • Collected and extracted related data from various public sources to assist in selecting economic predictors.
  • Developed daily reports to assist department in maintaining compliance with federal and state regulations.
  • Assisted in providing excellent customer and data services; distinguishing Verizon Wireless from competitors.
  • Assisted Oncology Fellows to facilitate audits with their Investigator Initiated and Cooperative Group studies.
  • Provide assistance in administrative activities and coordination efforts with program/ project staff as necessary.
  • Assisted with the planning and facilitation of exercise development meetings involving over 100 participants.
  • Assist lead analyst or official in obtaining/collecting all documents/information to complete case file.
  • Assisted with management of local customer price authorizations with emphasis on price analysis.
  • Assisted the Maintenance Manager in the coordination/implementation of the Systems Scheduled Maintenance Plan.
  • Analyze management information requirements to assist in the development of administrative reporting systems.

Show More

29. Toad

average Demand
Here's how Toad is used in Data Analyst jobs:
  • Loaded flat file data into Oracle9i stage tables using SQL Loader, TOAD, and Oracle Data Integrator (ODI).
  • Used SQL (TOAD) to research and validate data along with Access, Excel and Business Objects to build reports.
  • Created scripts to create new tables, views, queries for new enhancement in the application using SQL Developer and TOAD.
  • Experienced using TOAD, SQL Developer tools to develop Oracle stored packages, functions and procedures for Oracle database back-end validations.
  • Used SQL database tools such as TOAD for Oracle and batch file scripting to assist in improving standard operating procedures.
  • Load and maintain inventory by site, customer, inventory and vendor data using CuteFTP, TOAD and other programs.
  • Perform Data Integration, Data comparison and Data Validation for Back End Testing by using SQL Queries (TOAD).
  • File transfer using UNIX, Toad and other IT applications for loading of data files for clinical studies for Pfizer.
  • Worked on specification design, ETL development and scripts in Oracle/TOAD, as well as user acceptance testing/validation checks.
  • Executed SQL queries on Toad and extracted data from database for generation of data required for automation test scripts.
  • Utilized Oracle, Toad and MS Access and SQL skills to provide data analysis and to resolve data errors.
  • Use Toad software to access and manage our data through the process of creating and running PL/SQL scripts.
  • Input data through a system architecture application (Java) and verify Oracle db changes utilizing Toad.
  • Developed SQL queries in SQL Server management studio, Toad and generated complex reports forth end users.
  • Worked on TOAD and Oracle SQL Developer to develop queries and create procedures and packages in Oracle.
  • Used TOAD to develop and execute test scripts in SQL, to validate the test cases.
  • Migrated Progress, PostgreSQL database and Access data to SQL 2005 by using SSIS and Toad.
  • Perform data modeling, periodic report validation and data analysis by writing SQL queries using TOAD.
  • Performed customer reference and transaction data quality testing using Toad for Oracle and Oracle SQL Developer.
  • Used application development tools like TOAD (Oracle) to develop SQL queries and stored procedures.

Show More

30. EDI

low Demand
Here's how EDI is used in Data Analyst jobs:
  • Supported implementation of social media tools to drive new reporting solutions and improve our ability to operate efficiently and continuously.
  • Verified accuracy by abstracting information from patient medical records and obtained information from inter departments where services were rendered.
  • Reviewed files uploaded to dedicated server for automatic invoice payment and reported errors to account managers for correction.
  • Oversee the provider termination process including adding and changing new or existing provider records in medical information system.
  • Investigated pricing of regional and local medical services to help supplement and develop a competitive pricing model.
  • Worked on writing functional specification for reporting module that handled credit and consumer risk management services.
  • Partnered with Medical Records Department to validate the coding of records resulting in Patient Safety indicator.
  • Coordinated with physicians, epidemiologists, registered dietitians, and statisticians in conducting medical studies.
  • Report, work and monitor duplicate and deceased patient medical record numbers daily upon notification.
  • Expedite repairs and/or replacement deliveries as necessary to ensure production line is minimally affected.
  • Solicited and retained prospective clients through presentations of data analyzed and potential fraud predictions.
  • Work with managers in a medical case management operation to understand challenges and opportunities.
  • Developed and maintained databases, and created a national Fee-for-Service and Managed Medicaid Database.
  • Analyze documents and ensure accuracy between international importers and exporters to expedite customs process.
  • Provided Asbestos Litigation Support Analyzed Medical Claims, Exposure Claims & Legal Documentation.
  • Prepared documentation to support regulation per State, Federal, and accreditation requirements.
  • Extracted and analyze clinical information from patient medical charts for appropriateness for database.
  • Analyzed and corrected incorrect URL addresses Used Microsoft Access to organized medical data
  • Edited and formatted toxicology procedural guidelines for drug and heavy metal testing.
  • Developed predictive model for early detection of account delinquency using logistic regression.

Show More

31. Ssrs

low Demand
Here's how Ssrs is used in Data Analyst jobs:
  • Generated reports based on requested specifications from end users and business analysts using SSRS.
  • Developed several operational reports using SSRS.
  • Created reports in SSRS with different type of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.
  • Involved in SQL ServerReporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports.
  • Developed and maintained the integrity of the financial reporting process and financial controls using SQL (SSIS and SSRS) packages.
  • Acted as a Strong Data Analyst analyzing the data from low level and Generated Reports using SSRS and Excel Spreadsheet.
  • Performed initial configuration of client systems which entailed installing and configuring SQL Server, SSRS and initial setup of IIS.
  • Generated monthly and quarterly reports for bookings statistics, daily job monitoring dashboards for client applications using Tableau and SSRS.
  • Created SSRS reports: matrix & column reports, reports with drop down menu, dynamic & cascading input parameters.
  • Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
  • Created complex SQL code in SQL views and stored procedures to act as data sources for new SSRS reports.
  • Create interactive, tabular and graphical reports from relational databases which had already created in SQL server using SSRS.
  • Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.
  • Create monthly KPI reports and dashboards for various business units and executives using Tableau, SSRS, and Excel.
  • Deployed SSRS reports to the reporting server in Native and SP integrated mode and assisted in troubleshooting deployment problems.
  • Tested different SSRS reports ensuring it meets design goals and Clients' needs and the report behaves as intended.
  • Created different types of reports such as Tabular, Matrix and Drill Down reports using SSRS report wizard.
  • Converted, simplified and automated a number of manually generated reports from excel and crystal reports to SSRS.
  • Created Report Template, Sub Reports, Matrix Reports, dashboard with charts, Drill-down reports using SSRS.
  • Created, published, scheduled and maintained Business Objects, SSRS reports publisher, Business Objects Console Management.

Show More

32. Management System

low Demand
Here's how Management System is used in Data Analyst jobs:
  • Generated certificates of analysis for final products using laboratory information management system (LIMS) software and electronically distributed to clients.
  • Assist in the development and implementation of corporate compliance management system assessment and corrective action projects and developing recommendations for improvements.
  • Participated in the testing and evaluation of beta applications for release and made modifications to existing data management systems.
  • Led the implementation of learning management system through researching potential vendors, conducting internal needs assessments and vendor selection.
  • Analyze certification data and determine proper time and resources necessary to successfully integrate data into Oracle Identity Management systems.
  • Participate in business development sessions with users to document and enter key information into the Vignette content management system.
  • Coordinate the development and validation, implementation, assessment, and training for electronic data collection and management systems.
  • Implemented and configured direct integration solution allowing single sign-on via various Learning Management Systems to Pearson Publishing content.
  • Maintain records providing evidence of conformity to product specifications and the effective operation of the quality management system.
  • Performed interviews and facilitated meetings to obtain the business requirements in support of a lease management systems implementation.
  • Perform data entry and analysis of contracting and purchasing information, utilizing the Lawson automated materials management system.
  • Performed qualitative and quantitative analysis of data maintained in the Marine Corps Total Force Structure Management System.
  • Analyzed and interpreted contract terms to produce metadata used in preparation for migration between contract management systems.
  • Ensured proper software configuration and execution of each Command Management System component prior to installation in production.
  • Analyzed and coordinated inputs into an automated management system used to track changes in configuration status.
  • Trained 15 staff members to operate a comprehensive and flexible statistical analysis and data management system.
  • Developed client specific fixes so that data easily reconciles within clients own portfolio management systems.
  • Created and maintained computerized record management systems to record and process data and generate reports.
  • Provided technical consulting service for medical industries and hospitals for data management systems and software.
  • Documented and communicated business Requirements for the development of Identity and Access Management System solutions.

Show More

33. XML

low Demand
Here's how XML is used in Data Analyst jobs:
  • Created and implemented Access database, generating XML data to feed JavaScript visualization of technology system relationships.
  • Managed and supported modifications of business critical XML data documents per business user requirements.
  • Performed customization of standard Oracle reports and developed custom reports using XML Publisher.
  • Developed XML-parsing PHP files that generated customized tabular data views.
  • Worked extensively with XML schema generation.
  • Tested XML scripts in Traffic Patterns Research Platform Routing software for North America, Australia and Europe for product development team.
  • Performed data testing, tested ETL mappings (Transformation logic), tested stored procedures, and tested the XML messages.
  • Monitored the XML message for the Interface Applications using EAS (Enterprise Audit System) Viewer as the monitoring agent tool.
  • Worked with different source & target systems like XML, flat file, relational tables and message queues(MSMQ).
  • Imported and exported data using TSQL, XML, was responsible for the Data Mining processes for the Data Warehouse.
  • Created ETL packages in SSIS for cleaning and loading order data from XML web source to on-site SQL Server database.
  • Created a data layout in ACORD Stand format using XML for developers to write the application for data processing.
  • Implemented XML filters to accurately configure large data feeds obtained through FTP and data management systems for client use.
  • Designed and implemented an extensive data audit system between Emission DAS, Emission Central Warehouse and EPA XML data.
  • Web service output standardized address information as XML to the client based on input required to be postal information.
  • Analyzed customers inbound data files and wrote Mapping Rules for XML conversion clients for both check and ACH payments.
  • Created a Java Application to parse data from large XML file coming through TCP/IP and stored into database accordingly.
  • Design and test delivery of XML through Single Object Access Protocols to ensure secure transfer of sensitive data.
  • Worked on requirements for XML schema used in integration of local Broker Sales Office application with corporate database.
  • Created, Generated, Parsed, Normalized XML markup for medical x-ray, lab, and billing results.

Show More

34. DB2

low Demand
Here's how DB2 is used in Data Analyst jobs:
  • Provided installation and customization of DB2 system and administration support for three Federal Reserve Banks and several major central applications.
  • Supported Online Claim Processor and related downstream reporting application in DB2-IMS-CICS environment.
  • Developed logical and physical data models utilizing IEF/Composer for DB2 databases.
  • Implemented and supported DB2 databases and multiple application development projects.
  • Maintained user administrative rights within DB2 database.
  • Developed an online CPT/HCPCS tracking application using DB2/CICS which allowed medical staffs to view, edit and validate medical billing code.
  • Analyzed the IMS/DC online screens, programs and DB2 database model in order to acquire needed knowledge for achieving data analysis.
  • Experience in Importing/Exporting Data from various data sources like Excel, Oracle, DB2 and Flat file using DTS utility.
  • Developed stored procedures, user-defined functions, triggers, indexes, cursors and views in SQL Server, DB2 databases.
  • Performed data analysis tasks on warehouses from several sources like Oracle, DB2 and generated various reports and documents.
  • Examined and updated all the programs which were going to affect during major database upgrade from DB2v9 to DB2v10.
  • Checked the extracted data for any loss of precision or incorrect data using both DB2 Control Center and Trillium.
  • Developed FTP process to download files from the DB2 database and import to MS Access application for reporting purposes.
  • Experience in writing complex SQL Queries, extract data from Oracle, MS-SQL Server and IBMDB2 Data base.
  • Design test-data load scripts to move data from Excel/Access to DB2 database using IBM loader mainframe JCL jobs.
  • Developed batch programs using COBOL to extract the medical data from HL7 messages and store in DB2 tables.
  • Develop processes to determine how to extract and populate application data via SQL's and other DB2 tools.
  • Convert an inventory assignment system from IMS data storage to a DB2 database on the OS/390 operating system.
  • Designed complex SQL queries to pull the accounts from DB2 databases with specific transactions which were being tested.
  • Performed code changes, enhancements, and analysis for programs within a retail environment using COBOL and DB2.

Show More

35. BI

low Demand
Here's how BI is used in Data Analyst jobs:
  • Standardized Data Entry associate responsibilities Skills Used Leadership Proficient and Advanced Reporting Data Integrity Team Work Advanced MSFT Excel training for associates
  • Analyzed medical and pharmacy claims data as well as eligibility information to compile statistical and outcome reports based upon HEDIS guidelines.
  • Analyzed massive and highly complex data sets to assess production capacity, process quality and technical capabilities of manufacturing plants.
  • Researched, created, and maintained public company management profiles and individual executive and director biographical profiles for equity database.
  • Performed Data Management duties; acquired validated, processed, stored and protected data for reliable accessibility to data users.
  • Report and Audit policies and procedures of multiple business and IT departments to increase service availability for highly available applications.
  • Designed and created a database using data modeling techniques to store patient information including visit history and financial/billing data.
  • Analyze existing methods and techniques to implement more efficient solutions for data processing, including big-data repository and mapping.
  • Produced contract deliverable technical documentation and presentations relating to the Polar Orbiting Platforms and the Solar Arrays.
  • Established acquisition program, increased quantity and availability of media holdings in an environment of decreased funding.
  • Sole responsibility for critical maintenance of company's major production and standby databases with daily synchronization.
  • Categorized content data for intuitive product application user experiences and to diversify the data s usability.
  • Utilize detailed familiarity with most major wireless carrier billing systems to navigate to the required information.
  • Performed warranty data statistical analysis to support reliability and product engineers in problem detection and resolution.
  • Analyzed applicant's financial status, credit and property evaluation to determine feasibility of granting loan.
  • Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.
  • Create, and maintain eligibility database; analyze and audit all eligibility data for accuracy.
  • Designed and structured financial reporting models for forecasting total plan liability on self funded accounts.
  • Interacted with senior management on daily basis, assume additional responsibilities and lead status meeting.
  • Key responsibilities: Data cleanup Data source identification and collection Data Processing Various administrative tasks

Show More

36. Suite

low Demand
Here's how Suite is used in Data Analyst jobs:
  • Identified and implemented HootSuite social media content management system and saved time spent in updating multiple social media accounts individually.
  • Produced suite of reports used by SeniorBusiness Managers to guide decisions such as promotional messaging adjustments and performance reviews.
  • Target efficiency issues and quality improvement: collaborate with C-suite, clinicians, and quality improvement committee members
  • Perform extensive data analysis and catalog management functions related to the product suite.
  • Created C-Suite presentations for quarterly performance of Media Monitoring Unit for management.
  • Provide credible advice on strategic investment decisions best-suited to individual client needs.
  • Designed cold start methodology within the media optimization suite.
  • Developed and designed executive dashboards and report suite.
  • Manage and create both clinical and device reports within the BioPharm Suite for external clients as well as internal management teams.
  • Utilize technology suites such as Business Objects, Access queries, and Excel macros to update our team's existing processes.
  • Develop familiarity with the suite of standard Web CRD/IARD reports and utilize them when possible in responding to constituent requests.
  • Construct a suite of tests and test-data which is sufficient to prove that the entire process does not contain errors.
  • Designed a suite of daily reports and fully automated their execution, saving over 2 hours of work per day.
  • Maintain new and existing builder records, and utilizes Microsoft Office Suites and other software to provide management reporting services.
  • Trained and provided technical assistance to new team members on Oracle E-Business Suite, and Parts Edge order entry tool.
  • Integrate all Sales data to cross compare to the data into NetSuite business system to compensate the difference.
  • Conceptualized and developed a test suite for bulk testing of 10,000+ test cases, pulling from production data.
  • Created data model and suite of data tracking and reporting applications to capture and report on server status.
  • Work closely with offices to maintain a daily surgical schedule in coordination with the hospital surgical suite protocol.
  • Created Reusable Actions and Functions in descriptive programming to add the new feature with the existing test suite.

Show More

37. UAT

low Demand
Here's how UAT is used in Data Analyst jobs:
  • Generated situation-specific reports and performed related investigative analysis.
  • Performed data extraction, data transformation and load processes on call center data to evaluate customer eligibility and create retention standards.
  • Used on-site observation, A/B testing and performance evaluation to assess overall usability and student/teacher engagement with e-learning software packages.
  • Reviewed, analyzed, evaluated, and validated provider/producer information against business/credentialing requirements and maintained information in credentialing data bases.
  • Evaluate business trends/data; define and document functional design and align solutions to strategic information requirements of the business unit.
  • Evaluated changes in protocols and deadlines addressed abstract related problems and clarified documentation through consultation with co-workers and CHOICE specialists.
  • Provided accurate and appropriate interpretation of data; applied knowledge to evaluation, analysis, and interpretation of data.
  • Company Research - Assisted in collecting, organizing and processing daily information on special-situation companies in the investment universe.
  • Conduct evaluations of existing legacy systems functionality and requirements in order to recommend retirement or interface to FBMS.
  • Assisted in evaluating and recommendation of improving mobile phones and wireless internet per testing devices functionality for flaws.
  • Gathered specifications for a budgeting, forecasting, and expenses analysis and reporting for evaluating Employee Performance.
  • Assist with customer licensing issues, including ensuring license validity, generating evaluation or temporary development licenses.
  • Reported discrepant information in appropriate queue for additional quality assurance assessment and evaluation purposes by project manager.
  • Prepared profitability analysis and evaluate new products including pricing relative to the market & setting up appropriate markups
  • Gathered and distilled complex technical information from multiple sources, evaluated inputs critically and reconciled conflicts.
  • Experience in evaluating current operations, financial, budgetary, business and operational data and outcomes.
  • Test and evaluate system upgrades for current regulation requirements and electronic 'paperless' filing procedures.
  • Applied agile methodology; data extraction, technical analysis, evaluation and reporting system performance.
  • Evaluate program impact of decisions and initiates adjustments to balance total force manpower requirements.
  • Achieved a significant increase in accuracy by eliminating discrepancies/errors in valuations and cash flow.

Show More

38. Python

low Demand
Here's how Python is used in Data Analyst jobs:
  • Programmed and designed a text analysis algorithm in MATLAB and Python to provide additional information regarding the patients
  • Worked on sentiment analysis in python to analyze the severity of crime/fraudulent activity from the articles.
  • Develop Python solutions associated with GIS data collection, management and utilization.
  • Automated web-scraping tool to produce marketing content using Python.
  • Developed Python Scripts to assist in testing trading functionality.
  • Created test harness to enable comprehensive testing utilizing Python.
  • Developed clustering models for customer segmentation using Python.
  • Developed automatic detection algorithm using Python and SQL.
  • Prepared and analyzed reports using python libraries.
  • Performed Data analysis using Python Pandas.
  • Apply power analysis to determine required sample size for ad relevancy testing using either random sampling or stratified sampling using Python.
  • Visualized market data, based on historical information, using Tableau and Python, to help in presenting current business situation.
  • Used SQL and Python to automate monthly reports and build admin dashboard for player tracking metrics from the ground up.
  • Designed and implemented Web crawler to search web pages, fetch data and remodel it based on Python, Selenium.
  • Developed state-of-the-art software programs to collect, and analyze large volumes of structured and/or unstructured data using SAS and Python.
  • Obtained relevant and popular economic information based on the dictionary through the development of a web crawler using Python programming.
  • Scripted ETL process for multiple data warehouse projects from various sources dealing with millions of transactions using SQL and Python.
  • Used SQL, R, and Python to extract, clean and organize data to build models with high accuracy.
  • Processed and analyzed data based on the statistical principles by using python, and accomplished data visualization by using SAS.
  • Created Python and Bash tools to increase efficiency of call center application system and operations; data conversion scripts.

Show More

39. Monthly Reports

low Demand
Here's how Monthly Reports is used in Data Analyst jobs:
  • Coordinated and monitored with special projects, assisted clinical policies and procedures and generated monthly reports-Action plans as an Assistant Administrator.
  • Redesigned filing systems by transferring documents into electronic database increasing staff access to essential information and reducing errors on monthly reports.
  • Prepared and presented monthly reports on facility CPR data to an internal committee comprised of high level hospital administrators.
  • Provided monthly reports to supervisor, analyzing the performance and identifying bottlenecks in the process and suggesting improvements.
  • Analyzed duplicate data or errors in data to provide appropriate inter-departmental communication and monthly reports.
  • Helped to automate very manually intensive daily and monthly reports for national and international audiences.
  • Generated daily, weekly and monthly reports regarding assigned projects to designated business users.
  • Researched / reported on revenue-recognition issues for operations and finance; prepared monthly reports.
  • Monitor and audit weekly/monthly reports from participating hospitals, ensuring accuracy of database.
  • Developed ongoing monthly reports that demonstrate effective market penetration using our mobile software.
  • Examined and conducted comparative analysis of financial information and provided monthly reports.
  • Developed and produced monthly reports summarizing business activity, delinquency & loss.
  • Performed daily back-ups of monthly reports and operated PC-maintenance data conversion program.
  • Prepared and presented weekly/monthly reports detailing instrumentation performance during launch activities.
  • Generated monthly reports to contract managers and technical support.
  • Analyzed monthly reports ensuring accuracy and on time distribution.
  • Generated monthly reports/scorecard for manage level review using Excel pivot
  • Prepared monthly reports and assisted in analyzing outcome data.
  • Automated monthly reports increasing efficiency using Excel and Access.
  • Compiled statistical information for special and monthly reports.

Show More

40. CRM

low Demand
Here's how CRM is used in Data Analyst jobs:
  • Worked directly with CRM team to optimize email communications and segmentation by providing concise analysis and actionable recommendations through A/B testing.
  • Managed CRM database and utilized consumer data to accurately predict costumers' behaviors for targeting and maintaining long-lasting customer relationships.
  • Recorded information in database and placed specifications on company website using Microsoft Excel and Microsoft CRM.
  • Developed a relationship / financial management reporting database to replace an existing CRM tool.
  • Customized CRM contact forms and tags to expand investor categorization and targeting capabilities.
  • Performed data validation and data quality remediation for a CRM consolidation project.
  • Update records in proprietary CRM accurately, monitoring and reporting systemic errors.
  • Facilitated and validated data migration from MS Dynamics CRM to SalesForce.com.
  • Developed methodology to pinpoint irregularities within the CRM database.
  • Develop proactive/self-help solutions through analysis of CRM system.
  • Supported CRM Team for their marketing campaign planning by creating targeted customer base lists using propensity models and specific criteria provided.
  • Prepared a written manual for data entry, which was shared with staff and industry entities on using the CRM system.
  • Utilized SalesForce CRM system to respond, document and close subscriber request cases as well as escalate and support resulting tickets.
  • Provided Customer Master Data analysis, cleanup and loading of data into test and production environments in the SAP CRM module.
  • Complete assigned work queues in CRM (client relations manager) system, for facilities, group and solo providers.
  • Created scripts and SQL queries to create Total Report system, controlled sale and CRM website tool for best result.
  • Developed statistical model using SQL and Visual Basic to correlate CRM data with marketing intelligence to predict future customer purchases.
  • Attend multiple impromptu Data Analysis Conference Calls to review CRM table updates and address any issues and Q&A.
  • Assisted with the creation of service contracts in the ERP/CRM application to ensure proper customer invoicing and revenue recognition calculations.
  • Assessed customer behavior and developed reporting tool for CRM to track new opportunities and marketing strategies based on behavioral trends.

Show More

41. Html

low Demand
Here's how Html is used in Data Analyst jobs:
  • Developed MacroMedia and HTML based application designed to interface and enhance vendor data repository to Enterprise Data Warehouse internal clients.
  • Performed independent data collection and organization into file structures * Updated and maintained HTML pages
  • Provided first tier support to all internal customers using Advantage Metadata Repository, including HTML and Cold Fusion support development efforts.
  • Worked on estimation, design and development of changes for web pages using XML, HTML, CSS and Java script.
  • Created Text and HTML reports for presentation to CMS (Center for Medicare and Medicaid services) in the prescribed format.
  • Developed the user interfaces of the application using ASP.NET Server Controls, HTML Controls, XHTML, Java Script and CSS.
  • Designed and implemented a web based Decision Tree model viewer using ASP.NET, C#.NET, JavaScript, and HTML.
  • Generated high quality reports and documented SAS programs, and exported SAS outputs to RTF and HTML using SAS ODS facility.
  • Produce SAS outputs in RTF, PDF, CSV and HTML formats using Output Delivery System (ODS) facility.
  • Design and develop both client-facing and internal company software programs using Python, PHP, JavaScript, and HTML/CSS.
  • Designed, created and maintained cross-browser compliant web applications by hand-coding HTML, JavaScript, CGI Perl, CSS.
  • Produced RTF, PDF and HTML formatted files using SAS/ODS to produce ADHOC reports for presentation and further analysis.
  • Web Form design and coding using Master Pages, Server controls, Cascading Style Sheets, JavaScript, HTML5.
  • Generated HTML, RTF, PDF and text reports using ODS statements and performed data analysis using SAS Base.
  • Develop SAS Macros programs to automate algorithm development process, create HTML reports, and interpret data analyses 5.
  • Designed and developed intranet websites to interface Global taxonomy via Front Page, HTML and Q&E.
  • Designed, formatted, up-dated and organized the left-hand navigation menu and web subject matter using HTML format.
  • Provided various, basic HTML coding help to create and update new verticals within the WordPress database.
  • Used SAS ODS for generating reports in RTF, PDF and HTML formats as specified by statistician.
  • Worked with marketing team to implement strategies by maintaining website and articles on WordPress using HTML language.

Show More

42. T-Sql

low Demand
Here's how T-Sql is used in Data Analyst jobs:
  • Compose fast and accurate T-SQL statements for statistical analysis and create scheduled/automated reports using SQL Server Reporting Services.
  • Designed and implemented T-SQL procedures that address complex data retrieval and calculations.
  • Performed T-SQL and development mentoring for report developers
  • Developed tools, using VBA, T-SQL, Access, and Excel, to assist with data flow and work delegation.
  • Understand T-SQL functions for data aggregation and drilling into data, depending on weekly, monthly or yearly views of data.
  • Created complex Stored Procedures, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
  • Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
  • Created complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
  • Involved in writing T-SQL, working on SSIS, SSRS, SSAS, Data Cleansing, Data Scrubbing and Data Migration.
  • Utilized querying relational databases (T-SQL) and Microsoft SQL Server Integration Services to pull and integrate data from various sources.
  • Created and Manage schema objects such as tables, views, indexes, User define function and Store procedures using T-SQL.
  • Queried SQL Developer (PL/SQL and T-SQL) to research, Insert, Update, or Merge necessary changes in data.
  • Developed database and extract, translate and loading requirements for the new data feeds (SQL Server 2008 and T-SQL).
  • Involved in writing T-SQL, stored procedures, views, triggers, used indexes, constraints & business rules wherever applicable.
  • Learned T-SQL and how to write (mostly set based) stored procedures to build complex queries needed for reports.
  • Write T-SQL and Oracle SQL Queries to pull data for client review, create reports, and create/load/update data tables.
  • Created numerous simple to complex queries involving self joins, correlated sub-queries, functions, cursors, dynamic T-SQL.
  • Supported and adapted existing and developed new T-SQL, Access, Excel and VBA applications, tools and reporting.
  • Extract data from SQL Server, access and query Integrated Data Repository using SAS Enterprise BI and Transact-SQL.
  • Used T-SQL to analyze, query, sort and manipulate data according to defined business rules and procedures.

Show More

43. Technical Support

low Demand
Here's how Technical Support is used in Data Analyst jobs:
  • Perform technical support for analyzing system and data problems that have been discovered within maintenance systems/applications, specifically Maintenance Performance Toolbox.
  • Provided professional level technical support to clients related to the identification, analysis and evaluation of complex defense systems or issues.
  • Designed and delivered Tableau data visualizations for clients, developed user stories, assisted in troubleshooting and technical support.
  • Provided enterprise-wide technical support to database users including advice to users on query writing and tuning user queries.
  • Provided technical support and consultation to internal and external customers regarding secure electronic data transmissions and file formats.
  • Provide technical support and identify the educational and training needs of radiation control staff and external stakeholders.
  • Provided technical support to end-users through data analysis to identify and address internal and external department constraints.
  • Implemented troubleshooting and technical support with migrations, network connectivity, and security and database applications.
  • Provide analytic and technical support to sales management regarding various sales reporting initiatives and targeting efforts.
  • Performed comparative analysis of District Test Scores -Provide administrative and technical support to senior management.
  • Developed, documented, and communicated business and/or technical requirements between customer and technical support.
  • Provide telephonic and electronic Technical Support for customers who use wireless data products and services.
  • Provided critical technical support to engineers and computer programmers by generating accurate and timely data.
  • Identified and resolved technical support issues regarding application specific data and business process flows.
  • Designed and delivered end-user training and training materials; provide technical support as necessary.
  • Improved engineering productivity by providing technical support on current rack configurations and systems topography.
  • Validated critical test instrumentation, collected data and provided technical support during engine test.
  • Interfaced with technical support by beta testing new features and representing user-identified issues.
  • Researched and resolved internal technical support questions regarding bank programs and SalesMaker calculations.
  • Provided technical support for multiple product configurations for complete and accurate system configuration.

Show More

44. Data Files

low Demand
Here's how Data Files is used in Data Analyst jobs:
  • Created internal production data files required for all imaging lines ensuring compliance with internal equipment specifications and inter-company ISO procedures.
  • Completed multiple complicated data transformation projects converting data files of acquired companies into client's current database standards and formats.
  • Identify and describe data elements and data files/tables required to report and analyze customer real property installed equipment data.
  • Analyzed inbound/outbound data files, delivered data conversion instruction to mapping team via clearly written data conversion specifications.
  • Worked extensively with excel creating macros and updating customer data files to be used for time-sensitive bulk-mailing.
  • Managed over 10000 data files and performed document database management and performed quality control and quality assurance.
  • Process data files in accordance to fixed time constraints, consistently utilizing time management and organizational skills.
  • Analyzed those incoming data files for relevant information and sorted pertinent data accurately for further research.
  • Imported data files, changed initialization parameters, and created resolution procedures to ensure quality control.
  • Processed and analyzed all data files and communicated effectively with the client regarding data error concerns.
  • Manipulated and cleaned simultaneous data files for delivery to clients under internal and external deadlines.
  • Analyzed tax assessor data files and produced programming specifications for overseas programming staff.
  • Maintained data files and database and tracked/reported department development activity and metrics.
  • Provided completed utility meter data files to utility companies across the country.
  • Monitored performance and processed and maintained data files concerning current proficiency.
  • Developed and monitored procedures and functions Managed data files and benchmark.
  • Verified data accuracy and assured security of outgoing data files.
  • Analyze data files received from property taxing authorities/ jurisdictions.
  • Communicated daily with office supervisor about data files.
  • Analyzed data files for completeness and accuracy.

Show More

45. Source Data

low Demand
Here's how Source Data is used in Data Analyst jobs:
  • Prepared source data for computer entry by reviewing, compiling and sorting information while establishing priorities to ensure timely payroll processing.
  • Analyzed different options for heterogeneous database connectivity and defined policies for dealing with different source databases with ETL team.
  • Analyzed raw data from complex financial source data, drawing conclusions & developing recommendations to improve efficiency and/or effectiveness.
  • Performed data analysis of source data and ensured all data was migrated properly and completely between systems.
  • Involved in interacting with business users for requirements gathering and analyzing source data for enterprise reporting.
  • Implemented a database back-end using a popular open-source database technology in accordance to the schema.
  • Analyzed source data to determine options for integration into standard database model.
  • Performed source data analysis and captured metadata, reviewed results with business.
  • Conduct detailed comprehensive searches by identifying and using various source databases.
  • Validate and audit information between source data and business service applications.
  • Verified source data completeness and accuracy while publishing information into database.
  • Performed various mapping from source database to destination database.
  • Manipulated customer source data through designated conversion parameters.
  • Validated externally reported data with internal source data.
  • Designed and managed clinical resource databases for multiple trials
  • Verified completeness and accuracy of source data.
  • Process source data across operational systems.
  • Analyze and design data flow diagrams and components to extract data from source database (Legacy systems) to destination database.
  • Worked on source data profiling, designed Target tables and transformations, error processing to load source data into target tables.
  • Involved in analyzing the source data coming from different Data sources such as XML, DB2, Oracle, flat files.

Show More

46. User Acceptance

low Demand
Here's how User Acceptance is used in Data Analyst jobs:
  • Performed extensive requirements gathering, specification writing, integration testing and assisted the end users in conducting user acceptance testing.
  • Conducted user acceptance testing of new metadata repository software or new versions of currently used metadata repository software.
  • Contributed to Data Warehouse design and performed user acceptance testing in collaboration with Information Services development.
  • Designed developed and implemented user acceptance testing protocols as the final phase of applications development.
  • Participated in user acceptance testing on technology enhancement to firm proprietary and vendor applications.
  • Conducted user acceptance testing with departmental staff and compiled test results for analysis.
  • Participate in User Acceptance Testing and Validation of New Platform Capabilities around Consumption Reporting
  • Supported the back-end developer process by completing user acceptance and functional testing.
  • Worked with business partners to clarify business requirements and obtain user acceptance.
  • Managed database system user acceptance testing and coordinated resolution of issues.
  • Defined and performed user acceptance testing and documentation of system enhancements.
  • Performed User Acceptance Testing to validate that business requirements were followed.
  • Participated in user acceptance testing and testing of new system functionality
  • Participated in User Acceptance Testing for front end application enhancements.
  • Conducted user acceptance testing and data validation of web applications.
  • Participated in user acceptance testing and post-project review sessions.
  • Lead reporting requirements, validation and user acceptance testing.
  • Provided and performed user acceptance testing of data implementation.
  • Performed User Acceptance Test (UAT) and developed procedural documentation to support the implementation of new online product discontinuation processing.
  • Perform user acceptance testing for all scheduled and required technical updates to SAP, including creation and implementation of testing scenarios.

Show More

47. Spss

low Demand
Here's how Spss is used in Data Analyst jobs:
  • Conducted quality control analysis using data from agricultural/scientific research for companies and private scientists using SAS and SPSS.
  • Utilized SPSS modeler to interpret market survey data to identify positive relation between website information and online sales.
  • Performed descriptive and inferential quantitative data analyses using SPSS and SAS and qualitative analyses using Atlas.ti.
  • Generated exam results and frequencies/cross tabulations for course evaluation data report with SPSS.
  • Conduct statistical analysis of survey data using SPSS to formulate predictions and recommendations.
  • Performed quantitative analysis of data using SPSS to uncover deeper insight.
  • Constructed statistical models to conduct data analysis using SPSS.
  • Established user-tracking systems utilizing SPSS and Survey Monkey.
  • Developed multiple regression model using SPSS
  • Utilized statistical analysis software, SPSS, to analyze primary research studies for internal and external clients and provided data summaries.
  • Trained the Adjunct and Tenured Professors on the SPSS program, which could also be used for scoring tests and exams.
  • Solved data problems by using machine learning, R, statistical skills and application development (STATA, SPSS).
  • Conducted data analysis and reports utilizing Excel, Access and SPSS to track and trend recruitment and retention efforts.
  • Performed project and data coordination duties - data entry, development, analysis, and quality assurance utilizing SPSS.
  • Used Excel, SPSS, and SAS Statistical Software to enter and analyze data for several large research projects.
  • Trained analysts and survey programmers, offering support on survey logic, Excel and statistical software packages like SPSS.
  • Used MS Excel and SPSS to respond to questions from management about poverty statistics in the countries FINCA operates.
  • Capitalize on expert knowledge of SPSS to write and update syntax programs to analyze data and produce score reports.
  • Developed new solutions for extracting data from the EHR database using Crystal and SPSS to report on program performance.
  • Performed statistics analysis on the data using SPSS, LIWC (a text mining tool) and Excel.

Show More

48. Special Projects

low Demand
Here's how Special Projects is used in Data Analyst jobs:
  • Selected for special projects such as development and implementation of web-based user acceptance testing and client profile information summaries.
  • Provided assistance to data entry operators in the creation and maintenance of confidential information and special projects.
  • Spear-headed special projects with cardiology service line databases and designed dashboards for high-level data reporting.
  • Participate in MDH and Indoor Environments and Radiation Section quality improvement initiatives and special projects.
  • Prepared and generated statistical reports and special projects dealing with cost analysis and current procedures.
  • Collaborated and assisted Quality Risk Director and Chief Nursing Officer and completed special projects.
  • Complete any special projects relating to data collection analyses as requested by program directors.
  • Executed special projects involving preparation of monthly cash reconciliations and annual audit work papers.
  • Provide special projects management support and demonstrate problem-solving skills for new business processes.
  • Coordinated special projects designed to improve internal communication between departments within banking footprint.
  • Participate in special projects and quality initiatives designed to measure business -level metrics.
  • Generated reports as needed to assist special projects, committees and organization-wide initiatives.
  • Develop and organize training for special projects involving select financial data items.
  • Support department in maintaining schedule, proofreading documentation and executing special projects.
  • Supervised temporary staff and collaborated with numerous departments on special projects.
  • Worked on special projects to improve office efficiency and productivity.
  • Support and accept responsibility for special projects and assignments.
  • Lead special projects for corporate wide efficiency initiatives.
  • Coordinated special projects meeting all deadline requirements.
  • Complete special projects assigned from management.

Show More

49. Data Issues

low Demand
Here's how Data Issues is used in Data Analyst jobs:
  • Provided analysis and integrated solutions to eliminate recurring data issues, which involved documenting processes and/or initiating business process change.
  • Performed in-depth analysis on the business functionality and coordinated with development and testing team on functionality and data issues.
  • Researched mortgage data issues, analyzed files and existing processes or programs while testing data utilizing database application.
  • Worked efficiently and effectively with developers and business data owners to resolve data mapping and data issues.
  • Work collaboratively with internal/external stakeholders to communicate and resolve membership data issues while maintaining exceptional customer service.
  • Researched complex database issues utilizing database management software utilizing problem solving skills to resolve customer data issues.
  • Developed new Data Validation process for payment processing that identified data issues prior to final payment processing.
  • Solve complex data issues and implement solutions to enhance productivity, improve quality and customer satisfaction.
  • Communicated effectively with department management and Field Operations regarding any data issues via phone and email.
  • Communicated with program liaisons concerning data issues and provided recommendations to improve quality and customer service.
  • Researched and resolved data issues between Sirius and partners and performed regular data integrity audits.
  • Develop an improved database system to identify and correct data issues before submitting data.
  • Performed monthly comparison analysis on supplier data to highlight data issues and recommended improvements.
  • Worked with systems team on reporting/data issues and improved database coordination and extraction processes.
  • Handle different data exceptions and data issues within standardized processes using good communication skills.
  • Managed weekly discrepancy meetings and provided resolution to data issues reported by clients.
  • Analyzed data issues, validated results, developed recommendations and implemented process improvements.
  • Identified data issues and provided recommendations for resolution to ensure optimal performance.
  • Perform performance analysis, monitoring, troubleshooting and resolution of data issues.
  • Research and resolved technical tickets related to complex operational or data issues.

Show More

50. Source Systems

low Demand
Here's how Source Systems is used in Data Analyst jobs:
  • Created final source approval and Gap/Recommendation Technical Document for each and every source systems.
  • Summarized reports extrapolating essential information received from various source systems into single cohesive reports.
  • Detailed analysis of mapping business logic and issue management for related source systems.
  • Supervised data gathering efforts consolidating several source systems and spanning 10 years.
  • Analyzed Source systems for consolidating data in Data Warehouse.
  • Identified redundant information across two source systems.
  • Worked on new production processes, including data loading, reconciling to source systems, system SLA's and issue resolution.
  • Create Source to target mapping (ETL Mapping) from various source systems into target EDW (Enterprise Data warehouse).
  • Identified the source systems and analyzed the current source systems to determine which attribute would most like fall in which database.
  • Conducted meetings for the Data Modeling and Analysis and Helped with Data Mapping between the data mart and the Source Systems.
  • Defined corporate Metadata definitions for all Enterprise Data Supported databases (operational source systems, data stores and data marts).
  • Extracted data from various global source systems, performed data cleansing, applied business rules, and loaded into data warehouses.
  • Created a data model for the source systems by creating base objects and defining the relationship between the base objects.
  • Worked to ensure high levels of data consistency between diverse source systems including flat files, XML and SQL Database.
  • Generated SQL reports comparing different source systems to explore data gaps and provide feedback in UAT testing to rectify defects.
  • Maintained ETL mappings to extract data from multiple source systems such as Oracle, SQL Server, and flat files.
  • Provide guidance/information on the data available in the source systems and the best way to extract and use the data.
  • Worked on data profiling and data validation to ensure the accuracy of the data between the warehouse and source systems.
  • Integrated data from disparate source systems in order to provide the client with new tools, reports, and dashboards.
  • Developed SSIS packages to extract data from source systems and conditionally load them into targets as per business requirements.

Show More

20 Most Common Skill for a Data Analyst

Database16.6%
Pl/Sql12.9%
Data Warehouse12.4%
Data Analysis9.6%
Financial Statements5.5%
Business Requirements5.3%
Data Entry4.6%
SQL4.5%

Typical Skill-Sets Required For A Data Analyst

RankSkillPercentage of ResumesPercentage
1
1
Database
Database
12.4%
12.4%
2
2
Pl/Sql
Pl/Sql
9.6%
9.6%
3
3
Data Warehouse
Data Warehouse
9.3%
9.3%
4
4
Data Analysis
Data Analysis
7.1%
7.1%
5
5
Financial Statements
Financial Statements
4.1%
4.1%
6
6
Business Requirements
Business Requirements
4%
4%
7
7
Data Entry
Data Entry
3.5%
3.5%
8
8
SQL
SQL
3.4%
3.4%
9
9
ETL
ETL
2.6%
2.6%
10
10
SAS
SAS
2.3%
2.3%
11
11
Test Cases
Test Cases
2.1%
2.1%
12
12
Data Management
Data Management
2.1%
2.1%
13
13
Windows XP
Windows XP
1.8%
1.8%
14
14
Unix
Unix
1.7%
1.7%
15
15
Data Collection
Data Collection
1.6%
1.6%
16
16
Data Integrity
Data Integrity
1.6%
1.6%
17
17
Customer Service
Customer Service
1.6%
1.6%
18
18
Pivot Tables
Pivot Tables
1.5%
1.5%
19
19
Powerpoint
Powerpoint
1.4%
1.4%
20
20
Teradata
Teradata
1.2%
1.2%
21
21
Visio
Visio
1.2%
1.2%
22
22
Informatica
Informatica
1.2%
1.2%
23
23
R
R
1.2%
1.2%
24
24
VBA
VBA
1.2%
1.2%
25
25
Sharepoint
Sharepoint
1.1%
1.1%
26
26
QA
QA
1.1%
1.1%
27
27
Analyze Data
Analyze Data
1.1%
1.1%
28
28
Ssis
Ssis
1%
1%
29
29
Toad
Toad
1%
1%
30
30
EDI
EDI
1%
1%
31
31
Ssrs
Ssrs
0.9%
0.9%
32
32
Management System
Management System
0.9%
0.9%
33
33
XML
XML
0.8%
0.8%
34
34
DB2
DB2
0.8%
0.8%
35
35
BI
BI
0.8%
0.8%
36
36
Suite
Suite
0.8%
0.8%
37
37
UAT
UAT
0.8%
0.8%
38
38
Python
Python
0.8%
0.8%
39
39
Monthly Reports
Monthly Reports
0.7%
0.7%
40
40
CRM
CRM
0.7%
0.7%
41
41
Html
Html
0.7%
0.7%
42
42
T-Sql
T-Sql
0.7%
0.7%
43
43
Technical Support
Technical Support
0.7%
0.7%
44
44
Data Files
Data Files
0.6%
0.6%
45
45
Source Data
Source Data
0.6%
0.6%
46
46
User Acceptance
User Acceptance
0.6%
0.6%
47
47
Spss
Spss
0.6%
0.6%
48
48
Special Projects
Special Projects
0.6%
0.6%
49
49
Data Issues
Data Issues
0.6%
0.6%
50
50
Source Systems
Source Systems
0.6%
0.6%

41,133 Data Analyst Jobs

Where do you want to work?