FIND PERSONALIZED JOBS
Sign up to Zippia and discover your career options with your personalized career search.
Sorry, we can't find that. Please try a different city or state.
APPLY NOW
Apply Now
×
FIND
PERSONALIZED JOBS

Sorry, we can't find that. Please try a different city or state.

CONTENT HAS
BEEN UNLOCKED
Close this window to view unlocked content
or
find interesting jobs in

Log In

Log In to Save

Sign Up to Save

Sign Up to Dismiss

Sign Up

SIGN UP TO UNLOCK CONTENT

or

The email and password you specified are invalid. Please, try again.

Email and password are mandatory

Forgot Password?

Don't have an account? Sign Up

reset password

Enter your email address and we will send you a link to reset your password.

Back to Log In

Log In

Log In to Save

Sign Up to Save

Sign Up to Dismiss

Sign up to save the job and get personalized job recommendations.

Sign up to dismiss the job and get personalized job recommendations.

or

The email and password you specified are invalid. Please, try again.

Email and password are mandatory

Already have an account? Log in

reset password

Enter your email address and we will send you a link to reset your password.

Back to Log In

Company Saved

Answer a few questions and view jobs at that match your preferences.

Where do you want to work?

Job Saved

See your Saved Jobs now

or

find more interesting jobs in

Job Dismissed

Find better matching jobs in

Your search has been saved!

Top 50 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.

These Are The Most Important Skills For A Data Analyst

1. Database
demand arrow
high Demand
Here's how Database is used in Data Analyst jobs:
  • Create corporate structure using new Data Portal Management databases and queries to keep research information organized using Microsoft Access.
  • Create and maintain litigation and administrative databases in accordance with client requirements and operational best practices.
  • Sole responsibility for critical maintenance of company's major production and standby databases with daily synchronization.
  • Developed and Created Logical and Physical Database Architecture using ERWIN.
  • Implemented data administration methodology with database design tools.
  • Research offender information in various databases.
  • Designed database tables to feed Promotions, Campaigns, Customer data for effective targeting and direct marketing campaigns.
  • Modify SQL search criteria in order to search databases for confidential data and document the findings of searches.
  • Implemented logging to keep track of the source files and records in database for easy comparison.
  • Worked extensively on the MS-SQL environment to run out the queries and explore the Databases.
  • Queried multiple databases to obtain driver's license information, criminal history and NCIC records.
  • Performed membership enrollment reconciliations using MS Excel, Access, and other in-house databases.
  • Ensured the integrity of data loaded into the database by visual and process inspection.
  • Provided support and maintaining Oracle Databases from 9i, 10g,11g and 12c.
  • Worked in SAP-DQM program to design databases for the client.
  • Created, designed, and updated database records.
  • Reviewed database for typing and/or syntax errors.
  • Coordinated orders received from all of the courts in the State of Louisiana and prepared for entry into our database.
  • Prepared and delivered reports to communicate any issues or changes that could impact systems or database information.
  • Maintained accuracy between United Healthcare and Blue Cross Blue Shield United States military database.

Show More

5,353 Database Jobs

No jobs at selected location

2. Pl/Sql
demand arrow
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.
  • Created PL/SQL packages to automate processing of weekly and monthly data updates in pension databases (Oracle 9i).
  • Created PL/SQL packages and Database Triggers and developed user procedures and prepared user manuals for the new programs.
  • Created PL/SQL queries, daily, then cross-referenced the GL for daily revenue reporting and data integrity.
  • Developed PL/SQL programming that included writing Views, Stored Procedures, Packages, Functions and Database Triggers.
  • Designed and developed Meter Usage database schema and PL/SQL code for time-series meter data collection.
  • Developed database scripts & PL/SQL stored procedures, functions and triggers for various analysis requirements.
  • Maintained and created SQL scripts using PL/SQL for data migration and conversion purposes;.
  • Experienced in data analysis using SQL, PL/SQL and many other queries based applications.
  • Worked extensively in data analysis by querying in SQL and generating various PL/SQL objects.
  • Write PL/SQL code to extract and insert data between SQL Server and Oracle.
  • Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
  • Involved in database development by creating Oracle PL/SQL Functions, Procedures and Collections.
  • Developed PL/SQL procedures and functions for data cleansing and formatting of data.
  • Fine-tuned for performance and incorporate changes to complex PL/SQL procedure.
  • Created data analysis tools with Oracle's 10g PL/SQL.
  • Developed extensive PL/SQL scripts to find discrepant data based on current business rules and practices defined by Tricare and contractors.
  • Build PL/Sql interfaces and Clipper programs to convert legacy data into current 16 or 32 bit system architecture.
  • Analyzed and stratified materials for the Army pre-positioned units, using PL/SQL.
  • Involved in performing the SQL backend testing Performed backend database testing by writing SQL and PL/SQL scripts to verify data integrity.

Show More

3. Procedures
demand arrow
high Demand
Here's how Procedures is used in Data Analyst jobs:
  • Processed customer and account source documents by reviewing data for deficiencies and resolving discrepancies by using standard procedures.
  • Resolved inconsistencies by using standard data entry procedures, and requested further information for documents that were incomplete.
  • Designed, implemented and automated modeling and analysis procedures on existing and experimentally created data.
  • Collaborated with Applications Development team to successfully design T-SQL procedures.
  • Assisted senior management with writing and implementing departmental procedures.
  • Optimized queries, stored procedures, and reports to increase efficiency and tuned query performance by 30%.
  • Regarded as a qualified resource for OSHA law guidelines, investigative procedures and in-depth safety protocols.
  • Created stored procedures, scheduled jobs, database mails, and monitored the automated processes.
  • Designed and implemented tables, functions, stored procedures and triggers using Microsoft SQL Server.
  • Developed complex SQL queries, stored procedures & programs for batch processing/ reports generation.
  • Created Stored Procedures, Tables, Functions, and Triggers in SQL Server 2008.
  • Audited current Awards standards, documentation, and procedures to ensure compliance with policies.
  • Created, modified and maintained reporting procedures with SQL Server Enterprise Manager.
  • Audit bank reconciliation, daily A/P audit, prepared employee procedures.
  • Create new processes and procedures based on Customer requirements.
  • Comply with HIPPA policy and standard SHP policies and procedures
  • Create multiple procedures in SQL Server.
  • Recommend methods and changes to improving system and procedures in data management Training new hires on accurate/timely reporting skills.
  • Created procedures to streamline the claims adjudication audit process for specific negotiated provider pricing agreements and Medicare.
  • KEY ACCOMPLISHMENTS: Establish organizational Standard Operating Procedures and best practices to ensure optimal performance standards.

Show More

1,382 Procedures Jobs

No jobs at selected location

4. Data Analysis
demand arrow
high Demand
Here's how Data Analysis is used in Data Analyst jobs:
  • Mentored over ten internal and external stakeholders on the fundamentals of data analysis and the proprietary counterfeit software deployed.
  • Participated in decisions regarding study design, data collection, data analysis, and methodology.
  • Provided support to marketing groups and upper management through data analysis and project management.
  • Conducted logical data analysis and data modeling JAD sessions, documented data-related standards.
  • Conducted user interviews and data analysis review meetings.
  • Performed data modeling and data analysis as required.
  • Provide data analysis in support of the performance improvement program through data collection, analysis, reporting, and ongoing consultation.
  • Performed Detailed Data Analysis (DDA), Data Quality Analysis (DQA) and Data Profiling on source data.
  • Extract the data from database and provide data analysis using SQL to the business user based on the requirements.
  • Worked closely with all levels of company management to ascertain their reporting and data analysis needs.
  • Managed customer-facing activities that focused on data analysis for the proprietary software employed (SAAS).
  • Create spread sheets and graphs to retrieve data analysis on approved/rejected contracts and rejection reasons.
  • Worked on data analysis, data profiling, data modeling, data mapping and testing.
  • Perform exploratory data analysis and build visualizations in R programming to present the results.
  • Performed close data analysis and conversion of the documents into different format.
  • Executed SQL queries to perform the data analysis.
  • Helped to setup and audit the new system and data analysis, from Horizon to JD Edwards's system.
  • Write queries and views, perform predictive data analysis and generate visual dashboards & monitor KPIs regularly.
  • Provided assistance for quantitative data analysis with health care, biometric and survey data.
  • Company closed) Responsible for database management, maintenance, performance tuning and data analysis, processing, and testing.

Show More

2,914 Data Analysis Jobs

No jobs at selected location

5. Financial Statements
demand arrow
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.
  • Analyzed historical financial statements in order to calculate government regulated subsidies given for developing future telecommunication infrastructures in rural areas.
  • Perform industry classification for revenue streams and business segments of public companies as researched through financial statements.
  • Evaluated corporations financial statements to determine the companies corporate rating.
  • Facilitate the conversion of foreign financial statements before processing.
  • Assisted Controller in preparation of monthly Financial Statements.
  • Prepared financial statements and staff performance grading.
  • Created custom financial statements in accounting software.
  • Headed the integration of municipal fundamentals with our equity product, resulting in more efficient processing of issuers' financial statements.
  • Created financial analysis reports of commercial real estate, borrower's financial statements, lease reviews and market research.
  • Advised clients on their allocation of expenses and investments on their financial statements to maximize FCC subsidies.
  • Inserted US-GAAP and customer financial data tags in Primary Financial Statements and notes for legal reporting.
  • Reviewed and consolidated month-end financial statements for the West regions having a budget of $4.6M.
  • Reviewed, analyzed and reported financial statements, billing and sales forecast to President.
  • Conduct data audits, analyze and review for accuracy for financial statements.
  • Worked using SNL to create custom reports that compared company financial statements.
  • Review, entry and mapping of audited financial statements into the system
  • Produce financial statements; P&L, balance sheets, and cash flow.
  • Publish financial statements and various supplementary data sets on the Bloomberg Terminal, including segmentation data and industry specific figures.
  • Contracted to analyze audited financial statements and update the Bloomberg Terminal for potential investors.

Show More

181 Financial Statements Jobs

No jobs at selected location

Job type you want
Full Time
Part Time
Internship
Temporary
6. Data Entry
demand arrow
high Demand
Here's how Data Entry is used in Data Analyst jobs:
  • Prepared source data for computer entry by compiling and sorting information and establishing entry priorities, maintained data entry requirements.
  • Performed data entry daily and maintained various agency specific computer databases.
  • Performed data entry involving alphanumeric coding.
  • General office duties including answering phones, email, faxing failing and data entry of information.
  • Performed clerical duties as directed, data entry, 10-key by touch and DOS commands.
  • Managed and trained a team of 4 for data entry operations, overseeing day-to-day activities.
  • Performed Data Entry on individual's personal investment accounts and funds with Capital Group.
  • Locate and correct data entry errors or report them to supervisors or managers.
  • Locate and correct data entry errors, and report them on database.
  • Identified training & support as needed to strengthen court docketing/data entry standards.
  • Worked as a leader in a team environment overseeing data entry interns.
  • Utilize various Microsoft programs to complete data entry tasks.
  • Performed data entry for Hospital surveys in Microsoft Access.
  • Prioritized and batched materials for data entry input.
  • Locate and correct the data entry errors.
  • Cross check data entry of other employees.
  • Team Leader for Data Entry development.
  • Managed and analyzed survey data, prepared survey forms, and organized data entry processes with the Teleform scanning program.
  • Improved workflows through automation and macros Data entry and validation checks.
  • Coordinated payroll Data entry Billing Filing Service Referrals for programs

Show More

181 Data Entry Jobs

No jobs at selected location

7. SQL
demand arrow
high Demand
Here's how SQL is used in Data Analyst jobs:
  • Developed and maintained applications using extensive knowledge of Microsoft SQL Server and Visual Basic for automation of data import/export processes.
  • Created multiple programs and algorithms to ensure correct data transfer and communications between Oracle databases, MYSQL servers and ERP systems.
  • Involved in migration of various objects like, stored procedures, tables, views from various data source to SQL Server.
  • Worked on data development, updates, collection, and usage of GIS data using SQL server management.
  • Reviewed and analyzed data, and generated reports using a variety of tools including SQL and GeoAccess software.
  • Clean and format data via Excel and Access to import into SQL database.
  • Analyzed data from various sources like Oracle, flat files and SQL Server.
  • Maintained and wrote MySQL scripts to provide automated reports to various project managers.
  • Run SQL queries and other reports to validate data and troubleshoot issues.
  • Created and adapted existing SQL queries to perform data transformation for pricing.
  • Manipulated, cleaned and processed data using Excel, and SQL.
  • Developed and modified Plateau Report Designer reports using SQL queries.
  • Experienced with MS Access and SQL Server Reporting Services.
  • Used MySQL to import and export data.
  • Create special request reports at the request of the client using SQL Server 2008, MS Excel.
  • Use Microsoft SQL to run queries, build queries, and export data.
  • Tested files via ad hoc SQL and Hyperion for possible load failure conditions before files were loaded into FACETS.
  • Conducted performance tuning of complex SQL queries and stored procedures by using SQL Profiler and index tuning wizard.
  • Compared data between source and target dB using AQT and sql statements.
  • Processed & designed relational schema for database (sql and nosql).

Show More

5,965 SQL Jobs

No jobs at selected location

8. ETL
demand arrow
high Demand
Here's how ETL is used in Data Analyst jobs:
  • Collaborate closely with ETL developers on technical specification for integration component development.
  • Train and assist Jr. Analyst on updating, validating data in information in SAP and catering system using the ETL process.
  • Automated an ETL job to facilitate daily, weekly and monthly loading of material prices, quantities to the warehouse.
  • Used import export/ DTS and ETL functions to load data into SQL tables from legacy data sources.
  • Created ETL packages to load data to centralized SQL server database from diversified data sources.
  • Develop data integration components and collaborate with ETL developers on ETL map target to source.
  • Experienced in data integration, metadata management, ETL, data modeling tool sets.
  • Designed audit tables for ETL and the Error handling process design for bureau submission.
  • Worked closely with IT team on enhancing ETL processes and data cleansing initiatives.
  • Automated daily ETL duties, saving an employee 3 hours per day.
  • Worked with OLAP tools such as ETL, Data warehousing and Modeling.
  • Worked with ETL group for understating mappings for dimensions and facts.
  • Use SSIS to run ETL project where total data size is a little over 1TB.
  • Extract, Transform and Load (ETL).
  • Created SSIS ETL packages using SQL Server 2012.
  • Load and Extract data with ETL tools.
  • Developed Data Model, ETL and business objects reports for Customer, Material and Contract order for Sabre hospitality solutions.
  • Developed and implemented automated ETL processes which feeds into unit-wide ad hoc reporting and trend analysis.
  • Loaded the dataset into Hive for ETL (Extract, Transfer and Load) operation.
  • Contract position) Worked on data integration ETL project.

Show More

611 ETL Jobs

No jobs at selected location

9. Data Quality
demand arrow
high Demand
Here's how Data Quality is used in Data Analyst jobs:
  • Partner with distributor representatives to assess and correct data quality issues related to product pricing and promotions.
  • Conducted assessment to ensure data quality and completeness with validation techniques.
  • Evaluate and monitor data quality including exception and error handling.
  • Develop methods to monitor and automatically correct data quality issues.
  • Prepared and/or update performance tracking documentation and review data quality.
  • Prepared data quality criteria and governance for Data Warehousing Application.
  • Documented data quality information in the metadata repository.
  • Conducted data validation testing to ensure data quality.
  • Worked 1:1 and with small groups of data quality staff in KP hospitals to gather data, improve gathering process.
  • Resolved the data related issues such as: assessing data quality, data consolidation, evaluating existing data sources.
  • Worked closely with other teams in MS to identify data quality issue, propose and implement solutions.
  • Profile the Data from the current Source systems and identify Data Quality rules for cleansing and standardization.
  • Worked on data quality, data profiling, data warehousing, data modeling and ETL scripts.
  • Coordinated data quality checks on pricing of food and beverage items and report on the results.
  • Analyzed potential data quality issues, validate issues and determines the root cause and potential.
  • Verify new deployments and contribute to evolution of various tools to improve data quality.
  • Analyze medical records and generate queries for clinical staff to ensure data quality.
  • Identified and solved data quality problems using Excel, Access, and SQL.
  • Develop data quality strategy for the business unit.
  • Coordinated product development with R&D, Sales, Data, and Business teams for enhanced data quality and analytics.

Show More

1,091 Data Quality Jobs

No jobs at selected location

10. SAS
demand arrow
high Demand
Here's how SAS is used in Data Analyst jobs:
  • Managed projects and oversaw data management and analysis of internal air quality projects using SAS software.
  • Documented SAS programs, created and maintained organized project directories according to strict standard operating procedures.
  • Imported Data from relational database into SAS files per detailed specifications.
  • Use SAS to determine the adherence and effectiveness of the intervention at various time-points during the study period.
  • Developed efficient, well-documented, readily comprehensible and modifiable SAS code using SAS/ Base and SAS/ Macro facility.
  • Coordinate with SAS analytic and BI tool reporting teams to check their reports with data reliable or not.
  • Import R&D data to Excel, cleaned data, and performed statistical analysis using SAS/JMP.
  • Pull data from SAS and process information in Excel for further analysis, reporting and communication.
  • Mastered SAS functions and macros for manipulating data to produce descriptive statistics and reports.
  • Report generation using many SAS procedural statements, SAS/MACROS, and data null steps.
  • Read both worksheets into SAS data sets and compared the data for any discrepancies.
  • Used SAS to create a time series ARIMA model to forecast Euro/Dollar exchange rates
  • Developed complex SAS Macros to simplify SAS code and effectively reduce coding time.
  • Worked on resolving production issues, debugging procedures for existing SAS code.
  • Experienced with extensive debugging of SAS codes to identify the issue.
  • Involved in performing Audits and recovery operations of SSAS objects.
  • Generated generalized, effective and efficient SAS code.
  • Created SAS code to generate cleaned integrated complex Medicare analytic datasets.
  • Worked with relational databases such as Oracle, Sql server, MS-Access and SAS storage server SPDS.
  • Automated the creation of monthly transactional processed Source data using SAS, thus reducing the pre-processing time by 2 hours.

Show More

1,205 SAS Jobs

No jobs at selected location

11. Data Warehouse
demand arrow
high Demand
Here's how Data Warehouse is used in Data Analyst jobs:
  • Created automated reports on inventory defect and associate behavioral trends using Amazon's Data Warehouse and proprietary ETL manager.
  • Gathered and consolidated data from diverse data sources into a uniform Business Intelligence SQL Server data warehouse.
  • Developed dimensional model for Data Warehouse/OLAP applications by identifying required facts and dimensions.
  • Used Erwin for relational database and dimensional data warehouse designs.
  • Participated in testing of procedures and data, utilizing PL/SQL, to ensure integrity and quality of data in data warehouse.
  • Create plans, test files, and scripts for data warehouse testing, ranging from unit to integration testing.
  • Develop Mapping of data lineage for each attribute stored in different data warehouses and across several source systems.
  • Involved in initial study, design of Data Warehouse for better Reporting for Inventory and external Systems.
  • Extracted data from SQL Server and DB2 using SSIS packages to load it into data warehouse repository.
  • Transferred Data to data warehouse and exported files in various formats based on requirements using SSIS Packages.
  • Experience defining enterprise data location architectures for ODS, Data mart, and Data Warehouse data.
  • Accelerate data transition using Access (SQL), Excel, data warehouse, etc.
  • Develop data warehouse process models, including sourcing, loading, transformation, and extraction.
  • Involved in Tabular Data warehouse and DAX operations for SSAS 2012 and 2008 OLAP databases.
  • Designed, implemented, and maintained internal data warehouse and data mart.
  • Involved as a developer for the commercial business group data warehouse.
  • Worked on exception reporting and data fixes in the data warehouse.
  • Used data warehouse to generate weekly freight audits.
  • Reviewed and recommended database modifications Analyzed and rectified data in source systems and Financial Data Warehouse databases.
  • Assisted client with mapping data elements; defined transformation rules from existing Healthcare source systems to Enterprise Data Warehouse.

Show More

1,131 Data Warehouse Jobs

No jobs at selected location

12. Test Cases
demand arrow
high Demand
Here's how Test Cases is used in Data Analyst jobs:
  • Supplied production support including Implemented user acceptance testing with a focus on documenting defects and executing test cases.
  • Analyzed and verified critical algorithms with system experts Developed test plans, test cases to validate the adherence to system requirements.
  • 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.
  • Developed test plans and test cases for QA Unit Testing, System Testing and Enterprise testing.
  • Involved in generating Test cases for property and casualty Insurances for Different Levels of Business.
  • Skilled in Analysis, Design and Developing test cases for SQL objects verification and testing.
  • Created the templates for test plan, test cases, process flow diagrams etc.
  • Experience in all types of Test Documentation: Test Scenarios, Test Cases etc.
  • Created test cases for carrying out unit testing and part of functional testing.
  • Created Test Plan and Test Lab in QC and upload Test cases.
  • Created test cases; performed software testing and researched errors for documentation.
  • Executed multiple test cases for client data and account opening systems.
  • Experience in Execution of Test Cases and Preparation of Test Data.
  • Reviewed test plans and test cases for the applications.
  • Executed the developed Test Cases and Test Plans.
  • Exported test cases into Mercury Quality Center.
  • Assist an agile team in creating test cases and unit tests for both a Windows and Linux enviroments.
  • Produced Test Cases and involved in Regression testing for various iDCT tools and SRSA WebPages.
  • Write test cases in QC .Test Plan and execute in Test Lab.

Show More

134 Test Cases Jobs

No jobs at selected location

13. Data Management
demand arrow
high Demand
Here's how Data Management is used in Data Analyst jobs:
  • Performed Data Management duties; acquired validated, processed, stored and protected data for reliable accessibility to data users.
  • Analyze current data management procedures, including reporting methods, and make recommendations for improvements.
  • Provided Meter Data Management and applications development expertise in the Electric Energy Deregulation industry.
  • Updated and performed provider data management as needed based on plan and contract specifications.
  • Utilized data management techniques to improve data quality in different relational database systems.
  • Provided Data Management support to assigned programs in accordance with program requirements.
  • Assisted the Data Management Director with day-to-day operations of data management.
  • Document report generation, data processing and data management procedures.
  • Worked with Master Data Management architects to develop data models.
  • Provide administrative, technical and data management support to site executives, engineers, and quality control staff.
  • Worked with the global technical data community and assist with implementing the global data management strategy.
  • Conduct Phase II and Phase III clinical trial programming, data management, quality control.
  • Participated in integration of MDM (Master Data Management) Hub and data warehouses.
  • Developed skills using Word, Excel, office machinery and data management.
  • Perform data management, data entry, data reporting and analysis.
  • Maintained Data Management metrics tracking changes to the CSAP document.
  • Performed Data Management duties; created and submitted deliverables in accordance with contract requirements.
  • Performed development testing & evaluation and data management services for the Military Healthcare System.
  • Performed ad hoc querying, reporting and data management.
  • Analyzed and summarized client data - Presented data to program managers - Made recommendations for future data management

Show More

1,962 Data Management Jobs

No jobs at selected location

14. Business Requirements
demand arrow
high Demand
Here's how Business Requirements is used in Data Analyst jobs:
  • Identified and implemented operational improvements, developed business requirements when system solutions are required, and performed special projects as required.
  • Created Business Requirements and converted them into detailed Use Cases, Report Specifications and Non Functional Requirements.
  • Gathered stakeholder and subject-matter insights and business requirements to ensure data meet business needs.
  • Liaised with stakeholders to extract business requirements and produced exceptional reports during documentation.
  • Conducted meetings/interviews and JAD sessions with stakeholders to collect business requirements.
  • Prepared Test Plan from the Business Requirements and Functional Specification.
  • Developed a Conceptual model using Erwin based on business requirements.
  • Captured business requirements via Fit-Gap Analysis meetings with client to ensure all nuances of business processes are well integrated into system.
  • Facilitated (JAD) Joint Application Development sessions to resolve issues relating to difference between business requirements and technical design.
  • Liaised with IT team on projects and initiatives to ensure proposed solutions met the business requirements dictated by senior management.
  • Represented the business requirements in various alternative views such as analysis models, process flow diagrams and user stories.
  • Gathered business requirements from clients to write use cases for software and project development.
  • Work closely with departments and groups of users to define business requirements and processes.
  • Identified the key facts and dimensions necessary to support the business requirements.
  • Utilized Rational ReqPro as a user to analyze the business requirements.
  • Analyzed old system and established business requirements/designed workflow processes to overhaul the old database.
  • Gathered business Requirements, analyze data/workflows.
  • Analyze business requirements and liaise between the business and the technical sectors to translate business requirements to technical language.
  • Develop and lead data analysis training sessions Defined business rules and business requirements for the system.
  • Analyzed client's business requirements and processes through document analysis, interviews, workshops and workflow analysis.

Show More

1,556 Business Requirements Jobs

No jobs at selected location

15. Windows XP
demand arrow
average 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.
  • Awarded Teacher of the Month - August 2012 and April 2013 Environment: SQL, SPSS, EXCEL, Windows XP
  • Contributed to the development of Standard Operating Procedures (SOPs) Environment: SAS 9, Windows XP.

Show More

16. Unix
demand arrow
average Demand
Here's how Unix is used in Data Analyst jobs:
  • Provided support and maintenance for production applications, including UNIX based applications.
  • Transferred non-error files into search system database, using FTP and checked in UNIX to see if the files transferred successfully.
  • Developed BASH scripts to test the health and integrity of various UNIX and LINUX computer servers.
  • Developed checklist and a proposal to Clean up Database process in a Hudson/UNIX environment.
  • Worked with UNIX shell scripts for scheduling and running the required jobs.
  • Analyzed credit account data using SAS on Unix and PC platforms.
  • Experience in creating UNIX scripts for file transfer and file manipulation.
  • Involved in loading data from UNIX file system to HDFS.
  • Created Unix Shell Scripts for automating the execution process.
  • Developed UNIX shell scripts to run the batch jobs.
  • Assisted users with minor UNIX systems and PC problems.
  • Converted UNIX Scripting into SQL Stored Procedures.
  • Experience in UNIX Shell scripting.
  • cluster computing monitoring as well as hardware maintenance for Linux/Unix server and client workstations and various applications.
  • Key Projects and Accomplishments Configured and provided support for UNIX servers and backup systems.
  • Involved in migrating the ETL, Teradata and UNIX objects to different environments.
  • Performed backend testing using SQL queries and analyzed the server performance on UNIX.
  • Used SQL queries on Unix by logging into Netezza.
  • Created &Ranshellscripts in UNIX environment.
  • Created Unix Shell Scripts for Data Centric applications Developed shell scripts for scheduling the jobs.

Show More

202 Unix Jobs

No jobs at selected location

17. Business Process Models
demand arrow
average Demand
Here's how Business Process Models is used in Data Analyst jobs:
  • Involved in converting the business requirements into functional requirements and also created business process models from the requirement specs.
  • Developed Business Process models and logical Entity-Relationship data models.
  • Prepared Business Process Models that includes modeling of all the activities of business from conceptual to procedural level.
  • Designed business process models, BRD & FSD requirement documents by working closely with business partners.
  • Authored Data Flow diagrams, Sequence diagrams and Business Process models with special detail to Sub-Processes.
  • Designed the conceptual data and business process models.
  • Experience creating Business Process Models.
  • Develop and maintain process improvement projects within PL departments company wide - Developing business process models.
  • Created As-Is Business Process Models using MS Visio.

Show More

45 Business Process Models Jobs

No jobs at selected location

18. Audit
demand arrow
average Demand
Here's how Audit is used in Data Analyst jobs:
  • Report and Audit policies and procedures of multiple business and IT departments to increase service availability for highly available applications.
  • Developed database queries and reports in support of internal audit process for senior management reporting/forecasting.
  • Created and generated targeted reports which contributed insightful audit data facilitating a successful annual audit.
  • Identified data anomalies and recommended appropriate strategies for auditing, database construction and reporting.
  • Audited the accuracy of customer invoices to facilitate the asset decommissioning process.
  • Gathered paper records for reconciliation against electronic data for drug audit reports, which follow the BOP process.
  • Assisted external auditors to ensure the audit functions were executed on a timely and efficient basis.
  • Performed data forensics using SQL-based queries to audit account assignments between LCS and SMB teams.
  • Analyzed and performed audits on internal controls adhering to company's standards.
  • Extract data using SQL to provide information to legal and audit investigations.
  • Participated in wide variety of IT and auditing related work.
  • Audited and prepared reports; regarding co-worker's imaging performance.
  • Audited and mailed the weekly reports from collectors.
  • Performed weekly audits of Prism Instrument logs.
  • Conducted audits and documents findings.
  • Audit records for errors and missing pieces of data into TRAX system.. Organize and index selected documentation of aircraft maintenance activities.
  • Format bulk data retrieved from SAP in excel Liaised with auditors on documents needed for external audit.
  • Audit customer accounts ad confirming addresses and licenses are current and accurate Oracle
  • Worked with ICD-9, CPT and HCPCS Codes Audited Medical Records
  • Verify and organize data automation *Audit and amend incorrect data *Assist tax document automation

Show More

1,394 Audit Jobs

No jobs at selected location

19. Data Collection
demand arrow
average Demand
Here's how Data Collection is used in Data Analyst jobs:
  • Determined more efficient data collection procedures and ensured that all data gathered was entered per corporate standards.
  • Calculate reliability coefficients and summarize reliability data of various direct observation data collection systems.
  • Assisted with retirement plan summary statement data collection and filing maintenance.
  • Identified problematic areas of data collection and recommend solutions
  • Reviewed medical records and coordinated data collection.
  • Developed Wellness data collection and reporting.
  • Performed claims data search and analysis, data collection and grouping, data checking, data validation, and data clean-up.
  • Point of Contact for field based user requests and help desk inquiries surrounding data collection and associated business processes.
  • Entered data into designated database for UDS reporting, federal grants, and other sources of data collection.
  • Supplied GIS skills, market analysis, data collection, demographic and socioeconomic analysis support to clients.
  • Collaborate with IT team to update, test, and troubleshoot online web portal for data collection.
  • Created data collection excel templates for other departments and trained staff on the use of templates.
  • Assist the Director of Revenue Cycle Operations with the process improvement of data collection and validation.
  • Define the research and data collection, filtration and compiling procedures for the staff members.
  • Assisted in the orientation of new staff/students to department procedures and data collection procedures.
  • Maintained a QPI database for data collection and reporting of Quality supplier performance.
  • Implement procedures for data collection from patient charts and medical records.
  • Handled daily data collection duties and prepared related reports.
  • Processed data collection to ensure proper quality of data.
  • Designed and programmed complex surveys for data collection.

Show More

455 Data Collection Jobs

No jobs at selected location

20. Data Integrity
demand arrow
average Demand
Here's how Data Integrity is used in Data Analyst jobs:
  • Maintain data integrity across systems through routine verification, integrity checks and cleansing.
  • Entrusted with mission critical operational duties from ensuring data integrity to database management.
  • Managed data integrity through monitoring database fields and system records.
  • Developed triggers and stored procedures designed to improve data integrity.
  • Monitor the technical performance and data integrity of daily aggregation/validation.
  • Completed large database cleanup projects to insure data integrity.
  • Maintained security and data integrity of the database.
  • Promoted data integrity through the development of spreadsheets and online databases, and ensured compliance with quality standards and reporting regulations.
  • Assist with the data migration process by analyzing and correcting various data integrity issues and ensuring uniformity across all data fields.
  • Write queries in Access to identify data discrepancies, investigate break in the pattern to improve data integrity.
  • Work collaboratively with team members, business units, and management to resolve data and ensure data integrity.
  • Acted as database administrator for MS ACCESS, MYSQL and SQL Sever databases ensuring data integrity.
  • Ensured 95% data integrity between systems throughout the change cycle for over 6000 parts.
  • Performed Quality Check (QA) on data entry to assure data integrity.
  • Create and run data integrity checks and undertake the appropriate follow up action.
  • Created database tables in Access and enforced data integrity with constraints.
  • Tested and verified database table content and data integrity.
  • Maintained data integrity of client and advertiser names list.
  • Key Contributions: Ensured data integrity in the Awards and Sub Awards management databases.
  • Maintained data integrity between 3 different data platforms (Salesforce, Department of Education, iMentor platform).

Show More

235 Data Integrity Jobs

No jobs at selected location

21. Customer Service
demand arrow
average Demand
Here's how Customer Service is used in Data Analyst jobs:
  • 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.
  • Elevated all personnel performance and related concerns to the manager of customer service immediately.
  • Managed all customer service and sales administration functions.
  • Possess strong communication skills and provides excellent customer service, while interacting with all Program stakeholders, internal and external customers.
  • Performed technical customer service duties consisting of responding to 50 to 60 incoming Volvo dealer phone calls per day.
  • Provided customer service for clients in setting up data transmissions using FTP / PGP/ HTTP protocols and UNIX scripting.
  • Provide guidance to Customer Service Representatives and Team Leads based on audit results and discrepancies in each file.
  • Answered Customer Service inquiries regarding members to ensure that the member was placed in the correct health plan.
  • Provided customer service to over 100 callers on a weekly basis by handling incoming and outgoing calls.
  • Researched and resolved employee issues entered by the Customer Service Department through a computerized trouble ticket system.
  • Perform customer service to clients and client teams, credit services and other business partners.
  • Received Eagle Award for providing stellar customer service in April 2009.
  • Provided customer service as needed to consumers and employees.
  • Provide excellent customer service to the Queens community.
  • Act as an IT liaison between Sales, Customer Service and the client.
  • Work with customer service to perform ad-hoc analysis for specific questions from clients.
  • Provided internal customer service to various departments throughout the hospital by resolving ad hoc issues.
  • Awarded "Employee of the Month" five times Responsible for customer service, filing and bookkeeping.
  • Implemented a new database for the product customer service line Skills Used Database management Customer service Organization Time management

Show More

153 Customer Service Jobs

No jobs at selected location

22. Pivot Tables
demand arrow
average Demand
Here's how Pivot Tables is used in Data Analyst jobs:
  • Created Excel pivot tables, which showed a table of users that, have not performed scanning of journal voucher documents.
  • Created and manipulated Excel pivot tables and the ability to build macros to integrate data into excel workbooks.
  • Filtered unknown and distinct county records, sorted by mineral appraisals and reported by Microsoft Excel pivot tables.
  • Analyzed large sets of data using pivot tables and advanced formulas (VLOOKUP, SUMIF, ext.)
  • Performed data entry for new specification system using advanced Excel skills (v-look-ups, pivot tables).
  • Generate reports using various Excel functions such as Pivot tables, charts, formulas, and filtration.
  • Experience using data cleansing techniques, Excel pivot tables, formulas, and charts.
  • Produce monthly production performance pivot tables for cash applications team using revenue cycle dashboard.
  • Created pivot tables for Upper Management to review the Data according to their requirement.
  • Balanced & prepared monthly financial packages, using Excel formulas and pivot tables.
  • Used advanced Excel functions to generate spreadsheets and pivot tables.
  • Managed, updated and manipulated report with the use advanced Excel functions also, including Pivot Tables and V-Lookups.
  • Created ad hoc reports using Charts, Pivot Tables, and Functions in MS Excel and Access.
  • Used pivot tables to analyze delivery performance across eight ISPs to assist in maximizing click-through revenue.
  • Created Aging report for Quantity per pallets using pivot tables and vlookup functions.
  • Created Excel reports including extensive use of Pivot Tables on large datasets.
  • Extracted data from Teradata and Oracle and created pivot tables in Excel.
  • Identify errors and duplications in the data using Excel pivot tables and MSSales tool.
  • Used Microsoft Excel functions, formulas, pivot tables , vlookups , filters etc.
  • Promoted in March, 2015 Skills Used Advanced Excel, SQL Studio 2010, Pivot Tables, Data Mining, Photoshop.

Show More

1,295 Pivot Tables Jobs

No jobs at selected location

23. Powerpoint
demand arrow
average Demand
Here's how Powerpoint is used in Data Analyst jobs:
  • Managed multiple projects simultaneously and developed Excel tables and PowerPoint presentations from patient-level data to answer client specific questions.
  • Processed the Group's PowerPoint quarterly and annual presentations and proposal preparations and distribution.
  • Created PowerPoint presentations and corporate communication documents for the Vice President, Procurement.
  • Presented results as PowerPoint presentations to senior management.
  • Created PowerPoint presentations for monthly budget meetings.
  • Reported the final outcome using PowerPoint and Info-graphics to be presented to the Dean's of 9 schools within the university.
  • General Information Advanced Knowledge of MS Project, MS Access, Outlook, Excel, MS Word and MS PowerPoint.
  • Created aircraft status reports and PowerPoint presentations in a properly formatted output to meet management needs and meet deadlines.
  • Presented data findings in graphs, charts, pivot tables, pivot charts and PowerPoint presentations.
  • Used Excel and PowerPoint daily to report on extensive sets of data on products to clients.
  • Trained employees on both PowerPoint and Excel training via on-line and live sessions.
  • Created Excel charts, pivot tables and PowerPoint for presentation to management.
  • Created PowerPoint presentations of graphic design for numerous teams.
  • Generate reports, documents and PowerPoint presentations as needed.
  • Collected data was utilized to improve NASA recruitment levels of newly immigrant minority groups for STEM Utilized Excel and PowerPoint software.
  • Register for tradeshows, prepare Abstracts, and PowerPoint presentations ensuring company branding and copyright are up to date.
  • Arrange detailed travel plans and itineraries, compile PowerPoint presentations for travel and internal meetings.
  • Produced technical reports, ad-hoc reports, and PowerPoint presentations.
  • Create profiles, charting, and decision-making to customer and management in PowerPoint, Excel, and .pdf documentation.
  • Presented Matlab produced figures in Powerpoint emphasizing how to better organize mouse experimental data.

Show More

421 Powerpoint Jobs

No jobs at selected location

24. Teradata
demand arrow
average Demand
Here's how Teradata is used in Data Analyst jobs:
  • Created Teradata specific physical data models which included primary indexes, secondary indexes and joined indexes.
  • Performed GAP analysis with Teradata MDM and Drive (SQL) data models to get clear understanding of requirements.
  • Based on the updates in the Teradata OLAP system various marketing campaigns are decided by the business analysts.
  • Exploited power of Teradata to solve complex business problems by data analysis on a large set of data.
  • Used Teradata OLAP functions like random, qualifies, top n, rank, sample and random.
  • Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.
  • Used SAS to perform analysis on the data by comparing data from both TERADATA and ORACLE.
  • Involved in modifying Teradata stored procedures and performance tuning of various tables.
  • Achieved 90th percentile, which was currently not available in Teradata.
  • Involved in extensive Analysis on the Teradata and Oracle Systems.
  • Conducted data analysis writing SQL queries against Teradata tables.
  • Worked with Teradata DBA's in optimizing the queries.
  • Generated reports /scripts using Teradata BTEQ.
  • Provided architecture/development for initial load programs to migrate production databases from Oracle data marts to Teradata datawarehouse.
  • Used Teradata OLAP functions like random, qualifies, top n, custom, sample and random Teradata SQL performance tuning.
  • Created logical and physical data models on Teradata R12 and Teradata R13 environments using Erwin data modeler.
  • Developed reports using the Teradata advanced techniques like rank, row number and etc.
  • Worked on Teradata Queryman to validate the data in warehouse for sanity check.
  • Created and modified logical and physical data models in ERwin for Teradata platform.
  • Extracted and manipulated data from Teradata DB using Teradata sql assistant.

Show More

124 Teradata Jobs

No jobs at selected location

25. Visio
demand arrow
average Demand
Here's how Visio is used in Data Analyst jobs:
  • Participated in critical review and revision of existing systems for updates and enhancements.
  • Enhanced and documented Hyperion production system queries for reporting to company divisions.
  • Reviewed and recommended revisions to market collateral materials.
  • Achieved two outstanding and successful division office inspections.
  • Managed and maintain automated monthly accounts receivable process for all existing and new clients of the Health Enhancement Division.
  • Reported anomalies regarding kWh usage on hourly, daily and weekly schedules, cost analysis against division budgets.
  • Verify both account and network provisioning to determine if an issue is network or device related.
  • Created, documented, and implemented division wide data mart and data cube check process.
  • Process Welcome Season provisioning requests and maintain Welcome Season data in workbook.
  • Collect department data to prepare Vision Support Plan presentations.
  • Assist with special Division activities, projects and events.
  • Team leader for the truck engine systems division.
  • Worked under minimal supervision on a daily basis.
  • Provide Technical Support for the Division
  • Audited bank statements to determine whether or not provisional credits should be granted to bank accounts of those who filed claims.
  • Managed database specs for 1,000 plus skus; set up new codes across multiple divisions, granted user access.
  • Worked on designing business rules for MRR Process Flow to Clinical Operations Department for training purposes using MS Visio.
  • Used UML and Visio for creating Activity diagrams, Sequence Diagrams.
  • Created business process flow with Visio.
  • Create swim lane diagrams in MS Visio

Show More

880 Visio Jobs

No jobs at selected location

26. Informatica
demand arrow
average Demand
Here's how Informatica is used in Data Analyst jobs:
  • Developed InformaticaSCD Type-I, Type-II and Type III mappings and tuned them for better performance.
  • Experience testing data conversions and migrations in cross platform scenarios Informatica Power Center.
  • Worked extensively on tuning Informatica code by various techniques.
  • Created Transformations and Mappings by using Informatica Designer.
  • Created all reporting utilizing Informatica PowerAnalyzer.
  • Used SQL Developer, DB Visualizer, and Informatica to extract, transform, and load (ETL) data.
  • Project was executed in phases building up from extraction, computation logic, dimension models and populating data using Informatica.
  • Debug the Informatica mappings and validate the data in the target tables once it is loaded with mappings.
  • Involved in requirements analysis by interacting with analysts for the creation of Data marts using Informatica.
  • Developed SQL scripts to validate the data loaded into warehouse and Data Mart tables using Informatica.
  • Prepared Test Cases and Test Plans for the mappings developed through the ETL Informatica tool.
  • Use of data transformation tools such as DTS, SSIS, Informatica or Data Stage.
  • Experience in monitoring Informatica sessions and performance tuning of mapping and sessions.
  • Designed and developed Informatica mappings for data loads and data cleansing.
  • Involved in Unit testing and integration testing of Informatica mappings.
  • Created Registration, DataMap, configured Real-Time mapping and workflows for real-time data processing using CDC option of Informatica PowerExchange.
  • Create ETLs to automate database updates and produce information to expedite reporting, applying knowledge in Microsoft SSIS and Informatica.
  • Developed Informatica Objects - Mappings, sessions, Workflows based on the design documents.
  • Developed mappings and workflows in Informatica to extract data files for third party vendors.
  • Performed Logical & Physical Data Modeling and delivering Normalized, De-Normalized & Dimensional schemas Delivered Source-to-target mappings and developed Informatica mappings/mapplets.

Show More

283 Informatica Jobs

No jobs at selected location

27. R
demand arrow
average Demand
Here's how R is used in Data Analyst jobs:
  • 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.
  • Designated IT Liaison coordinating department requests, providing specialized reporting, and technical consultation.
  • Analyzed requirements and demonstrate problem understanding, model data management and design data.
  • Discover insights and opportunities using statistical, data mining and visualization techniques.
  • Create, prepare weekly, monthly, quarterly and annual departmental reports using MS Access, Excel and other applications.
  • Managed a broad scope of data services including processing payment requests, financial reporting, and information queries.
  • Update the enrollment processing system, managed care system based upon vendor files, reports and emails.
  • Translated data needs into including models, conceptual design diagrams, user stories to support iterations.
  • Worked with the business product owners and Data Architects to understand new functionality of EMR.
  • Created a relational model and dimensional model for online services such Clinical EMR records.
  • Provide cost effective solutions to issues and problems related to HIP VIP Medicare plan.
  • Identify anomalies and inconsistencies as a result of the above reconciliation process.
  • Handle inquiries from retirees, employers, organizers and internal staff.
  • Perform quality control of output from multiple internal and external sources.
  • Handle special projects as assigned.
  • Collaborated with the Awards and Subawards Management Team providing guidance and expertise on all technical and data management operations.
  • Inputted on average 60 three page orders per day Keystroke 10500 per minute with accuracy
  • Collaborated with data architects for data model management and EMR Salesforce Objects.
  • Retrieve, analyse and track confidential data involved in a Litigation.

Show More

28. VBA
demand arrow
average Demand
Here's how VBA is used in Data Analyst jobs:
  • Analyzed Business Requirements Documents to identify enhancements request to develop reporting tools using Microsoft Excel and Access VBA.
  • Create Excel VBA applications that automatically generate over 4 million latitude and longitude coordinates for multiple facility locations.
  • Developed Excel 2010 VBA solutions format and proof data in Excel workbooks that were going to be imported in Access daily.
  • Develop tools using VBA to validate input and export data correlation to decrease manual validation time needed by data owners.
  • Developed Access 2010 VBA automation to import and proof daily data files to eliminate as much human intervention as possible.
  • Utilized Excel VBA, Macros, and pivot charts to conduct portfolio attribution return analysis and built agency pricing models.
  • Created VBA programs to automatically update excel workbooks, encompassing class and program modules and external data queries.
  • Created many customized programs for various business needs using both advanced VBA macros and SAGE automated interactions.
  • Moderate level proficiency in scripting environments including VBA, SQL, Python, R, and MatLab.
  • Designed and implemented more security in all applications by using VBA code as part of control project.
  • Create automated reporting in Excel using VBA, Access DB, and SQL Server connections.
  • Extracted information from SAS processed data sets by Excel Pivot Table and VBA.
  • Utilized Visual Basic (VBA) code and Microsoft Access database queries.
  • Programmed automated report generation in Excel and Access using VBA.
  • Worked with VBA to create requirements for new software system.
  • Develop MS VBA scripts to automate recurring reports generation.
  • Generated Tools in MS Excel using VBA Program for users to extract the data automatically from Teradata database and SQL Server.
  • Created Macros (VBA) to automate and enhance the workflow of employees across the network.
  • Created financial reports to support various analytical and presentation needs using Excel and VBA programming.
  • Used Pivot tables, Excel lookup functions, Userforms in VBA and analyzed data to be presented to the leadership.

Show More

12 VBA Jobs

No jobs at selected location

29. Sharepoint
demand arrow
average Demand
Here's how Sharepoint is used in Data Analyst jobs:
  • Worked closely with Project Managers to update and maintain SharePoint/Google docs with accurate information.
  • Created SharePoint page to share information with other stakeholders and departments, to assist in training and to ease the transition.
  • Installed and configured Active/Passive SQL cluster with SQL Server 2008 R2 for high availability of SharePoint 2010.
  • Process deployment files into Clear Case Remote Client (CCR) and performed SharePoint procedures.
  • Evaluate business requirements, then recommend and configure the users SharePoint site accordingly.
  • Gained experience using Microsoft Office 2007, SharePoint, and Projects 2003.
  • Inputted statuses in a SharePoint database so that Account Managers, etc.
  • Track and review data for compliance and update SharePoint site.
  • Managed user groups and content access in SharePoint.
  • Deploy and administrate SharePoint 2007 and 2010..
  • Facilitated organized record management and access utilizing SharePoint and Document Management Systems.
  • Maintained SharePoint sites with latest Documentation available from different Teams.
  • Worked closely with SharePoint and Portal teams for testing functionality both on the users end as well as the analysts.
  • Identified candidate business processes which leverage SharePoint tools to enhance day-to-day office functions using workflows, Info Path forms.
  • Log in all working papers under classified control number given to the Sharepoint database for the command.
  • Plan, implement and maintain Business Intelligence solution with SQL server, Microsoft BI Suite and SharePoint.
  • Use of Sharepoint, Lotus Notes, OCV (internal IBM migration tool)
  • Develop custom ad-hoc business reports and dashboard using reporting services and SharePoint 2010..
  • Create summaries and reports on product and process data at The Kohler Company Create pages, lists, and forms on Sharepoint
  • Served as web master for Quality and redesigned/up kept the Quality Department's section in the Abrazo Health Care Sharepoint webpage.

Show More

93 Sharepoint Jobs

No jobs at selected location

30. Data Validation
demand arrow
low Demand
Here's how Data Validation is used in Data Analyst jobs:
  • Executed data validation, data profiling, data defects cleanup, data improvement initiatives, data quality monitoring reports
  • Monitor data integrity, manage data cleaning/quality control, and perform data validation and integrity checks.
  • Performed data loads and data validation using Apex Data Loader to ensure authentication of data analysis.
  • Performed testing on a data warehouse platform, including data integrity and data validation.
  • Performed data cleansing and data validation.
  • Led the design and implementation of data validation reports based on evaluation of needs of client's business.
  • Performed Data Analysis and Data validation by writing complex SQL queries using TOAD against the ORACLE database.
  • Executed data validation, data integrity, data profiling, data auditing, and data gap analysis.
  • Designed the Extract-Transform-Load (ETL) processing, and directed development and performed all testing/data validation activities.
  • Validated certain business processes (QA), did data validations; worked on erroneous files.
  • Developed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing and Report testing.
  • Defined and implemented data validation checks and routines (via SQL and Excel).
  • Tested the ETL process for both before data validation and after data validation process.
  • Established and managed EPIC conversion team for the patient satisfaction data validation process.
  • Performed data validation on several sources of the SLA data.
  • Worked on Data Validation and Data Integrity during UAT.
  • Involved in Data Validation using SQL queries.
  • Involved in extensive DATA validation using SQL queries and back-end testing Validated business reporting requirements with internal and external customers.
  • Utilized Excel advance features in data analysis: Pivot Tables, V-lookup, data validation, and logical formulas.
  • Reviewed normalized/Denormalization schemas for effective and optimum performance tuning queries and data validations in OLTP and OLAP environments.

Show More

154 Data Validation Jobs

No jobs at selected location

31. QA
demand arrow
low Demand
Here's how QA is used in Data Analyst jobs:
  • Performed Data QA on electronic automotive catalog data.
  • Prepared and tested data loads into internal systems as well as communicated with developers regarding requirements, testing and QA processes.
  • Produced cross-functional diagrams, employed SQL queries, performed QA and data mapping analysis, and contributed to business requirements gathering.
  • Helped the QA team to devise the test plan for the application by explaining the vision document and the business case.
  • Provided control, support, and analysis of reporting upgrades for canned, QA, NYA, and custom reports.
  • Revise existing deficiencies based on QA audits and responds to inquiries regarding status of applications received.
  • Work closely with developers to complete QA testing, answer client questions and brainstorm software improvements.
  • Achieved 100% first time file approval rate from QA review per performance standards.
  • Involved in code migration to QA and addressing the defects during the QA Phase.
  • Involved in migrating the system from development to QA and to production environments.
  • Conduct QA of databases, report bugs and verify features and functionality.
  • Worked with QA test team to analyze the results of data migration.
  • Worked to ensure data met NCQA and JCAHO standards.
  • Supported Impact QA files testing on a server.
  • Conducted milestones planning of the project through walkthroughs and meetings involving various leads from development, QA and technical support teams.
  • Assist with the QA and production turnover of the applications Perform daily business and application support.
  • Create QA test plans and procedures, as well as automated procedures to sum financials.
  • Provide QA support; validate data integrity and quality for post-benchmarking wireless projects.
  • Bank back office security set-ups and quality assurance in Trust 3000 for marketable/non-marketable securities QA reporting on a daily/weekly/monthly/quarterly basis.
  • Increased efficiency of the QA process, resulting in a significantly higher quali- ty end product for clients.

Show More

56 QA Jobs

No jobs at selected location

32. Analyze Data
demand arrow
low Demand
Here's how Analyze Data is used in Data Analyst jobs:
  • Research and analyze data anomalies utilizing analytic skills and cross referencing different vendor data feeds, publications, and financial websites.
  • Developed and conducted student surveys to analyze data regarding student engagement and participation at the university.
  • Collaborated with Infection Prevention team to compile/analyze data and identify areas for improvement.
  • Analyze data to identify current or emerging trends linked to illegal activity.
  • Analyze data gathered and develop solutions or alternative methods of proceeding.
  • Utilize Microsoft Excel and Access extensively to analyze data from various sources across Cisco and consolidated data based on business needs.
  • Analyze data with extensive use of SQL, Excel functions and macro creation to minimize time of issue resolution.
  • Use Microsoft Access and Tableau to analyze data to draft reports in order to assist in consulting.
  • Experienced with Microsoft Excel using formulas to analyze data for use in projects like the RepairPrice Estimator.
  • Conduct data queries, validate and analyze data, and create reports for management on program elements.
  • Analyze data with basic statistical methods, interpret results, and provide written summaries of data analyses.
  • Used knowledge of MS Excel and attention to detail to quickly and accurately analyze data.
  • Handled stakeholders and technical team members work sessions to gather and analyze data requirements.
  • Analyze data for monthly, quarterly and year end reporting to current customers.
  • Gather and analyze data to identify and detect claim abuse and/or insurance fraud.
  • Extract, compile, track, and analyze data to generate reports.
  • Coordinated with department head to source and analyze data.
  • Analyze data sets for integrity and proper scoping.
  • Retrieve and analyze data using SAS and SAP.
  • Collect and analyze data from Los Angeles County Recorders Office in Norwalk, California.

Show More

108 Analyze Data Jobs

No jobs at selected location

33. Ssis
demand arrow
low Demand
Here's how Ssis is used in Data Analyst jobs:
  • Provide assistance in administrative activities and coordination efforts with program/ project staff as necessary.
  • Developed daily reports to assist department in maintaining compliance with federal and state regulations.
  • Assisted with the planning and facilitation of exercise development meetings involving over 100 participants.
  • Assisted customers with credit changes or improvements with expert financial consultations.
  • Assist with the preparation of updating process design, process flows, functional designs & training material.
  • Create, modify written procedures and policies regarding reconciliation process and assist with designing training manuals.
  • Assist CRM Analyst with Email Marketing Campaigns, including Client Publications, Newsletters, and announcements.
  • Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
  • Assist Management in day to day functions of reporting in all processes and internal functions.
  • Used SSIS to extract, transform, and load data from transaction systems.
  • Assisted with Record Center mailing and routing mail delivered to specific personnel.
  • Assist with audits or research and required to produce reports.
  • Assisted the DBA in converting the logical models to physical.
  • Assisted in maintaining and updating the company database every day.
  • Assisted in closing files sent to the National Archives.
  • Assisted in reorganization of the company database.
  • Assist with special projects as requested.
  • Assist co-workers, supervisor or management.
  • Assist with end user training.
  • Assisted in designing and development of health related analytical products for overall enterprise.

Show More

268 Ssis Jobs

No jobs at selected location

34. Toad
demand arrow
low Demand
Here's how Toad is used in Data Analyst jobs:
  • Load and maintain inventory by site, customer, inventory and vendor data using CuteFTP, TOAD and other programs.
  • Used Toad and SQL Plus for testing execution of ETL Processes' PL/SQL procedures, packages for business rules.
  • Use Toad software to access and manage our data through the process of creating and running PL/SQL scripts.
  • Experienced using database query and integration tools such as SSIS, TOAD, SQL plus etc.
  • Used SQL, Toad, Data Warehousing and Data Cleansing for the arrangement of customer data.
  • Created simple SQL queries in Toad to assist customer with identifying inconsistencies and maintain data integrity.
  • Calculated habitat connectivity for various frog and toad species using QGIS and R Statistics.
  • Defined the duplication of data and columns between tables using TOAD and SQL.
  • Executed the Test Scripts in TOAD and documented the results in RTM.
  • Used TOAD & SQL Navigator GUI tools for Querying Database.
  • Used Toad to validate the data and testing.
  • Worked with TOAD and extensive PL-SQL.
  • Run the SQL queries using TOAD and SQL Navigator.
  • Used TOAD Software for Querying ORACLE.
  • Prepared ad hoc queries for program administrators and clients using MS Access and Toad Oracle SQL queries.
  • Performed data analysis on merchants' locations by using SQL queries in TOAD ORACLE database.
  • Served as a resource for analytical services utilizing SQL Server, and TOAD/Oracle.
  • Used SQL queries, ERwin, SQL*Plus, & Toad to explore & create fixes.
  • Performed Gap Analysis and wrote SQL queries In 'Teradata Studio' & 'TOAD for Data Analysts' environments.
  • Updated work instructions Environment: Toad for Oracle 10.6.1.3, Siperian Hub Console, Siperian Business Data Director 10/11-01/12

Show More

6 Toad Jobs

No jobs at selected location

35. EDI
demand arrow
low Demand
Here's how EDI is used in Data Analyst jobs:
  • Report, work and monitor duplicate and deceased patient medical record numbers daily upon notification.
  • Provided credible, evidence based arguments and recommendations to support research proposals and grant application.
  • Conducted verification of customer data credit from subscriber companies, reconciling balances as needed.
  • Process raw LiDAR data by utilizing LiDAR point/polygon editing tools and feature code manipulation
  • Developed method of calculating key performance indicators for the Medicaid population.
  • Edited specific protocols and policies from inaccurate data.
  • Provide remediation and regulations for inspected entities.
  • Worked on complex risk adjustment models such as CMS-HCC model for Medicare, CDPS and CRG models for Medicaid.
  • Report quarterly credit balances for Medicare, Peach State Health Medicaid and submit the required GHA discharge data.
  • CONTRACT EMPLOYEE - Entered and managed reported claims pertaining to credit card fraud and purchase disputes in database.
  • Find solutions to EDI related problems by contacting EDI providers, trading partners or other resources as necessary.
  • Responded to customer inquiries on internal products, services and credit card processing activities for the industry.
  • Pack orders in EDI program; submit advanced shipment notifications and electronic invoices to trading partners.
  • Edited over 2000 articles and published them on Client CMS (Content Management System).
  • Edited reports for content and accuracy for more than 100 computer operators.
  • Ensured overall accuracy of product for internet and social media.
  • Analyzed and edited Sky Tracker survey data.
  • Involved in creating dashboard based on the history sales data to do the Prediction analytics on the future volume of sales.
  • Applied predictive modeling to identify impactable patients for lowering costs and identifying those at risk for hospital readmission.
  • Completed medical claims for processing Reviewed data for accuracy Trained on HIPPA regulations

Show More

107 EDI Jobs

No jobs at selected location

36. Ssrs
demand arrow
low Demand
Here's how Ssrs is used in Data Analyst jobs:
  • Champion data analysis and reporting, using Excel and reporting tools such as SSRS, to influence senior-level decision making.
  • Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
  • Worked on SSRS reports to report the Daily, Weekly and Monthly Statistics of various service providers.
  • Designed, developed reports using SSRS and modified existing queries to improve efficiency and meet new requirements.
  • Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
  • Develop dynamic reports of the survey data in SSRS (SQL Reporting Services).
  • Generate SSRS BI report and Crystal Report to summarize and evaluate operation performance.
  • Design, deployment, and maintenance of various SSRS Reports in SQL Server 2008
  • Utilized SQL server's reporting services SSRS and SSIS to support reporting requirements.
  • Developed queries for generating drill-down and drill-through reports in SSRS 2008.
  • Extract files from SSRS and scrub against MSP to ensure accuracy.
  • Created reports that call sub reports in SSRS.
  • Generated custom and parameterized reports using SSRS.
  • Created various reports with parameters, conditional formatting with expressions using SSRS Reporting Services Performed daily work query and script etc.
  • Work with SQL Server 2005 Analysis Services to build OLAP Cubes as a backend Data Source for SSRS.
  • Analysed, designed, created and tested Reports as per user requirements using SSRS.
  • Generated the drilldown, drill through and linked reports using the SSRS.
  • Identified and worked with Parameters for parameterized reports in SSRS 2012.
  • Worked on SSRS for an ad-hoc project and created 5 reports.
  • Provided data analysis support and Business Intelligence reporting application development services using SQL and SSRS for Microsoft Xbox Console Development team.

Show More

199 Ssrs Jobs

No jobs at selected location

37. Project Management
demand arrow
low Demand
Here's how Project Management is used in Data Analyst jobs:
  • Provided project management and administrative support to three internal departmental program areas.
  • Served as liaison between project management personnel and laboratory service personnel.
  • Aided with continuous improvement to project management processes and business practices
  • Coordinated project management in math program.
  • Develop strategic planning schedules and provide support to project management in cost, schedule, performance measurement, and forecasting analysis.
  • Communicate requirements to the various interested parties: stakeholders, subject matter experts, sponsors, and project management teams.
  • Provide client support in various areas, including project management, high-end consulting, data modeling and business intelligence.
  • Attended JAD sessions and created reports for Budgeting, Finance and Project Management departments.
  • Worked within the Project Management Office Governance department of a local health insurance company.
  • Project planning for new product launches as a part of Project Management Team.
  • End to end project management and hands on delivery when required.
  • Provided project management and oversight for all Data Center services.
  • Provide excellent customer service for external and internal customer Provided project management support through weekly report updates.
  • Research Project Management Primary liaison between major institutional and departmental stakeholders for problem resolution and organization.
  • Define the Project Management needs in regards to information database structure and processing requirements.
  • Project management and performance analytics.
  • Participated in all phases of SDLC in a project management role on a two-year systems development project.
  • Communicate reporting modifications and enhancements to MI Project Management, client representatives, and IT staff.
  • Project Management skills are used to create projects in a timely manner.
  • Supported in developing project timelines, deliverables, and strategies for effective project management.

Show More

2,012 Project Management Jobs

No jobs at selected location

38. Business Rules
demand arrow
low Demand
Here's how Business Rules is used in Data Analyst jobs:
  • Involved in requirements gathering and source data analysis and identified business rules for data migration and for developing data warehouse.
  • Enforced business rules using PL/SQL in Database Triggers/Stored Procedures/Functions.
  • Created store procedures, views and tables for all the existing queries in the Access database and additional business rules.
  • Used data analysis techniques to validate business rules and identify low quality missing data in the existing data.
  • Handled customer and collaborator requests with attention to speed, detail and respect of the company business rules.
  • Used T-SQL to analyze, query, sort and manipulate data according to defined business rules and procedures.
  • Involved in defining the source to target data mappings, business rules, and business and data definitions.
  • Collaborate with Sales, Finance and IT Managers to build credit automation rules based on business rules.
  • Verified the data has been populated and transformed as per the business rules in target dB.
  • Update dimension tables within the warehouse on a project by project basis according to business rules.
  • Created business rules and best practices for loading, updating and quality control of well data.
  • Facilitated the meetings with Work package team to review SQL scripts which monitor the Business Rules.
  • Designed and developed table structures, stored procedures, and functions to implement business rules.
  • Recommend approval/rejection to government on new business rules in development for the EDMO portal.
  • Define and implement corporate level data and business rules for maintaining accuracy of data.
  • Obtained and applied business rules for data transformation between multiple sources and one destination.
  • Developed Business Rules for quality control of metadata in well log files.
  • Implemented business rules on data using Stored Procedures, Functions and Packages.
  • Revised business rules and process and updated the changes to database.
  • Worked with SMEs to develop operations based business rules/procedures that support the transformation of sales data.

Show More

676 Business Rules Jobs

No jobs at selected location

39. XML
demand arrow
low Demand
Here's how XML is used in Data Analyst jobs:
  • Worked extensively with XML schema generation.
  • Worked on estimation, design and development of changes for web pages using XML, HTML, CSS and Java script.
  • Web service output standardized address information as XML to the client based on input required to be postal information.
  • Identify data issues and responsible for transforming data in databases into XML using XSLT through ETL process.
  • Write and edit ADI XML metadata to upload media and add/update data for existing assets.
  • Designed and developed Canonical Data Models (XML/JSON) as well as XSLT transformations.
  • Worked on UI development using internal framework, based on XML and XPATH.
  • Used XML to create Web-based tools for transactions on SQL and Oracle databases.
  • Design and develop the data load process using XML Style sheets and ACORD.
  • Resolve structured content (XML/HTML) issues preventing publishing of new content.
  • Modified XML Code data extraction queries across multiple tables and data sources.
  • Validated Response with the XML Schema during web service testing.
  • Defined data requirements and elements used in XML transactions.
  • Implemented manual testing of web services using XML Spy.
  • Learned several computer programs including xml editing and other company applications.
  • Unstructured files like XML's, JSON files are processed using custom built Java API and pushed into mongodb.
  • Developed and implemented SGML/XML conversion strategy; developed SGML/XML content DTDs.
  • Used Hadoop streaming to process terabytes data in XML format.
  • Experienced in running Hadoop streaming jobs to process terabytes of xml format data.
  • Used several authoring tools: XMLSpy & XMetal.

Show More

93 XML Jobs

No jobs at selected location

40. DB2
demand arrow
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.
  • Created ETL solutions using SSIS to extract, transform and load data between multiple MSSQL and DB2 databases.
  • Received DBA training and functioned as DBA in the creation of a Clinical DataMart in DB2 on AIX/Unix.
  • Designed Visual Basic SQL programs and wrote SQL queries required for acquiring data from the DB2 mainframe database.
  • Queried multiple DB2 and Oracle databases using various query tools and versions of SQL query language.
  • Participated in the project to upgrade all Federal Reserve DB2/MVS systems to a new release.
  • Collected and cleaned data on public construction efficiency and set up database using DB2.
  • Developed relational databases in Access, SQL Server, Fox Pro, and DB2.
  • Analyzed Mainframe DB2 tables and related jobs for a branch code update project.
  • Pull aggregate sales facts and figures utilizing SQL queries from DB2 database.
  • Designed and maintained various database systems including MSSQL, PostgreSQL and DB2.
  • Designed DB2 tables used for open database connectivity.
  • Supported legacy COBOL/DB2 JCL systems for conversion.
  • Create SSIS Packages to integrate data coming from multiple heterogeneous sources including DB2, Teradata, text files and Excel files.
  • Generated ad-hoc SQL queries using joins, Database connections and transformation rules to fetch data from legacy DB2 and SQL Server.
  • Maintained 1.3M records in a Microsoft SQL Server database, IBM DB2, Easytrieve programs and performed SAS statistical modeling.
  • Designed and developed ETL process to load and extract data using Db2 Load and Oracle Sql Loader.
  • Validated the test data in DB2 tables on Mainframes and on Tera data using SQL queries.
  • Used efficient SAS programming techniques to subset large datasets housed in DB2 and Access.
  • Experienced in working with DB2, Teradata.

Show More

7 DB2 Jobs

No jobs at selected location

41. BI
demand arrow
low Demand
Here's how BI is used in Data Analyst jobs:
  • Create, and maintain eligibility database; analyze and audit all eligibility data for accuracy.
  • Validate Billing Telephone Numbers using various databases.
  • Bill of Materials, LIFO Calculations, developed, analyzed, and reported Labor, Material, Overhead and Absorption variances.
  • Run self-pay and payment arrangements statements to reduce customer complaints of billing errors and assist guarantors when needed on billing questions.
  • Coordinate and ensure customer account, process payments, solve and explain practical problems in resolving billing issues.
  • Manage high volumes of calls consisting of technical support, billing, sales and general account support.
  • Responded to all correspondence from third part billing agencies and insurance companies on a weekly basis.
  • Interact with the implementation and billing office, sales and executive staff.
  • Performed Data cleansing and scrubbing while finding the quality data.
  • Ensured the feasibility of the logical and physical design models.
  • Processed Insurance, Medicaid, Medicare D billing.
  • Assisted BI Developers to fetch reports using SSRS.
  • Sole responsibility for daily critical ETL batch processes.
  • Monitor hospitalization events within the Flowcast Billing System.
  • Decreased cost of project by 15% through creating test strategy, Requirements Traceability Matrix and end to end test scenarios.
  • Work with billers and Assistant Manager on a weekly basis regarding billing errors.
  • Process new commercial insurance coverages (Property, Garage, General Liability).
  • Review clients provider billing information for accurate match to system records.
  • General Manager - Complete P&L responsibility for $2 million dollar operation, 30 year old consulting firm.
  • Assist a venture partner to found a biotech startup focused on the central nervous system.

Show More

3,172 BI Jobs

No jobs at selected location

42. Suite
demand arrow
low Demand
Here's how Suite is used in Data Analyst jobs:
  • Created C-Suite presentations for quarterly performance of Media Monitoring Unit for management.
  • Maintain new and existing builder records, and utilizes Microsoft Office Suites and other software to provide management reporting services.
  • Designed a suite of daily reports and fully automated their execution, saving over 2 hours of work per day.
  • Conceptualized and developed a test suite for bulk testing of 10,000+ test cases, pulling from production data.
  • Integrated automated time and attendance processes and technologies to the application suite.
  • Program managed various assignments and projects using Microsoft Office Suite & Project.
  • Developed new suite of crystal reports for monthly and quarterly reporting.
  • Selected office equipment and software best suited for company use.
  • Implemented the best suited Agile CRM as per company requirements.
  • Created users and securities for new Midas+ suite users.
  • Automated regression test suites to run during off-hours.
  • Created programs using Developer Suite.
  • Integrated Acquisition Division, 2011 Crystal Drive, Suite 900, Arlington, VA 22202.
  • Supported Oracle e-Business Suite financial modules to include exposure to full lifecycle implementation of related modules.
  • Created and manage Dashboards, Worksheets helping senior Management to have at-a-glance views of KPIs using Tableau and OBIEE Suite.
  • Develop lists and searches in Netsuite for other departments to assist with their daily tasks.
  • Work with cross-functional teams to successfully implement Cerner Millennium product suite and achieve client goals.
  • Imported and validated new client data to create client reporting suites in Omniture.
  • Used MS-office suite, Photoshop Adobe.
  • Scaled and improved existing Salesforce analytics suite before Yahoo!

Show More

512 Suite Jobs

No jobs at selected location

43. UAT
demand arrow
low Demand
Here's how UAT is used in Data Analyst jobs:
  • Analyzed applicant's financial status, credit and property evaluation to determine feasibility of granting loan.
  • Evaluated and presented recommendations related to business, technology, and process improvements.
  • Accessed system to evaluate claims transactions for processing accuracy.
  • Design experiment to evaluate pharmaceutical assets for in-licensing opportunities.
  • Conformed to policies and procedures when evaluating transactions.
  • Interpret and evaluate exported data based the user experience of Apple's Map/Geo services by performing analysis on Apple Map services.
  • Designed and produced UAT test cases for the XLRA reports, worked with end users to help identify problems and requirements.
  • Present program evaluations, predictive models, and dashboard builds to colleagues, internal users, and senior management.
  • Evaluate scientific, technical, IP and commercial landscape of the science and platform technology.
  • Gather, evaluate, and process data received from legal teams and/or external stakeholders.
  • Created evaluation reports for Delmarva Foundation's nursing home conferences using Microsoft Excel.
  • Analyze Medicaid and Medicare claims data for reporting and program evaluation purposes.
  • Created a Project Tracking & Evaluation application and a work-scheduling database.
  • Detail long-standing extract defects for resolution; conduct/execute UAT.
  • Evaluate grant opportunities within the Promise Zone.
  • Updated presentation decks for Corp and Field UAT users for the SMSG FY Roll and MYR UAT testing cycles.
  • Coordinated with technical teams for research and evaluation of healthcare and operational problems.
  • Establish timelines and goals to ensure all projects are implemented appropriately and adequate information is given new and used equipment.
  • Provide support and perform end of month close outs Tracks, evaluates, and reports the status of pricing agreements.
  • Conduct analytical and trending HSE reports, perform gap analysis and evaluate activity deficiencies across all Business Units.

Show More

109 UAT Jobs

No jobs at selected location

44. Python
demand arrow
low Demand
Here's how Python is used in Data Analyst jobs:
  • Developed clustering models for customer segmentation using Python.
  • Used SQL, R, and Python to extract, clean and organize data to build models with high accuracy.
  • Performed feature scaling and feature engineering, with SQL, python and Excel, to calculate customer lifetime value.
  • Test compatibility and functionality of a web application using Selenium, SikuliX and Python 2.7.
  • Developed Python programs for bulk insertion of customer and item data from files to HBASE.
  • Scraped data from various websites by using advanced functions in Python or R language.
  • Automated build & deployment of the application (PowerShell, Python).
  • Used R and python Data Science Libraries for Analyzing GE Capital Data.
  • Use Tableau, R and Python to visualize the result.
  • Focused on cellphone GPS data mining using MySQL and Python.
  • Worked with Python to automate ArcGIS tool.
  • Use Excel, R and Python to analyze the data.
  • Created dynamic linear models to perform trend analysis on customer transactional data in Python.
  • Provided input on a number of clients reports and identify trend in data with Python; simplify the information gathering process.
  • Machine learning projects using Python libraries and R, random tree and booted tree classification, SVM, deep neural network.
  • Coded in Python(Pandas, scikit-learn) for data wrangling, exploratory analysis and dimension reduction.
  • Developed Python scripts to process, analyze, and compile genome data of lettuce and tomatoes.
  • Use Python scripting to simplify lengthy processes.
  • Queried and manipulated data via SQL, R, Python, Teradata and quick shell scripts to preprocess and aggregate.
  • Cleansed historical data in python (pandas, sys, json_normalize).

Show More

2,016 Python Jobs

No jobs at selected location

45. Raw Data
demand arrow
low Demand
Here's how Raw Data is used in Data Analyst jobs:
  • Converted raw data into consumable reports by creating spreadsheets and analyzing data to extract relevant information into reports.
  • Analyzed raw data and developed recommendations and conclusions.
  • Managed accounts for over 5,000 Authorized Service Centers and analyzed raw data of claim information to produce tables for future planning.
  • Developed MapReduce programs to parse the raw data, populate staging tables and store the refined data in partitioned tables.
  • Create Monthly Reports for SVP's by converting Raw data into readable pivot tables using Excel LOOKUPS, PIVOTTABLE.
  • Prepared data for processing by organizing information, checking for any inaccuracies, and adjusting and weighting raw data.
  • Extracted, interpreted and analyzed data to identify key metrics and transform raw data into meaningful, actionable information.
  • Used SQL Server 2008 Enterprise Edition to extract raw data from the Homeless Management Information System data warehouse.
  • Parsed data, producing concise conclusions from raw data in a clean, well-structured and easily maintainable format.
  • Created R scripts to size raw data into smaller workable clusters based on signal strength and accuracy.
  • Perform data extraction from raw data, followed by data validation to find dirty elements.
  • Created SQL queries and exported normalized data to test against QlikView front-end and raw data.
  • Transformed large, raw data sets into usable information and summarized data in customized dashboards.
  • Analyze raw data and make necessary modifications, prepare cases as per project requirements.
  • Summarized raw data and presented tables, charts, key information for research associates.
  • Processed and analyzed raw data to determine the dependent variable and independent variables.
  • Treated raw data with python and SQL for data cleansing and manipulation.
  • Performed the query, entry and quality inspection of raw data.
  • Compiled raw data of more than two hundred AML patients who have had non-myeloablative transplantation.
  • Produced and delivered ad hoc client reports/deliverables and compiled raw data for retailer acceptance.

Show More

48 Raw Data Jobs

No jobs at selected location

46. Monthly Reports
demand arrow
low Demand
Here's how Monthly Reports is used in Data Analyst jobs:
  • Prepared and presented weekly/monthly reports detailing instrumentation performance during launch activities.
  • Prepared monthly reports and assisted in analyzing outcome data.
  • Generated monthly reports and scorecards for customers, delivering metrics based on product failure rates using SalesForce.com and Excel.
  • Reported Financial and Budget monthly reports and monitored project plans to ensure cost and scheduling milestones were met.
  • Produced PCTS task name/number to track and enter time spent creating and processing requests/cases for monthly reports.
  • Created a case manifest to track and enter activities into a customized tracking system for monthly reports.
  • Created monthly reports showcasing claims inventory by date paid and dollar paid, utilized by multiple departments.
  • Program Manager; duties included reviewing monthly reports of patients requiring actions based on HEDIS metrics.
  • Supervised, trained and developed departmental staff, prepared monthly reports for the Railroad Retirement Board.
  • Provided keen oversight to database inventory through the development and execution of 20 monthly reports.
  • Compiled and distributed weekly and monthly reports, which aided in decision-making processes.
  • Created daily and monthly reports using SQL and UNIX for Business Analysis.
  • Put together monthly reports to be mailed out to all clients.
  • Create weekly and monthly reports for internal review.
  • Maintained monthly reports and data for due diligence.
  • Created monthly reports and closed terminated records.
  • Prepared weekly and monthly reports of progress.
  • Maintain and distribute monthly reports.
  • Provided Sales, Account Management, and the Sales Channel ad-hoc, weekly, and monthly reports.
  • Created and modified SQL reports using SQL Server Reporting Services Produced metrics and analytics for monthly reports and yearly audits

Show More

4 Monthly Reports Jobs

No jobs at selected location

47. CRM
demand arrow
low Demand
Here's how CRM is used in Data Analyst jobs:
  • Recorded information in database and placed specifications on company website using Microsoft Excel and Microsoft CRM.
  • Monitor and analyze data for utility billing/CRM systems supporting 200+ users
  • Conducted employment market research using Microsoft Dynamics CRM which contributed to Account Executives reaching the organization s sales goals.
  • Served as single point of contact for issues and concerns for data validation issues with TIMMS CRM.
  • Performed data mapping, data validation, data conversion from legacy system to new TIMSS CRM.
  • Used CRM system ECTS to review the CR ids and prepared project status reports.
  • Utilize CRM Solution Database (Clarify) and department resources for product knowledge.
  • Helped with initial user testing of CRM/PSX customization as an incentive request tool.
  • Utilized LeadCenter (CRM) to generate metrics and develops actionable recommendations.
  • Managed and supported the warehouse with the help of CRM tool.
  • Documented the process of validating new customer accounts in YCRM.
  • Maintained sales opportunities in Microsoft Dynamics CRM system.
  • Validated new customer accounts in YCRM.
  • Gathered requirements for improved Veeva CRM functionality, prioritized and recommended course of action to implement feature requests to SFA team.
  • Worked with internal customers and third party vendors to develop requirements for ad hoc reporting for the purpose of CRM.
  • Used MS Video Publishing Tool and MS CRM to manage and publish video content to Microsoft's Xbox.
  • Performed the customization of Agile CRM for the best practice of organization's work flow.
  • Identified and profiled most profitable customers and strategized CRM merchandising to better target them.
  • Supported Client/Server IT staff related to CRM (Siebel) software and included report creation, analysis, and development.
  • Created reports to assist Home Office and Field users in utilizing Health Care Professional information within Veeva CRM and Veeva Network.

Show More

413 CRM Jobs

No jobs at selected location

48. Html
demand arrow
low Demand
Here's how Html is used in Data Analyst jobs:
  • 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.
  • Web Form design and coding using Master Pages, Server controls, Cascading Style Sheets, JavaScript, HTML5.
  • Prepared reports directing SAS output to HTML files using output delivery system facility (ODS).
  • Changed word documents into HTML & PDF s. Maintain logs of completed work.
  • Developed applications using PL/SQL, SQL, Pro*C, HTML and DreamWeaver.
  • Developed, maintained Monthly metrics reports with HTML, WebFocus/SQL query.
  • Designed procedural manuals using HTML and CSS in Microsoft word.
  • Used SAS/ODS to generate the Statistical reports in HTML format.
  • Worked on drill through reports by creating HTML references.
  • Learned complex Excel commands and HTML coding.
  • Performed design user interface with HTML.
  • Produced reports in multiple formats (HTML/CSS, PDF, Excel, CSV, and Word).
  • Generated highly customized reports using PROC FORMAT, PROC REPORT, PROC TABULATE and ODS HTML.
  • Created reports in PDF, HTML, RTF formats using ODS statements.
  • Searched periodicals to create and compile records in HTML format for a turfgrass database used worldwide for turf references and information.
  • Designed and developed Customer registration and login screens using HTML, and JavaScript.
  • Showcased visualization in an interactive site built using CSS, HTML and Javascript
  • Use the following languages and skills: JQuery, JavaScript, HTML, CSS, ASP.NET.
  • Designed webpages using HTML, CSS, AJAX and Struts Tag Libraries.

Show More

491 Html Jobs

No jobs at selected location

49. T-Sql
demand arrow
low Demand
Here's how T-Sql is used in Data Analyst jobs:
  • Designed and implemented T-SQL procedures that address complex data retrieval and calculations.
  • Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
  • Review, analyze, and ensure the quality of data loaded into the database system by utilizing T-SQL and Excel.
  • Analyzed and maintained large data files for the ADE Special Education Unit and IDEA Data & Research Office using T-SQL.
  • Write T-SQL statements for retrieval of data and involved in performance tuning of TSQL queries.
  • Worked with T-SQL to create Tables, Views, UDF and Triggers and Stored Procedure.
  • Reviewed query execution plans, built indexes, and modified T-SQL code for increased performance.
  • Managed all indexing, debugging and query optimization techniques for performance tuning using T-SQL.
  • Converted SAS codes into T-SQL to automate data cleaning procedures previously performed by bio-statisticians.
  • Develop ETL package using T-SQL and SQL integration service for Data Warehouse.
  • Used SQL Server Management Studio and T-SQL for managing database related activities.
  • Modify Stored Procedures and complex T-SQL Queries to improve query execution process.
  • Create and modify T-SQL queries for data mining to validate/support business decisions.
  • Updated T-SQL scripts to manipulate data for data load and extracts.
  • Provided database coding to support business applications using SQL Server T-SQL.
  • Write T-SQL Scripts for database backup jobs and daily/weekly jobs.
  • Developed ETL/T-SQL script to transfer data from various source.
  • Used T-SQL for creating database objects and analysis queries.
  • Resolved issues within production database using T-SQL queries.
  • Followed client requirements and created T-SQL and PL/SQL scripts, stored procedures, functions, CTEs, and triggers.

Show More

50. Technical Support
demand arrow
low Demand
Here's how Technical Support is used in Data Analyst jobs:
  • Provided technical support and consultation to internal and external customers regarding secure electronic data transmissions and file formats.
  • Identified and resolved technical support issues regarding application specific data and business process flows.
  • Validated critical test instrumentation, collected data and provided technical support during engine test.
  • Worked with Enterprise Database and Software assuring data integrity and providing technical support.
  • Participated in continuous quality improvements for technical support and provisioning teams.
  • Provided Tier 1 technical support to the Help Desk of FEMA's LMS (FEKC) and implemented system updates.
  • Provided application/technical support to the clients to ensure effective use of tools/systems and resolved problems reported by users.
  • Perform support activities for sales, purchasing, engineering, accounting, receiving and technical support.
  • Provide technical support to victims/claimants, advocates, on the procedures used when filing a claim.
  • Provided technical support to CDS staff as necessary to complete projects on-time and accurately.
  • Provide second tier technical support to CTS staff and other Data Management stakeholders.
  • Provided technical support for youth drug prevention coalitions across the state of Arizona.
  • Provided technical support and training to department staff in day-to-day use of databases.
  • Provided technical support and help desk inquiries with federal government travel system.
  • Provide technical support for systems, software applications and manage desktop workstations.
  • Provided technical support and end user supports to all CDS clients.
  • Provide 1000 plus users with technical support.
  • Maintain and update technical support information and documents on the Logitech website.
  • Provided technical support for TSIS/TIES/Cognos systems for administration and teaching staff.
  • Receive inbound calls within call center Supply technical support to online consumer Process consumer book phone orders Answer consumer emails

Show More

130 Technical Support Jobs

No jobs at selected location

Data Analyst Jobs

NO RESULTS

Aw snap, no jobs found.

20 Most Common Skills For A Data Analyst

Database

17.6%

Pl/Sql

13.7%

Procedures

8.7%

Data Analysis

8.2%

Financial Statements

5.8%

Data Entry

4.9%

SQL

4.8%

ETL

3.7%

Data Quality

3.4%

SAS

3.3%

Data Warehouse

3.1%

Test Cases

2.9%

Data Management

2.9%

Business Requirements

2.9%

Windows XP

2.5%

Unix

2.4%

Business Process Models

2.3%

Audit

2.3%

Data Collection

2.3%

Data Integrity

2.3%
Show More

Typical Skill-Sets Required For A Data Analyst

Rank Skill
1 Database 12.4%
2 Pl/Sql 9.6%
3 Procedures 6.2%
4 Data Analysis 5.8%
5 Financial Statements 4.1%
6 Data Entry 3.5%
7 SQL 3.4%
8 ETL 2.6%
9 Data Quality 2.4%
10 SAS 2.3%
11 Data Warehouse 2.2%
12 Test Cases 2.1%
13 Data Management 2.1%
14 Business Requirements 2.0%
15 Windows XP 1.8%
16 Unix 1.7%
17 Business Process Models 1.7%
18 Audit 1.6%
19 Data Collection 1.6%
20 Data Integrity 1.6%
21 Customer Service 1.6%
22 Pivot Tables 1.5%
23 Powerpoint 1.4%
24 Teradata 1.2%
25 Visio 1.2%
26 Informatica 1.2%
27 R 1.2%
28 VBA 1.2%
29 Sharepoint 1.1%
30 Data Validation 1.1%
31 QA 1.1%
32 Analyze Data 1.1%
33 Ssis 1.0%
34 Toad 1.0%
35 EDI 1.0%
36 Ssrs 0.9%
37 Project Management 0.9%
38 Business Rules 0.9%
39 XML 0.8%
40 DB2 0.8%
41 BI 0.8%
42 Suite 0.8%
43 UAT 0.8%
44 Python 0.8%
45 Raw Data 0.7%
46 Monthly Reports 0.7%
47 CRM 0.7%
48 Html 0.7%
49 T-Sql 0.7%
50 Technical Support 0.7%
{[{skill.rank}]} {[{skill.name}]} {[{skill.percentageDisplay}]}%
Show More

36,395 Data Analyst Jobs

Where do you want to work?

To get started, tell us where you'd like to work.
Sorry, we can't find that. Please try a different city or state.