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.

Senior Data Analyst-

This job has expired and is no longer available.
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 Senior Data Analyst- Skills

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

These are the most important skills for a Senior Data Analyst-:

1. Data Warehouse

demand arrow
high Demand
Here's how Data Warehouse is used in Senior Data Analyst- jobs:
  • Develop mappings to enable data migration, application integration for transformation to a data warehouse.
  • Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
  • Designed and supported the architecture for enterprise-wide data warehouse user access management.
  • Assisted in the development and enhancement of data warehouse and business intelligence systems that the CRM system feeds.
  • Involved in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse.
  • Involved in migration projects to migrate data from data warehouses on Oracle and migrated those to DB2.
  • Provided raw SQL data for a data warehouse project in which reports were created using tableau.
  • Obtained the data from SQL Server, Oracle, Files, and Access into Data warehouse.
  • Troubleshooted test scripts, SQL queries, ETL jobs, data warehouse/data mart/data store models.
  • Created star schema of the data warehouse after normalizing the database up to 3NF.
  • Used Merge command along with TSQL for SCD type 2 data warehouse project.
  • Involved in the creation, maintenance of Data Warehouse and repositories containing Metadata.
  • Design data models for development of a data warehouse and data marts.
  • Gather requirements and design of data warehouse and data mart entities.
  • Involved in the process design documentation of the data warehouse.
  • Involved in Data Mapping activities for the data warehouse.
  • Provided slowly changing dimension engines for the data warehouse.
  • Involved in dimensional modeling of the data warehouse.
  • Verified that data in Oracle transactional databases were extracted, transformed and loaded into data warehouse tables.
  • Implemented Change Data Capture technology in Talend in order to load deltas to a Data Warehouse.

Show More

19 Data Warehouse Jobs

No jobs at selected location

2. Business Requirements

demand arrow
high Demand
Here's how Business Requirements is used in Senior Data Analyst- jobs:
  • Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements.
  • Enhanced and expanded enterprise-wide financial services data warehouse model through sound detailed analysis of business requirements.
  • Key member of a team participating directly in project planning sessions to analyze business requirements.
  • Involved in Analyzing and Documenting end user requirements, Business requirements and Data Specifications.
  • Researched and provided solutions for business requirements - both technical and functional.
  • Gathered Business requirements for Integration points and mapped them with Functional requirements.
  • Gathered data and business requirements from end users and management.
  • Worked on Data Quality Controls and Business Requirements Document.
  • Analyzed the user/business requirements and functional specs documents.
  • Gathered and documented business requirements for business users.
  • Drafted test cases to be executed by the business users during validation of the data requirements and business requirements.
  • Provide the business requirements for CBA system changes and new or updated system processes for information technology departments.
  • Gathered business requirements from SME's and created Logical Data Models which meet the business requirements.
  • Created and executed detail function Test Scripts and Test cases based on the business requirements.
  • Work closely with various financial and mortgage business teams in gathering the business requirements.
  • Interacted with vendors, developers and customers to manage the business requirements.
  • Interacted with Subject Matter Experts & End Users and gathered business requirements.
  • Interacted with computer systems end-users and project business sponsors to determine, document, and obtain signoff on business requirements.
  • Documented Business Requirements Document (BRD) and Functional Requirements Document (FRD).
  • Documented business requirements with wireframes and mockups to explain in detail the business implications and impacts.

Show More

13 Business Requirements Jobs

No jobs at selected location

3. Database

demand arrow
high Demand
Here's how Database is used in Senior Data Analyst- jobs:
  • Worked with data architects and database administrator on physical model designs for multiple environments.
  • Updated departmental standard operating procedures and database to accurately reflect the current practices.
  • Organized response data, which created migration events with unbroken application/database dependencies.
  • Developed databases for web application development and platform independent.
  • Ensured minimal disruptions of interconnected applications and databases.
  • Managed and supervised the migrated a legacy data in to new database structure to comply with current data and security standards.
  • Served as database manager and trainer for the online Unusual Occurrence and Medication Error reporting for three central Ohio hospitals.
  • Provided training workshops to GE that enabled them to provide required details of applications, servers, and databases.
  • Performed database validation according to the business logic by comparing the source to the target.
  • Acted as database architect designing databases based on user and business needs and goals.
  • Document resolution to all 9-1-1 issues using original paperwork or in appropriate database.
  • Developed and implemented the Central Marketing Database (CMD) project.
  • Tuned oracle 12c databases for the better performance.
  • Call upon sources already established in our database.
  • Report any unresolved database maintenance issues to supervisor in a timely manner.
  • Delivered analysis for a large number of application/database server migrations to GE.
  • Implemented automate monitoring scripts Implemented database refresh scripts.
  • Involved in emitting processed data from Hadoop to relational databases or external file systems using SQOOP, HDFS GET or CopyToLocal.
  • Developed SQLQueries to fetch complex data from different tables in remote databases using joins, database links and Bulk collects.
  • Major Achievements: Managing multiple Databases with hands on involvement.

Show More

63 Database Jobs

No jobs at selected location

4. ETL

demand arrow
high Demand
Here's how ETL is used in Senior Data Analyst- jobs:
  • Worked along with ETL team for documentation of transformation rules for data migration from OLTP to warehouse for purpose of reporting.
  • Assigned as ETL developer for Sales reporting project in which quality and monthly performance was reported to senior management.
  • Lead the project(s) independently and communicate with Business Analysts, ETL developers and QA team.
  • Resolved issues rose by ETL and testing teams while development and testing phase of the project using HPALM.
  • Created new ETL process to extract, transform and load data from different sources to data ware house.
  • Scheduled ETL packages using SQL Server Agent to run on different schedules for different environments.
  • Tested the ETL process for both before data validation and after data validation process.
  • Developed separate test cases for ETL process (Inbound & Outbound) and reporting.
  • Consulted and trained 10+ analysts on use of SPSS modeler and ETL processes.
  • Design Extract Transform load (ETL) procedures for data import and Manipulation.
  • Collaborated with ETL developers in the creating the Data Functional Design documents.
  • Designed and implemented data integration modules for Extract/Transform/Load (ETL) functions.
  • Reviewed high-level design specification, ETL coding and mapping standards.
  • Experience with various ETL, data warehousing tools and concepts.
  • Utilize ETL techniques to transform underlying data.
  • Coordinated data profiling/data mapping with business subject matter experts, data architects, ETLdevelopers, and data modelers.
  • Designed, developed, tested, and implemented redesign of General Ledger Datamart to significantly reduce ETL load times.
  • Participated in the full lifecycle of ETL software development - analysis, design, documentation and testing.
  • Designed and developed ETL processes using Informatica ETL tool for dimension and fact file creation.
  • Created various Physical Data Models based on discussions with DBAs and ETL developers.

Show More

5. Data Analysis

demand arrow
high Demand
Here's how Data Analysis is used in Senior Data Analyst- jobs:
  • Reformulated many attributes and relationships in the reverse engineered model and cleansed unwanted tables/ columns as part of data analysis responsibilities.
  • Performed all data modeling, data analysis and gap analysis as well as database and SQL tuning.
  • Created pivot tables and charts and Analytic reporting using worksheet data and external resources for data analysis.
  • Involved in data analysis and creating data mapping documents to capture source to target transformation rules.
  • Performed data analysis, Statistical Analysis, generated report, listings and graphs using SAS tools.
  • Worked on Front end Java applications for data analysis and providing results to Business users.
  • Coordinated the data analysis and reporting (SAS) of Phase I-IV clinical trials.
  • Used SQL to perform data analysis, data profiling and generating reports.
  • Performed data analysis using PL/SQL, SQL from source.
  • Write custom queries and reports for data analysis.
  • Used Microsoft SQL to perform data analysis.
  • Worked on SAS for Data Analysis.
  • Provided data analysis and test support for migration of Comcast's manually-managed Product Catalog to management system.
  • Create dashboards and reports using SAS, SQL, Excel with pivot tables Supported data analysis for the Radiology Service Line.
  • Involved with Data Analysis Primarily Identifying Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats.
  • Performed data analysis activities (data profiling, creation of data dictionaries, data transformation rules, integration requirements).
  • Performed data profiling and data analysis of source and target systems in Teradata and SQL Server environments.
  • Implemented in depth data analysis on Oracle and Teradata systems.
  • Used SQL and Teradata to perform data analysis.
  • Involved with data analysis using Teradata SQL Assitfrom data source.

Show More

83 Data Analysis Jobs

No jobs at selected location

Job type you want
Full Time
Part Time
Internship
Temporary

6. Teradata

demand arrow
high Demand
Here's how Teradata is used in Senior Data Analyst- jobs:
  • Used TeradataOLAP functions like RANK, ROW_NUMBER, QUALIFY, CSUM and SAMPLE.
  • Involved in database consolidation carried out along with migration between Teradata servers.
  • Developed SQL, BTEQ (Teradata) queries for Extracting data from production database and built data structures, reports.
  • Worked with data modelers and assist them in verifying and validating the relationships between tables using Teradata SQL assistant.
  • Worked with BTEQ to submit SQL statements, import and export data, and generate reports in Teradata.
  • Support data queries as requested by physicians and clinical system engineers in Teradata, SAS, and Tableau.
  • Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.
  • Designed and developed weekly, monthly reports related to the marketing and financial departments using Teradata SQL.
  • Designed Logical and physical data models (Hive and Teradata) using SAP Power designer 16.5.4.
  • Generate DDL scripts for database modification, Teradata, Macros, Views and set tables.
  • Generated the DDL's for Hive and Teradata target tables using Power Designer.
  • Involved in data analysis of the Teradata.
  • Used SQL, SAS, and Teradata to generate queries or reporting based on daily needs or ad hoc requests.
  • Worked on loading data from flat files to Teradata tables using SAS Proc Import and FastLoad Techniques.
  • Used SAS/Interface to Teradata to extract data from Teradata and also used SAS/SQL pass through facility.
  • Created Complex Teradata scripts to generate ad-hoc reports that supported and monitored Day to Day.
  • Developed reports using the Teradata advanced techniques like Rank, Row number and etc.
  • Created conceptual, logical and physical data models in ERwin for Teradata platform.
  • Modify and tune complex Informatica mappings to load the data into Teradata DWH.
  • Ensured ERwin data models and Teradata tables were synchronized and resolved differences.

Show More

2 Teradata Jobs

No jobs at selected location

7. Test Cases

demand arrow
high Demand
Here's how Test Cases is used in Senior Data Analyst- jobs:
  • Developed test cases for User Acceptance Testing, documented the results, and got approvals from the respective Project Managers.
  • Created Target to Source Mapping documents, Test cases for carrying out unit testing and part of functional testing.
  • Performed test cases execution for Business User Validation (BUV) during the client testing phase.
  • Involved in writing Test Cases, procedures, reports and approval of software release.
  • Designed and develops RTM to Verify and validate requirements, test cases and defect.
  • Created test cases for Accounts, Activities, Opportunities, Contacts, and Plans.
  • Create requirements and Test matrix for ETL and Reporting Test cases in Quality Center.
  • Develop test plans and test cases to perform user acceptance and shakeout tests.
  • Write test cases as needed for new reporting tools and website updates.
  • Created Test cases and involved in High Level System and Data Tests.
  • Identified Test cases at Unit level, System level, Enterprise level.
  • Executed and managed test cases and reported bugs in Quality Center.
  • Document and report defects, maintain test cases using HP ALM.
  • Developed business test cases to test the final extract outputs.
  • Created Test Scenarios, Test Cases and Test Matrix.
  • Designed technical documents, use cases and test cases.
  • Maintained all the test cases in HP Quality Center and logged all the defects into the defects module.
  • Documented the Traceability Matrix for tracing the Test Cases.
  • Reviewed ERDdimensionalmodel diagrams to understand the relationships and cardinalities to help in preparation of integrity test cases.
  • Assisted in preparing BRDs, FRDs, and Test Cases.

Show More

8. Informatica

demand arrow
high Demand
Here's how Informatica is used in Senior Data Analyst- jobs:
  • Led implementation of Informatica integration between warehouse and other teams for clean-up and enrichment of data.
  • Extracted ER-Win physical models into repository manager using Informatica Power plug.
  • Scheduled informatica jobs by integrating different process one after another.
  • Supported informatica jobs in production environment.
  • Designed mappings using Informatica coming from different sources like databases, flat files into * Oracle staging area.
  • Created different source definitions to extract data from flat files and relational tables for Informatica Power Center.
  • Worked on Informatica Data Quality tool for data cleansing, conformance and freshness of data.
  • Worked with Informatica Data Quality (IDQ) tool to create data quality rules.
  • Involved in the development and testing of programs, Informatica mappings and update processes.
  • Performed Data Profiling by using SQL and Informatica Data Explorer.
  • Worked with team in analyzing and tuning informatica mappings and sql queries to improve data retrieval and data loading.
  • Work with the data modeler to create Data Mapping specification using Informatica PowerCenter Mapping Architect for Visio.
  • Utilized Informatica Data Quality tool to create data profiling reports to assist in UAT and PPV validation.
  • Involved in POC to validate the performance improvement of Informatica V 9.6 on Nutanix platform.
  • Created, modified and tuned complex Informatica mappings to load the Fiscal Datamart.
  • Developed ETL processes UNIX scripting, DTS, SSIS, Mload, Informatica, etc.
  • Created partitions at Informatica session level to improve the performance of Informatica workflows.
  • Upgraded and Migrated Informatica mappings from Informatica 6.22 to Informatica 8.0.
  • Created informatica workflows, worklets and re-usable sessions.
  • Utilized Informatica toolset (Informatica Data Explorer, and Informatica Data Quality) to analyze legacy data for data profiling.

Show More

3 Informatica Jobs

No jobs at selected location

9. Pl/Sql

demand arrow
high Demand
Here's how Pl/Sql is used in Senior Data Analyst- jobs:
  • Created and modified tables, views and indexes; PL/SQL stored procedures, functions and triggers according to business requirement.
  • Utilized Oracle 9.5 and SQL 2005 to create stored procedures, PL/SQL and views to optimized dashboard performance.
  • Created PL/SQL packages and Database Triggers and developed user procedures and prepared user manuals for the new programs.
  • Designed and Developed Oracle PL/SQL Procedures and UNIX Shell Scripts for Data Import/Export and Data Conversions.
  • Designed and implemented an ETL solution based on PL/SQL procedures in the Oracle Data Warehouse.
  • Developed various bulk load and update procedures and processes using SQL * Loader and PL/SQL.
  • Generated PL/SQL scripts for data manipulation, validation and materialized views for remote instances.
  • Experienced in data analysis using SQL, PL/SQL and many other queries based applications.
  • Generated reports using IT/database systems, PL/SQL procedures, coupled with Crystal Reporting.
  • Involved in PL/SQL code review and modification for the development of new requirements.
  • Designed and Developed PL/SQL procedures, functions and packages to create Summary tables.
  • Involved in database development by creating Oracle PL/SQL Functions, Procedures and Collections.
  • Developed stored procedures and complex packages extensively using PL/SQL and shell programs.
  • Analyzed reported issues in Oracle data warehouse using PL/SQL queries.
  • Supported PL/SQL development for Contingency and Internal Audit Reports.
  • Develop Oracle PL/SQL triggers and procedures.
  • Created SQL, PL/SQL, SQL Loader control files, functions, procedures, and UNIX Shell scripts.
  • Developed complex programs in PL/SQL, writing Stored Procedures, Packages, and Queries with best execution plan.
  • Set up Oracle PL/SQL package to analyze the tables and indexes, recordstables and rebuild indexes.
  • Created multiple PL/SQL Packages and Procedures using DBArtisan.

Show More

10. Unix

demand arrow
high Demand
Here's how Unix is used in Senior Data Analyst- jobs:
  • Created Unix scripts to perform data validation on incoming file, data comparison, archiving files and monthly maintenance.
  • Performed data validation on the flat files that were generated in UNIX environment using UNIX commands as necessary.
  • Extracted data from existing data source and performed Ad-Hoc queries by using SQL, MS Access and UNIX.
  • Tested, qualified and implemented Microsoft, UNIX and Oracle based hardware and software applications.
  • Worked on Unix Shell scripts to load the data from flat files into stage table.
  • Constructed SAS programs on UNIX platform to clean the data according to the specifications.
  • Used the automated process for uploading data in production tables by using UNIX.
  • Grant user access to 5000+ Windows 2000/2003/2008 servers as well as Linux/UNIX servers.
  • Involved in writing as well as testing the UNIX shell scripts.
  • Used putty to communicate with the data on the Unix server.
  • Utilized BTEQ and UNIX automation to generate SQL logs for documentation.
  • Experience in creating UNIX scripts for file transfer and file manipulation.
  • Created Unix Shell Scripts for automating the execution process.
  • Build UNIX shell scripts to automate the ETL processes.
  • Assisted operation support team for transactional data loads in developing SQL&UNIX scripts.
  • Experienced in scheduling the jobs in UNIX using cron-tab and sleep functions.
  • Developed automated scripts in UNIX Shell script.
  • Automated Teradata SQL scripts in Unix.
  • Implemented over 100 new clients using FTP, TCP/IP, Unix and Tandem utilities (Enscribe, Enform, SQL).
  • Enter data documents into a UNIX system Maintained batch integrity and made user corrections Maintained a keystroke average of 11,000 ksphr

Show More

1 Unix Jobs

No jobs at selected location

11. Windows XP

demand arrow
high Demand
Here's how Windows XP is used in Senior Data Analyst- jobs:
  • Used RDP to troubleshoot PC Windows XP Tracked day-to-day activities in lotus notes.

Show More

12. Visio

demand arrow
high Demand
Here's how Visio is used in Senior Data Analyst- jobs:
  • Coordinated across divisions to ensure complex securities were modeled accurately within systems.
  • Created VISIO diagrams in order to give idea for Business Users and for IT team about existing flow.
  • Analyzed the existing business processes, technical architecture and resources in order to determine the business vision.
  • Developed and co-authored the vision document that defined the primary goals and objectives of the project.
  • Work with little supervision and provide weekly status reports
  • Created Visio diagrams for understanding process flow based on business requirements and updated existing process diagram based on enhancement.
  • Determine user/business/functional requirements and produced work flow processes and diagrams using Microsoft Visio and other Microsoft Suite Applications.
  • Collaborated in building a business analysis process model using Rational Rose, RequisitePro, and Visio.
  • Developed use cases from requirements and using Visio to create business and activity process and UI layouts for the assigned projects.
  • Designed Use Case Diagrams, Data Flow Diagrams and Activity Diagrams using MS Visio to further refine the requirements.
  • Analyzed and segregated business requirements into high level and low level Use Cases, using MS Visio.
  • Created Visio diagrams to explain various flows of the data in complex series of servers.
  • Used MS Visio for flow-charting, process model and architectural design of the application.
  • Created business flow documents with Visio for the planning team.
  • Project Technologies/ Products: Visio, Excel
  • Used MS Word & Visio to document data flow of the AS IS process and TO BE process.
  • Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams, Dataflow Diagrams and Conceptual Data Models in MS Visio.
  • Designed Logical/Physical and Conceptual models of database using ERwin and VISIO * Did extensive reverse engineering of databases using ERwin.
  • Project Technologies/ Products: Agile, XML, Visio, Axure Sogeti USA LLC
  • Analyzed statistical data using Quantros Dr. Q, AS400, Cerner Invision and Cerner Powerchart to evaluate patient care data.

Show More

10 Visio Jobs

No jobs at selected location

13. Metadata

demand arrow
high Demand
Here's how Metadata is used in Senior Data Analyst- jobs:
  • Involved in maintaining and updating Metadata Repository with details on the nature and use of applications/data transformations to facilitate impact analysis.
  • Authored a corporate standard for metadata definitions, a corporate metadata policy and a Standard Operating Procedure for Data Modelers.
  • Involved in updating metadata repository while detailing on use of applications and data transformation to facilitate impact analysis.
  • Developed and maintained data dictionary to create metadata reports for technical and business purpose.
  • Utilized tools to efficiently build data models and maintain metadata and data model repository.
  • Obtained metadata whenever available in order to define and understand data extracts.
  • Developed and maintained metadata and metadata management strategies for the data model.
  • Involved in maintenance of models and loading models to Metadata Repository.
  • Provided metadata expertise for revenue and volume reporting.
  • Uploaded design data to the Enterprise Metadata Repository.
  • Created Data Definitions and help maintain Metadata repository.
  • Maintained metadata(data definitions of table structures) and version controlling for the data model.
  • Design and develop the Data dictionary and Metadata of the models and maintain them.
  • Performed data auditing, validation and cleansing as well as metadata mapping and migrations.
  • Create various Data Mapping Repository documents as part of Metadata services (EMR).
  • Used Business Objects for validating the metadata and testing the data of reports.
  • Developed and maintained the central repository, populated it with the metadata.
  • Created and maintained Metadata, including table, column definitions.
  • Managed a multi-phase project to improve metadata definition quality and trained users in the definition certification process.
  • Used Meta data tool for importing metadata from repository, new job categories and creating new data elements.

Show More

37 Metadata Jobs

No jobs at selected location

14. Toad

demand arrow
high Demand
Here's how Toad is used in Senior Data Analyst- jobs:
  • Test and analyze stored procedures and triggers using Toad, and other database tools resulting in accurate and efficient data processing.
  • Manage the data by using ATG BCC tool and generate the reports as per the business requirements by using TOAD.
  • Perform Data Integration, Data comparison and Data Validation for Back End Testing by using SQL Queries (TOAD).
  • Developed SQL queries in SQL Server management studio, Toad and generated complex reports for the end users.
  • Experience with Oracle SQL and PL/SQL programming and used Database utility programs like TOAD and SQL Navigator.
  • Created scripts to create new tables, views, queries for enhancements in the application using TOAD.
  • Experienced using database query and integration tools such as TOAD, SQL plus etc.
  • Write and execute SQL queries using SQL developer, TOAD, Microsoft SQL Server.
  • Used TOAD to view Database Objects, view and develop Database Scripts.
  • Worked on enhancing and monitoring SQL Queries using TOAD.
  • Performed manual testing using toad on Enterprise Database.
  • Used the following tools: CA/ERWIN, Quest/TOAD; Oracle RDBMS.
  • Used TOAD Software for Querying ORACLE.
  • Used SQL tools like Teradata SQL Assistant and TOAD to run SQL queries and validate the data in warehouse.
  • Involved in extensive Data Analysis on the Teradata and Oracle Systems querying and writing in SQL and TOAD.
  • Used ETL methods on metadata between MS Access, MS Excel, TOAD, and Unica applications.
  • Performed Data modeling for an existing Databases using Toad Data Modeler and ER Studio.
  • Used TOAD GUI tool for querying oracle database.
  • Design and Develop Workflow for job automation in Toad Datapoint 3.3.
  • Architected and designed high speed and fast response star schema for eCommerce Multi-tenant on-demand Data model using Toad Data modeler.

Show More

15. Dashboards

demand arrow
average Demand
Here's how Dashboards is used in Senior Data Analyst- jobs:
  • Designed, developed and published customized interactive reports /dashboards and scheduled data refreshes for reports in Tableau Server.
  • Generated tableau dashboards for participation data with forecast and reference lines.
  • Generated guided navigation links for Interactive dashboards in Tableau.
  • Prepared and published customized reports/dashboards.
  • Develop, design and maintain a suite of distribution, sales and marketing QlikView dashboards using data from the Data Marts.
  • Designed and Developed Complex Active reports and Dashboards with different data visualizations using Tableau desktop on Sales, Finance data.
  • Analyzed and gained understanding of the underlying data and generated tableau dashboards with forecast and reference lines.
  • Build dashboards using Tableau and demonstrate to upper management of both Blue449 and the client.
  • Created different Action filters, Parameters and calculated fields to create most complicated dashboards.
  • Develop in Hyperion Performance Suite 9.3 to create and automate Java scripted interactive dashboards.
  • Tested several dashboards and deployed them across the organization to monitor the performance.
  • Combined visualizations into Interactive Tableau Dashboards and published them to the web portal.
  • Experience working with Tableau, development of dashboards and publishing the reports.
  • Developed Tableau dashboards pertaining to Revenue and Sales monitoring using Tableau 8.x.
  • Communicated testing progress and findings in dashboards and scrums.
  • Enabled Usage Tracking Table and Dashboards.
  • Created complex SQL queries for reports, metrics and KPI's (dashboards).
  • Experience in Tableau Dashboards in latest Design and Presentation.
  • Develop and deploy Dashboards with the use of Cognos.
  • Involved in modifying Teradata stored procedures and performance tuning of various Teradata/Oracle tables to improve the performance of Tableau reports/Dashboards.

Show More

46 Dashboards Jobs

No jobs at selected location

16. SAS

demand arrow
average Demand
Here's how SAS is used in Senior Data Analyst- jobs:
  • Created departmental SAS programming standards document and made presentation to departmental staff.
  • Created Source to target Mapping Matrix for the ETL developers in loading the data to Dimensions and Fact Tables using SAS.
  • Involved in development and implementation of SSIS, SSRS and SSAS application solutions for various business units across the organization.
  • Updated SAS information tables using interactive SAS and PROC FSEDIT to accommodate continuing changes in user requirements.
  • Create reports (Access, Excel, SAS) to present findings to upper level management.
  • Develop SAS Enterprise Guide queries on IMS/SHS syndicated physician and account level data for investigation purposes.
  • Maintained SAS and MS Excel files denoting AAA branch management alignments in eight-state ACG region.
  • Managed up to five SAS analysts and one Contract Research Organization (CRO).
  • Developed complex SAS macros to simplify SAS code and effectively reduce coding time.
  • Used SAS procedures to achieve the required data analysis and for data transformations.
  • Used SAS EG extensively for data analysis and involved in writing macros.
  • Provided SAS and mainframe training to coworkers and in-house clients.
  • Served as team leader for disaster recovery.
  • Extracted data from disparate sources by SAS/ACCESS.
  • Utilized SAS and FastLoad for loading large flat files into Teradata for purposes of audit validation and testing.
  • Use tools including SAS, SPSS, Clementine and Microsoft Access to analyze multiple data sources.
  • Produced Ad Hoc report requests within SAS programming, Midas and TSI.
  • Transitioned from SAS to R, Hadoop, AWS & internal clusters.
  • Created and manipulated datasets using SAS, Access, and Excel.
  • Created ad-hoc and ongoing reports at user request, primarily involving mainframe programming in SAS, Easytrieve, and Quikjob.

Show More

44 SAS Jobs

No jobs at selected location

17. Tableau Server

demand arrow
average Demand
Here's how Tableau Server is used in Senior Data Analyst- jobs:
  • Worked extensively on data visualizations by designing, developing and deploying of Tableau dashboards on Tableau server.
  • Designed and implemented near-real-time monitoring Dashboards for Tableau Server and Visualization users.
  • Designed and Optimized Connections, Data Extracts, Schedules for Background Tasks and Data Refreshes for corporate Tableau Server.
  • Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.
  • Implemented various data connections from data source to Tableau Server for report and dashboard development.
  • Published the dashboard reports to Tableau Server for navigating the developed dashboards in web.
  • Automated these reports in Tableau server using its strong feature of scheduling and authenticating.
  • Background in installing and upgrading of Tableau server and server performance tuning for optimization.
  • Published these dashboards on the Tableau Server and scheduled them to run Daily.
  • Created Backup scripts to take periodic backups for the content on Tableau server.
  • Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
  • Involved in installation of Tableau desktop 7.0, Tableau server Application software.
  • Published data sources to the tableau server and setting up access permissions.
  • Scheduled the published dashboards from Tableau Server on weekly basis.
  • Created incremental refreshes for data sources on Tableau server.
  • Deployed reports onto Report Server and Tableau Server.
  • Published dashboards to Tableau server.
  • Configure Tableau Server for Failover and high availability.
  • Worked on creation of users groups projects workbooks and the appropriate permission sets for Tableau server logons and security checks.
  • Created reports in Tableau Server and Excel with Homecare Homebase (EMR) data.

Show More

3 Tableau Server Jobs

No jobs at selected location

18. Ssis

demand arrow
average Demand
Here's how Ssis is used in Senior Data Analyst- jobs:
  • Provide assistance to co-workers and management.
  • Assist with user testing of systems, developing and maintaining quality procedures, and ensuring that appropriate documentation is in place.
  • Assist in implementing customary changes in licensing requirements based on changes in laws, regulations, or company policies.
  • Assisted in designing test plans, test scenarios and test cases for integration, regression and user acceptance testing.
  • Worked with internal architects and, assisting in the development of current and target state enterprise data architectures.
  • Assist in the assessment, acquisition, or deployment of new electronic document management systems.
  • Assisted the users in UAT testing by providing test scenarios and test data.
  • Created SSIS/ETL packages for Incremental Loads/Full Refresh Loads using Merge Statements/Stored Procedure.
  • Performed unit testing while developing the SSIS/SQL code in DEV/QA/SIT/UAT environments.
  • Assisted chemists with searching ancillary chemical data stored in Oracle tables.
  • Assist department personnel with problem resolution, trouble shooting and support.
  • Generated the DDL and assisted in designing the overall ETL strategy.
  • Created TWS Maestro jobs/schedules to execute SSIS packages on daily/weekly basis.
  • Created run books for SSIS/ETL development for the Production Support team.
  • Migrated MSSQL 2000 DTS packages to MSSQL 2005 SSIS ETL processes.
  • Used SSIS for data Integration and Workflow application for getting the information from different health care providers.
  • Assisted in design of detail HR Datamart to provide HR department with a significantly more robust solution.
  • Assisted with DBAs on support needs and provide guidance on architectural issues.
  • Experience in Teradata SQL Assistant and Toad.
  • Created ad hoc Excel reports using AQT and SSIS/ETL script task on runtime.

Show More

16 Ssis Jobs

No jobs at selected location

19. DB2

demand arrow
average Demand
Here's how DB2 is used in Senior Data Analyst- jobs:
  • Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the DB2 Data Marts.
  • Experience in supporting team for 24 x 7 on call for any DB2 issue and able to create ticket resolution.
  • Extracted data from DB2 tables and analyzed data to find any anomalies with the help of SQL & excel.
  • Developed complex SQL queries from SQL Server and DB2 databases utilizing multiple joins, functions, tables and views.
  • Lead conversion data analyst in porting new DB2 instances to Oracle 9i for reporting and data modeling.
  • Designed the Data-Model using various data sources like Oracle 10g/DB2 Database, XML and Excel Sheets.
  • Worked on SQL, to make users to obtain data simultaneously from DB2 and other databases.
  • Researched and repaired DB2 system of record caused by rollbacks, outages, and program errors.
  • Formulated data analysis procedures and reports in Access, SQL Server, Oracle, and DB2.
  • Produced PL/SQL statement and stored procedures in DB2 for extracting as well as writing data.
  • Worked on DB2 in designing to store, analyze and retrieve the data efficiently.
  • Created 35-40 ETL packages - extraction from flat files, Excel files, DB2 and loaded data to SQL Server.
  • Used RAPID SQL Software for Querying DB2.
  • Extracted data from Oracle and SQL Server and DB2 using Informatica to load it into a single data warehouse repository.
  • Source systems include Oracle Financials 11i / 12 and Legacy systems within SQL-Server, DB2, UDB/DB2 and VSAM environments.
  • Migrated many databases from DB2 database to Oracle 8.1.7.4. on an IBM AIX platform.
  • Architected and supported Oracle and DB2/VM databases using data modeling tools/techniques.
  • Source - ODS on Oracle Target - iSeries DB2/400.
  • Performed extensive Data Analysis and Data Validation on different systems like Teradata, Netezza and DB2.
  • Provided product sales data with adhoc queries from several different data sources SQL and Midas Data Teradata DB2 oracle warehouse.

Show More

20. Schema

demand arrow
average Demand
Here's how Schema is used in Senior Data Analyst- jobs:
  • Utilized Erwin's forward/reverse engineering tools and target database schema conversion process.
  • Developed and designed Data marts extensively using Star Schema.
  • Developed the data warehouse model (star schema) for the proposed central model for the Project.
  • Star schema was developed for proposed central model and normalized star schema to snow flake schema.
  • Created a data model (star schema) for the sales data mart using Erwin tool.
  • Designed a STAR schema for the detailed data marts and plan data marts involving confirmed dimensions.
  • Assembled Facts and Dimensions from the Enterprise Architecture for designing the Star/Snowflake Schema.
  • Generated the physical database schema from the data model and built DDL scripts.
  • Created schema objects like tables, views, synonyms, and store procedures.
  • Developed in Star and Snow flake schema dimensional data models.
  • Created XML Schema Definition for interfacing between multiple systems.
  • Designed Data Mart application utilizing the Star Schema Dimensional Ralph Kimball methodology.
  • Experienced in Data Transformation and Data Mapping from source to target database schemas and also data cleansing.
  • Developed Star and Snowflake schemas based dimensional model to develop the data warehouse.
  • Designed the data marts in dimensional data modeling using star and snowflake schemas.
  • Translated business concepts into XML vocabularies by designing XML Schemas with UML.
  • Synchronized data and schemas for development, test and production environments.
  • Designed star schemas and bridge tables to control slowly changing dimensions.
  • Designed star schemas and bridge tables.
  • Created dimensional model based on star schemas and designed them using ERwin.

Show More

5 Schema Jobs

No jobs at selected location

21. Source Systems

demand arrow
average Demand
Here's how Source Systems is used in Senior Data Analyst- jobs:
  • Provided application enhancement and upgraded support, including any re-engineering due to changes of file and table structure of source systems.
  • Attended the change data management control board meetings for accommodating the enhancements to the warehouse based on the source systems upgrade.
  • Developed the required data warehouse model (SQL Server) using Star schema for the data repository from source systems.
  • Worked with data source systems and Client systems to identify data issues, data gaps, identified and recommended solutions.
  • Created ETL jobs and custom transfer components to move data from oracle source systems to SQL Server using SSIS.
  • Involved in implementing the Land Process of loading the customer/product Data Set into MDM from various source systems.
  • Resolved the data type inconsistencies between the source systems and the target system using the Source-to-Target Mapping Documents.
  • Identify source systems, their connectivity, related tables and fields and ensure data suitably for analysis.
  • Prepared the ETL mapping specifications to extract data from the existing source systems to the Data marts.
  • Define the list codes and code conversions between the source systems and Master Data Repository.
  • Worked as data analyst to figure out data discrepancies between warehouse and source systems.
  • Walked through the Logical Data Models of all source systems for data quality analysis.
  • Define the list codes and code conversions between the source systems and MDR.
  • Helped with Data Mapping between the data mart and the Source Systems.
  • Performed data profiling in the source systems that are required for financing.
  • Analyzed the source systems and created Business Requirement Document (BRD).
  • Created STTM documentation for data mart integrating different source systems.
  • Facilitate meetings with business, source systems and developers.
  • Worked on data mapping for various source systems.
  • Used Informatics power center for (ETL) extraction, transformation and loading data from heterogeneous source systems.

Show More

9 Source Systems Jobs

No jobs at selected location

22. User Acceptance

demand arrow
average Demand
Here's how User Acceptance is used in Senior Data Analyst- jobs:
  • Performed user acceptance testing and documented detailed results.
  • Conduct User Acceptance Testing of tagging requirements using browser tools, analyzing network traffic and server calls to Adobe and WebTrends.
  • Identified and developed quality management plans, test scenarios, and test scripts for user acceptance based on system requirements.
  • Performed Functional Testing, Smoke Testing, Integration Testing, System testing, User acceptance testing and Regression Testing.
  • Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance Testing.
  • Involved in development and enhancements of SAS Programs for user acceptance and generating reports, tables and listing.
  • Conducted User Acceptance testing (UAT) and worked with users and vendor who build the system.
  • Involved in the User acceptance Testing (UAT) and documented the test scenarios and outcomes.
  • Interacted with end users to obtain specific system requirements for User Acceptance Tests (UAT).
  • Involved in user training sessions and assisting in UAT (User Acceptance Testing).
  • Involved in Regression, Functional, Integration, System Testing and User Acceptance Testing.
  • Performed extensive Integration and User Acceptance Testing of the re-designed Payroll Interface program.
  • Performed User Acceptance Testing during the BDW Forklift to end-state table conversions.
  • Supported the User Acceptance Testing during the implementation phase of the project.
  • Collaborated with User Groups to lead or support User Acceptance Testing.
  • Deployed Tableau dashboards in production after user acceptance test clearance.
  • Involved in the user acceptance testing (UAT).
  • Performed user acceptance and shakeout tests.
  • Worked with the users to do the User Acceptance Testing (UAT).
  • Involved in System Testing and User Acceptance Testing .

Show More

2 User Acceptance Jobs

No jobs at selected location

23. XML

demand arrow
average Demand
Here's how XML is used in Senior Data Analyst- jobs:
  • Worked extensively with XML schema generation.
  • Worked on different data formats such as Flat files, SQL files, Databases, XML schema, CSV files.
  • Detailed XML and SQL analysis to identify data discrepancies between the newly designed application and legacy data.
  • Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.
  • Project Technologies/ Products: Microsoft Office Technologies, Microsoft TFS, VersionOne, Excel, XML
  • Modify XML XSD schema files with Oracle XDB annotations to generate types and tables.
  • Designed SQL DTS packages, project plans, development plans, and XML import/export.
  • Created the XML control files to upload the data into Data warehousing system.
  • Developed XML mapping for ETL team for the transformation and loading.
  • Developed programs to produce XML files for data transfer to other systems
  • Read and test XML web service interface files and reports.
  • Create XML documents for delivering loan information to other parties.
  • Learned XML editing tools such as Epic and XMAT.
  • Produced XML file to import into the vendor-hosted system.
  • Developed XML Schema according to client's requirements.
  • Web Application Development with JSP and XML.
  • Used XML extensively for stored procedures.
  • Worked on Data Extraction, Transformation, and Loading with RDBMS, Flat files and XML sources using SAP BODS 4.0.
  • Worked with different types of Sources like XML files, DB Tables, Flat Files, and Destinations like DB Tables.
  • Stored reformatted data from relational, flat file, XML files using Informatica.

Show More

2 XML Jobs

No jobs at selected location

24. BI

demand arrow
average Demand
Here's how BI is used in Senior Data Analyst- jobs:
  • Captured and elicited all requirements and report specifications for a Business Intelligence initiative utilizing Oracle (OBIEE).
  • Conducted performance optimization for BI infrastructure.
  • Served on the Stability Process Enhancement Team, to evaluate and recommend changes to the management and processing of stability data.
  • Combine and compare rebate data from multiple sources in order to investigate the discrepancies between the requested rebate and actual rebate.
  • Supported the analysis, and tabular and graphical presentation (SAS) of stability data for special projects.
  • Organized billing and invoice data and prepared accounts receivable and expected revenue reports for controllers.
  • Worked with Data Quality and ETL teams as part of my job responsibilities.
  • Key Responsibilities/Achievements Perform role of a hands-on Lead data architect & analyst for a newly established Group Data Architecture effort.
  • Mapped business process with chain value to establish process flow and gaps within the interoperability and inter-agency protocol.
  • Introduced direct SQL querying into operational and financial data allowing near-realtime simulation and update capability.
  • Created ad-hoc models for portfolio risk simulation, commission structure changes, new product profitability, collections, and operations.
  • Maintained expertise in the MPP / Hadoop / Big Data ecosystem, including industry trends, strategies, and products.
  • Developed STIAS II a travel behavior analysis tool based GPS and mobile phone data;
  • Designed dashboards and completed ETL mappings utilizing Oracle Business Intelligence Analytics (OBIA).
  • Managed Traceability matrix to trace Business Requirements, Functional Requirements, and Use Cases.
  • Executed large datasets by combining information from a multitude of sources for audits.
  • Job Responsibilities: Work on Commercial line property insurance in Agile methodology.
  • Established data pipeline and process workflow for streamlining in silico insights to 'wet' biological experimentation.
  • Key driver of investment decisions for multi-billion annual datacenter capital spend.
  • SAP BOBJ: Maintain multi-purpose BOBJ Universe, develop and service 13 Webi reports based on that Universe.

Show More

109 BI Jobs

No jobs at selected location

25. Ssrs

demand arrow
average Demand
Here's how Ssrs is used in Senior Data Analyst- jobs:
  • Create summary and detail reports for client using SSRS and transfer results to graphic form in Visual Studio 2008.
  • Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
  • Support existing report process and develop new SSRS / Crystal reports to support the Financial Services Team.
  • Design and develop stored procedures, views, and MDX queries necessary to support SSRS report.
  • Create custom reports in SSRS for monitoring of nightly data loads of client data.
  • Developed reports in SSRS against Epic s Clarity database and providing those reports to end
  • Created reports in Tableau using SSRS SQL Queries and Stored procedures.
  • Used SQL Server Reporting Services (SSRS) to create reports.
  • Validated various SSIS and SSRS packages according to functional specifications.
  • Used SSRS for database reporting in Microsoft SQL server 2005.
  • Automated SSRS report delivery for internal and external clients.
  • Created reports from data warehouse using SSRS i.e.
  • Developed several Microsoft SSRS Reports and SSIS Routines.
  • Converted SSRS and MicroStrategy reports into Tableau.
  • Converted Crystal reports into SSRS reports.
  • Create and deploy reports using SSRS.
  • Developed, refined sophisticated reports using SSRS & MS Access in real-time iterative fashion & handed reports to auditors.
  • Designed Policy Hierarchy dimensions and Loss Hierarchy dimensions to handle reporting through SSRS (Sql Server Reporting Service).
  • Developed and created dashboards and ad hoc reports utilizing SQL, SSRS and MS Access/Excel tools.
  • Created Various AD-Hoc Reports as per Business User request in MS SQL SSRS 2008.

Show More

6 Ssrs Jobs

No jobs at selected location

26. QA

demand arrow
average Demand
Here's how QA is used in Senior Data Analyst- jobs:
  • Migrated repository objects, scripts from development environment to QA and Production environment.
  • Coordinated all QA activities and enhancements using Agile Methodology.
  • Collaborated with operations, client services, development and QA teams to explain anomalies and variance in data and process.
  • Participated in M-CARE's activities to meet the accreditation requirements of the National Committee on Quality Assurance (NCQA).
  • Created the test data validation scenarios for QA team based on the Data requirements for the various ACO -calculations.
  • Worked closely with the QA Team to review and enhance the Test Plan and Test Cases.
  • Provided statistical programming expertise in the production of QA analyses, tabulations, reports and listings.
  • Analyzed & resolved 3rd level escalations & regular defects identified by customers and QA team.
  • Assisted QA and BA teams with Data requirements and Defect investigation in testing phase.
  • Interacted with the Business Analyst, QA team in their testing and DBA's.
  • Analyze, audit, QA, and maintain the data of existing reports.
  • Designed and implemented SQL queries for QA Testing and Report / Data Validation.
  • Collaborate with data warehouse QA team to ensure seamless execution of test cases.
  • Documented Test Cases and assisted the QA Team with the Test Plans.
  • Participated in Project Status meetings and updated QA status and defect status.
  • Worked as a project coordinator to coordinate between QA Testers and users.
  • Migrated projects from development to QA to Production environments.
  • Worked as QA in the team for testing the Microstrategy reports data Vs databases (Source and Target).
  • Worked extensively with the Dev and QA teams to plan and execute the releases.
  • Team consisted of 14 QA Analysts; 11 offshore 3 onsite.

Show More

27. UAT

demand arrow
average Demand
Here's how UAT is used in Senior Data Analyst- jobs:
  • Defined common evaluation criteria and recommendations for each country's yearly quality plan.
  • Find data inconsistencies and report them to senior employees and follow through to make sure they are adequately logged and addressed.
  • Developed UAT testing as requested by the business support team after new patches were implemented to enhance the business usage.
  • Led the evaluation, selection, and implementation of Mega as both an Information Repository and a modeling tool.
  • Analyze, evaluate and manipulate data content to ensure quality and compliance before going to next production levels.
  • Review test plans and test cases completed by Quality Assurance team and provide support during SIT and UAT.
  • Reviewed user test cases, defects and validated test results during user acceptance testing (UAT).
  • Coordinate with UAT team for creating additional test scenarios based on data model and other knowledge.
  • Facilitated in developing testing procedures, test cases and User Acceptance Testing (UAT).
  • Assess the data for completeness and unexpected fluctuations in volume, or any anomalies.
  • Assisted in the production and generation of the Undergraduate Summer Program Schedule of Classes.
  • Performed UAT on the Data Marts and validated the models against the business requirements.
  • Provided leadership in the evaluation of external vendor information needs for CDW business partners.
  • Evaluate document results using reports and tools to ensure data quality.
  • Conducted several UAT sessions with Business people.
  • Help drive business UAT testing effort.
  • Worked on Data Verifications and Validations to evaluate the data generated according to the requirements is appropriate and consistent.
  • Evaluated and recommended new tools and analytical approaches to enhance team capabilities.
  • Maintained classroom assignments for undergraduate summer courses and processed reservation request for the Wiegand Teleconference Room throughout the year.
  • Conducted meetings with business users to strategize UAT validation and its timeline.

Show More

2 UAT Jobs

No jobs at selected location

28. Oltp

demand arrow
average Demand
Here's how Oltp is used in Senior Data Analyst- jobs:
  • Developed normalized Logical and Physical database models to design OLTP system.
  • Determined data migration strategy from OLTP systems based on business requirements.
  • Designed robust data models using Erwin for Data Warehouse/Data Mart development, OLTP and Business Intelligence (BI) applications.
  • Lead enterprise logical data modeling project (in third normal form) to gather data requirements for OLTP enhancements.
  • Worked with OLTP to find the daily transactions and type of transactions occurred and the amount of resource used.
  • Collaborated closely with OLTP developers to identify and monitor system changes and upgrade impacts on data and reports.
  • Enforced referential integrity in the OLTP data model for consistent relationship between tables and efficient database design.
  • Project involved maintenance of existing OLTP databases as well as designing SSIS packages for custom warehousing needs.
  • Involved in the data analysis and database modeling of both OLTP and OLAP environment.
  • Implemented and supported OLTP and data warehouse data stores in development and production.
  • Involved in Migrating the data model from OLTP to oracle database.
  • Involved in extracting the data using SSIS from OLTP to OLAP.
  • Designed logical and physical data models for multiple OLTP applications.
  • Involved in the redesign of the existing OLTP system.
  • Applied the normal forms on the OLTP database.
  • Write PL/SQL code and maintain OLTP/OLAP Oracle 10g/11g data structure/architecture Create packages, stored procedures, triggers, indexes, etc.
  • Created Informatica mappings to migrate data from various OLTP servers/databases.
  • Performed OLAP and OLTP data modeling, used ERWin.
  • Created the data models for OLTP and Analytical systems.
  • Used E.F Codd'sNormalization(1NF, 2NF & 3NF) and Demoralization techniques for effective performance in OLTP and OLAP systems.

Show More

29. Sharepoint

demand arrow
average Demand
Here's how Sharepoint is used in Senior Data Analyst- jobs:
  • Planned SharePoint collaboration procedures for internally and externally produced documents.
  • Monitored process by usage of tools Test Director and SharePoint to enter and retrieve progress information in reference to the implementation.
  • Manage on-line Analytic Requests system in SharePoint 2010 as a team ticket system to improve operational efficiency and transparency.
  • Blended data from multiple Grain IT sources into central Excel data entry sheet for upload into SharePoint 2013.
  • Documented and placed all the methodologies for end user reference in SharePoint and TFS.
  • Profiled and defined data to be added to SharePoint List in SharePoint 2013.
  • Designed and developed financial reports, deployed reports to MS SharePoint 2007.
  • Created and maintained business unit, operations & policy SharePoint sites.
  • Identify, create and communicate Issue and Risk using Microsoft SharePoint.
  • Deployed all the reports and documents to SharePoint and TFS.
  • Report, schedule and publish project status on SharePoint.
  • Migrated and Integrated SSRS report with SharePoint 2007/2010.
  • Project Technologies/ Products: SharePoint 2013, TFS
  • Uploaded all artifacts on SharePoint.
  • Created connectivity to SharePoint workflows and financial information to generate monthly activity financial reports.
  • Designed workflows and allocated permissions within SharePoint.
  • Managed and logged defects in Application Lifecycle Management (ALM) and SharePoint that are found during UAT and PPV validations.
  • Participated in User Acceptance Testing Environment: Guidewire, Oracle, SQL, Microsoft Office suite, Business Objects, SharePoint
  • Maintained the SharePoint Team sites with latest Documentation available from different Teams.
  • Quest Stat, Sharepoint, sftp.

Show More

30. Olap

demand arrow
low Demand
Here's how Olap is used in Senior Data Analyst- jobs:
  • Experienced in generating and documenting Metadata while designing OLTP and OLAP systems environment.
  • Developed dimensional model for Data Warehouse/OLAP applications by identifying required facts and dimensions.
  • Moved data from Oracle OLTP to OLAP (Data warehouse) Databases by creating jobs for custom transfer using ETL tools.
  • Translated business requirements into working logical and physical data models for Data warehouse, Data marts and OLAP applications.
  • Developed Source to Target Data Mapping, Data Profiling, Transformation and Cleansing rules for OLTP and OLAP.
  • Worked with data warehousing group to get all the cleaned up data into OLAP controlled data mining systems.
  • Worked on Conceptual, Logical Modeling and Physical Database design for OLTP and OLAP systems.
  • Developed ETL packages to extract data from OLTP database sources to OLAP destinations using SSIS.
  • Generated reports using SQL Server Reporting Services 2005/2008 from OLTP and OLAP data sources.
  • Created Physical Data Model (PDM) for the OLAP application using ER Studio.
  • Worked on designing the OLAP Model/Dimension model for BI Reporting sourcing from SAP.
  • Involved in using different Aggregate and OLAP functions with many derived tables.
  • Handled performance requirements for databases in OLTP and OLAP models.
  • Perform logical and physical OLAP / OLTP schema design.
  • Constructed OLTP and OLAP Databases.
  • Used Normalization (1NF, 2NF&3NF) and De-normalization techniques for effective performance in OLTP and OLAP systems.
  • Designed different type of STAR schemas for detailed data marts and plan data marts in the OLAP environment.
  • Collaborated in Extraction of OLAP data from SSAS using SSIS Worked on Data Stage 8.x parallel version.
  • Involved in designing OLAP Cubes in SSAS environment using snowflake and Star Schemas.
  • Experienced in using OLAP functions like Sum, Count, Csum and etc.

Show More

1 Olap Jobs

No jobs at selected location

31. SQL

demand arrow
low Demand
Here's how SQL is used in Senior Data Analyst- jobs:
  • Design and hand-code complex SQL reports for sales/business development teams, executive management, and pharmaceutical manufacturer clients.
  • Used complex/dynamic TSQL in stored procedures to perform data manipulation.
  • Performed data cleaning and data manipulation activities using NZSQL utility.
  • Involved in extensive data validation with several complex SQL queries and involved in Back-End Testing and worked with data quality issues.
  • Used SQL for querying and analysis purposes on various source tables and conditions applied and Wrote SQL joins, sub queries.
  • Analyze large amount of data using complex SQL queries and provide reports and requested data to the different departments.
  • Self-instructed basic SQL, reduced latency by 35% during data pulls, minimizing system usage.
  • Generated highly-detailed BO and SQL reports involving complex queries, sub queries, Unions and Intersection.
  • Used SQL Server Reporting Services to schedule reports to be generated on predetermined time.
  • Worked on Performance Tuning of the database which includes indexes, optimizing SQL Statements.
  • Performed data mining on data using very complex SQL queries and discovered pattern.
  • Utilized TSQL to create/alter tables, stored procedures, indexes and triggers.
  • Analyzed data using SQL, Excel and other tools.
  • Performed numerous data pulling requests using SQL for analysis.
  • Analyze data through SQL queries and server tools.
  • Performed data validation using complex SQL queries.
  • Generated many datasets according to specifications by writing SQL queries for modeling purposes.
  • Created SQL queries, executed stored procedures, developed & tested database to recover profits by at least 30%.
  • Worked closely with business users, SalesForce team to pull the excel files and then load in SQL server tables.
  • Used SQL on a wide scale for analysis, performancetuning and testing.

Show More

169 SQL Jobs

No jobs at selected location

32. DDL

demand arrow
low Demand
Here's how DDL is used in Senior Data Analyst- jobs:
  • Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model.
  • Coordinated with DBA's and generated SQL code from the data models and generated DDL scripts using forward engineering in ERWIN.
  • Created tables, views, sequences, triggers, table spaces, constraints and generated DDL scripts for physical implementation.
  • Generated the DDL Scripts by forward engineering the physical model and Interacted with the DBA to implement the physical database.
  • Used forward engineering to create DDL from Physical Data Model, based on the requirements from the Logical Data Model.
  • Used forward engineering to generate DDL from the Physical Data Model and handed it to the DBA.
  • Forward Engineering the Physical Model to generate the DDL scripts to implement on Oracle 11g database.
  • Generated DDL Scripts from Physical Data Model using technique of Forward Engineering in Erwin.
  • Created DDL scripts using Forward Engineering in ER/Studio for the PCS internal use.
  • Create data objects (DDL) using forward engineering in Erwin.
  • Direct report to Managing Director of Middle Office Operations.
  • Involved in the generation of DDL and DML scripts.
  • Support DDL scripts for both DB2 and Oracle databases.
  • Created DDL scripts for implementing Data Modeling changes.
  • Created DDL, DML scripts.
  • Generated DDL and worked with DBAs for execution particularly emphasizing on synchronization of data model with database.
  • Created Standard documents for generation DDLs from Erwin Data Modeler via Forward Engineering, Model Merge into the master Data Model.
  • Researched and analyzed foreign business and associations with particular expertise on transfer of funds through Hawala in the Middle Eastern region.
  • Designed star schemas using ER/studio to create DDL scripts for fixed dimensions.
  • Worked with the oltp database to generate the ddl.

Show More

33. ODS

demand arrow
low Demand
Here's how ODS is used in Senior Data Analyst- jobs:
  • Recommend establishment of new or modified reporting/interface methods and procedures to improve report/interface content and completeness of information.
  • Analyzed information using various statistical methods to ascertain patterns in data.
  • Authored methods and procedures that improved profitability through asset cost reduction.
  • Support standards, guidelines, and methods through use of data definitions, diagrams and data modeling tools and techniques.
  • Validated the data of reports by developing SQL queries in SQL Developer against Data Mart tables and ODS.
  • Used Erwin's reverse engineering to connect to existing database and ODS to graphically represent the Entity Relationships.
  • Analyze and format a wide range of data into reports using a variety of different reporting methods/applications.
  • Created Data Migration and Cleansing rules for the Integration Architecture (OLTP, ODS, DW).
  • Identify key business metrics measurements and develop methods to represent data in support of the measurements.
  • Provided root-cause analysis, tracking process, and correction methods for this highly error-prone mapping process.
  • Serve as a social science research methods subject matter expert to senior leadership committees.
  • Discussed file formats and transmissions methods with clients.
  • Used SAS/ODS to generate reports on HTML web format as well as in RTF and PDF.
  • Generated output using SAS/ODS in CSV, XLS, DOC, PDF and HTML formats.
  • Improved data collection and analysis methods and generated new reports for ad hoc and recurring use by internal and external customers.
  • Designed both 3NF data models for ODS, OLTP systems and dimensional data models using star and snow flake Schemas.
  • Used ETL (extract/transform/load) methods on metadata between MS Excel, SQL Developer, and Unica.
  • Used Normalization methods up to 3NF and De-normalization techniques for effective performance in OLTP systems.
  • Entered data accurately and quickly Required to sit for extended periods of time.
  • Utilized simple methods like PowerPoint presentations while conducting walkthroughs with the stakeholders.

Show More

34. DBA

demand arrow
low Demand
Here's how DBA is used in Senior Data Analyst- jobs:
  • Presented and disseminated technical reports and key benchmarks/feedback to key stakeholder and senior leadership.
  • Provided conceptual /functional /business analysis assistance to developers and DBA's using Erwin.
  • Established good practice for test management, continuous feedback integration and delivery of MMF at the end of each Agile Cycle.
  • Involved with DBA group to create Best-Fit Physical Data Model from the Logical Data Model using Forward engineering using Erwin tool.
  • Functioned as the PostgreSQL DBA for the collection of test data for the Reliability Demonstration Test (RDT).
  • Worked very close with Data Architectures and DBA team to implement Data Model changes in database in all environments.
  • Teamed with internal IT department and product development to enhance the claims extend product based on customer feedback.
  • Involved in working with DBA's in assigning the space and privileges for the departmental needs.
  • Worked with DBA's to create a best-fit Physical Data Model from the logical data model.
  • Involved in fine tuning of already existing SQL queries and giving feedback to the developers.
  • Presented data model for review to business and technical teams for feedback and approval.
  • Scheduled database jobs for automation of DBA tasks using SQL Server Agent.
  • Functioned as the SQL Server Application DBA for BI Warehouse.
  • Worked with DBA to create the physical model and tables.
  • Establish DBA standards and procedures to ensure integrity and recoverability.
  • Determined data rules and conducted Logical and Physical design reviews with business analysts, developers and DBAs.
  • Conducted walkthroughs with the DBA to convey the changes made to the data models.
  • Conducted design reviews with the Business Analysts, content developers and DBAs.
  • Leveraged knowledge of data to provide DBAs with performance tuning recommendations.
  • Coordinated with Data Architect, DBAs, Project Controls, Business Analysts and Microsoft Development Team for the deliverables.

Show More

35. Source Data

demand arrow
low Demand
Here's how Source Data is used in Senior Data Analyst- jobs:
  • Conducted source data analysis of various data sources and develop source-to-target mappings with business rules.
  • Performed source data analysis and captured metadata, reviewed results with business.
  • Performed Detailed Data Analysis (DDA), Data Quality Analysis (DQA) and Data Profiling on source data.
  • Collaborated the data mapping document from source to target and the data quality assessments for the source data.
  • Execute test cases to validate source data has been accurately mapped, transformed and loaded to common format.
  • Involved in Analysis, profiling and cleansing of source data and understanding the business process.
  • Write SQL queries to validate source data and created mapping document for the target data.
  • Analyzed and tested DataStage Mappings with OLTP source data, staging and target data.
  • Work with business area partners to understand source data for mapping and modeling.
  • Performed data analysis and profiling of source data to better understand the sources.
  • Verified correctness of data after the transformation rules were applied on source data.
  • Created the calculations based on the reporting needs and the source data available.
  • Work with source data and lead mapping documentation of all source data elements.
  • Analyzed the source data and handled efficiently by modifying the data types.
  • Assess whether metadata accurately describes the actual values in the source database.
  • Profile and analyze source data.
  • Compared and Tested Source data.
  • Incorporated other data sources and mappings when provided to demonstrate and document how this data supplements and enriches client-provided source data.
  • Prepared source data for computer entry,compiled, sorted, and prioritized data.
  • Analyze the source data structures, create target tables, perform necessary mappings and run the workflows using Informatica PowerCenter Client.

Show More

36. Data Integrity

demand arrow
low Demand
Here's how Data Integrity is used in Senior Data Analyst- jobs:
  • Investigated and facilitated resolution of data integrity issues; provided impact assessment to support prioritization of fixes and enhancements.
  • Mined data for insights, facilitating fast response to potential exposures and ensuring data integrity.
  • Automated processes across multiple functional areas to ensure data integrity and optimize system resources.
  • Provided polling support for internal departments and ensured data integrity for interfacing systems.
  • Manage data integrity of IT systems that provide customer information or operations data.
  • Provided comprehensive technical support for Data Integrity group to facilitate data quality.
  • Reviewed data to ensure data integrity, accuracy and validity.
  • Researched and implemented additional data integrity and validation processes.
  • Managed data integrity of credentialing system, IntelliCred.
  • Maintained security and data integrity of the database.
  • Validate data warehouse to ensure data integrity.
  • Maintained Data Integrity using PL/SQL in Stored Procedures & Functions.
  • Checked the naming standards, data integrity and referential integrity.
  • Complete large database cleanup projects to insure data integrity.
  • Created checks and constraints to maintain data integrity.
  • Performed & Maintain data integrity.
  • Collaborated with data vendors to setup data delivery and data integrity process check.
  • Embedded quality assurance toll gate for individual workflows to ensure data integrity.
  • Introduced updated controls to measure data integrity for marting of the tax warehouse
  • Tested Ab Initio ETL processes by confirming data integrity between data sources.

Show More

8 Data Integrity Jobs

No jobs at selected location

37. T-Sql

demand arrow
low Demand
Here's how T-Sql is used in Senior Data Analyst- jobs:
  • Improved operational procedures to maximize systems efficiency and database integrity using T-SQL.
  • Implemented error handling techniques like try catch blocks, error functions in T-SQL scripts and stored procedures to support the applications.
  • Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server.
  • Created dynamic T-SQL scripts to apply complex business logic to allow better data integration of information from various systems.
  • Managed all indexing, debugging, optimization and query optimization techniques for performance tuning using T-SQL.
  • Translated business-logic into T-SQL and VB code for pulling, analyzing, and presenting data.
  • Created/modified SQL Joins, sub-queries, and other T-SQL code to implement business rules.
  • Developed and deployed quality T-SQL code, views and functions using complex joins.
  • Utilized T-SQL on a daily basis in creating data and business analysis.
  • Utilized T-SQL queries to retrieve information from the database based on requirements.
  • Write stored procedures/functions/SSIS packages for data migration by T-SQL and SSIS.
  • Supported team in resolving SQL Reporting services and T-SQL related issues.
  • Supervised and developed T-SQL solutions to meet client needs and requests.
  • Created stored procedures for the business logic using T-SQL.
  • Create awareness of good practices for writing T-SQL code.
  • Used T-SQL to support the business.
  • Complete complex, high priority AD-HOC and recurring analytical requests against multiple data sources using SAS and/or T-SQL.
  • Worked on querying data and creating on-demand reports using T-SQL and sent the reports via email.
  • Performed T-SQL tuning by using Database Engine Tuning Advisor for long execution plans.
  • Create reports and report packages using T-Sql queries, Bids, SSIS and SSRS.

Show More

38. Powerpoint

demand arrow
low Demand
Here's how Powerpoint is used in Senior Data Analyst- jobs:
  • Provide ongoing training to coworkers to assist with analysis, including preparing PowerPoint presentations and training video content.
  • Develop spreadsheets, PowerPoint briefings, scheduling/notifications and all other documentation necessary to support program requirements.
  • Developed allocation models using Oracle Hyperion Financial Management and SAP using Excel and PowerPoint.
  • Produced monthly PowerPoint commodities trend reports to upper-management up through C-level.
  • Prepared training materials using Microsoft PowerPoint and created technical manuals.
  • Designed PowerPoint and Word templates for company requirements.
  • Redesigned Excel spreadsheets, Access database queries, and PowerPoint links to accommodate all new data changes for the client.
  • Communicated with Management to gather requirements of data to be analyzed and created in both Excel and PowerPoint.
  • Compiled, edited, and formatted textbooks using MS Word, PowerPoint, Excel, and Adobe Acrobat.
  • Presented capacity trends and growth forecasts using Excel pivot table charts / graphs and PowerPoint to customers.
  • Developed reports that monitor the response rates for new credit cards launched in both Excel and PowerPoint.
  • Developed manual dashboard for first phase of Service Level reporting utilizing PowerPoint and Excel.
  • Produced and delivered reports using PowerPoint, Adobe Persuasion, PageMaker, Word/WordPerfect.
  • Summarized insights in PowerPoint and presented findings to peers and senior management.
  • Prepared income and demand presentations in PowerPoint and Excel.
  • Implemented in R and presented as PowerPoint deck.
  • Analyzed and built ad-hoc graphical visual charts/reports with PowerPoint presentations from gathered metrics, for leadership monthly/quarterly business reviews.
  • Performed in depth analysis on the data pulled for adhoc request and prepared graphs Using MS Excel and MS PowerPoint.
  • Published ad-hoc analyses in Mode, TreasureData, Confluence, and/or PowerPoint as needed.
  • Generated Use Case diagrams and Visio to depict process flows and PowerPoint presentations.

Show More

5 Powerpoint Jobs

No jobs at selected location

39. Suite

demand arrow
low Demand
Here's how Suite is used in Senior Data Analyst- jobs:
  • Conducted user interviews, gathered Requirements, analyzed the Requirements and managed changes using Rational Suite.
  • Produced and delivered C-suite level data reporting.
  • Function as a POC for IT functionality within the COD/AM&S suite and ER Williams Corporate satellite office.
  • Assist management with evaluations of the current OSS tools suite and produce recommendations for enhancements and next generation solutions.
  • Executed test cases in ALM for the new feature/s and ran Regression Test suites for the existing modules.
  • Created new training guides as well as trained employees on new company accounting guidelines and NetSuite procedures.
  • Supplied financial data to both internal and external customers via Hyperion Performance Suite.
  • Identify and implement a suite of QC processes based on known methodologies.
  • Lead analyst on a complex Hyperion Performance Suite upgrade.
  • Experienced in using Selenium Grid to execute Selenium automation suites on different platforms and various browser combinations in parallel.
  • Processed and supported all facets of our client's complex data elements utilized to construct our marketing planning suite of products/deliverables.
  • Assisted the IT Department with the implementation of NetSuite ERP from SAGE 100 and helped to develop company SOX procedures.
  • Created and manage Dashboards, Worksheets helping senior Management to have at-a-glance views of KPIs using Tableau and OBIEE Suite.
  • Designed and created a suite of automated Excel-based VBA reports that managed and synthesized large volumes of transactional data.
  • Use of Microsoft Office Suites including Access [ ] Adobe Professional.
  • Helped to create custom workflows in NetSuite Sandbox to execute document approval process and loaded workflow to Production environment once validated.
  • Leverage enterprise-wide analytics tools: Adobe Marketing Suite, ComScore and Chartbeat.

Show More

5 Suite Jobs

No jobs at selected location

40. JAD

demand arrow
low Demand
Here's how JAD is used in Senior Data Analyst- jobs:
  • Facilitated JAD sessions for project scoping, requirements gathering & identification of business subject areas.
  • Documented JAD Minutes and incorporated business requirements.
  • Conducted JAD Sessions with the SME, stakeholders and other management teams in the finalization of the User Requirement Documentation.
  • Interacted with the End users and conducted JAD sessions to ensure that their requirements are compliant with the code tested.
  • Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
  • Framed a detailed agenda for Joint Application Development (JAD) and brainstorming sessions as requirement elicitation technique.
  • Conducted JAD sessions to get SME's input on how to implement the application for Group Disability Claims.
  • Conducted team meetings and JAD sessions for the Requirements clarifications and gave suggestions in the Requirements to Business.
  • Analyzed conceptual into logical data and had JAD sessions and also communicated data related issues and standards.
  • Led Joint Application Design (JAD) sessions for the coffee, meat and international trading divisions.
  • Conducted Joint Application Design (JAD) sessions with business users to gather data warehouse requirements.
  • Organized and conducted extensive JAD sessions with users to identify, understand and document requirements.
  • Conducted JAD sessions for defining business requirements and follow-up for Project Plan updates.
  • Conducted JAD sessions for communicating with the all Project directors and stakeholders.
  • Participated in JAD sessions involving the discussion of various reporting needs.
  • Conducted team meetings and Joint Application Design (JAD) session.
  • Gathered requirements from JAD/JAR sections with developers and business clients.
  • Facilitated and attended JAD (Joint Application Development) sessions.
  • Conducted team meetings and JAD sessions.
  • Attended JAD sessions and created reports for Budgeting, Finance and Project Management departments of Pima County.

Show More

41. VBA

demand arrow
low Demand
Here's how VBA is used in Senior Data Analyst- jobs:
  • Streamlined and automated reports using VBA
  • Created a SQL database as a staging area to clean, validate and prepare for use in VBA-driven Excel reports.
  • Developed VBA script to send bulk email to all managers for those employees that had an unresolved status for resolution.
  • Designed and developed 10 databases with custom user interfaces using VBA to streamline the carrier dispute process.
  • Worked with VBA Macros with Excel VBA, which automate tasks in Excel by writing macros.
  • Use advanced Excel tools (Marcos VBA) to manipulate and analyze large amounts of data.
  • Create automated reporting in Excel using VBA, Access DB, and SQL Server connections.
  • Tested, Quality Controlled, and utilized VBA macros for automated pricing of non-feed exchanges.
  • Used VBA to auto-populate current employee status entered by manager to update human resource records.
  • Created Access and Excel based tools with VBA programming to improve boarding process.
  • Execute macros and VBA codes to automate data entry inputs and analysis.
  • Utilized Excel VBA with advanced formulas for data analysis and validation.
  • Automated a monthly 8-hour manual Excel process using VBA coding.
  • Developed front end reports in Excel and PowerPoint using VBA.
  • Customized the Business Objects features by using VBA in Macros.
  • Installed, developed, and maintained Visual Basic (VB 2008 .NET), Excel VBA, and StatGraphics programs.
  • Created adhoc reports and pivot tables in Excel 2013 using VBA and macros.
  • Automated team data generation workflows with Python and VBA.
  • Used VBA, SQL and .NET for Automation.
  • Key Lines of Business: Telecom, Billing Environment MS Access 97, SQL Server, VBA

Show More

42. Reverse Engineering

demand arrow
low Demand
Here's how Reverse Engineering is used in Senior Data Analyst- jobs:
  • Translated existing data bases into models to understand objects and relations using reverse engineering function using Erwin.
  • Cleansed unnecessary tables and columns and redefined various attributes and relationships in the Reverse Engineering Model.
  • Based on requirement Reverse Engineering on existing model if required.
  • Generate DDL statements from data model using Forward Engineering, and generate data model using DDL statements using Reverse Engineering.
  • Used Reverse Engineering to connect to existing database and developed process methodology for the Reverse Engineering phase of the project.
  • Worked on Forward and Reverse Engineering using Erwin, reverse engineered XSD structures, excel spread sheets and copybooks.
  • Performed logical data modeling, physical data modeling (including reverse engineering) using the Erwin Data Modeling tool.
  • Forward Engineering the Data models, Reverse Engineering on the existing Data Models and Updates the Data models.
  • Used reverse engineering to create Graphical Representation (E-R diagram) and to connect to existing database.
  • Involved in Reverse engineering on existing Data model to understand the data flow and business flows.
  • Involved in Reverse Engineering the existing Stored Procedures and write Mapping Documents for them.
  • Experience creating/generating DDL structure of tables (Forward and Reverse Engineering).
  • Perform reverse engineering of physical data models from databases and SQL scripts.
  • Worked with reverse engineering Data Model from Database instance and Scripts.
  • Developed Process Methodology for the Reverse Engineering phase of the project.
  • Utilized Erwin's reverse engineering process.
  • Involved in forward and reverse engineering.
  • Performed Reverse Engineering of the current application using ERwin, and developed Logical and Physical data models for Central Model consolidation.
  • Synched up the models by reverse engineering, compare model and merge model from database to the original models.
  • Worked extensively in both Forward Engineering as well as Reverse Engineering using data modeling tools.

Show More

43. EDW

demand arrow
low Demand
Here's how EDW is used in Senior Data Analyst- jobs:
  • Performed data profiling identified data quality issues and recommended remediation strategies for EDW.
  • Created various SSIS packages to process data from the ODS database to the EDW data warehouse and other data marts.
  • Created Hive queries that helped analysts spot emerging trends by comparing fresh data with EDW reference tables and historical metrics.
  • Assessed current Enterprise Data Warehouse environment and the expected functions of the EDW in support of various business information needs.
  • Analyze end client requests and provide guidance and technical assistance on obtaining accurate information from the EDW databases.
  • Established best practices in database design and master data management for the Enterprise Data Warehouse (EDW).
  • Created and reviewed the conceptual model for the EDW (Enterprise Data Warehouse) with business user.
  • Created dimensional models for data marts sourced from EDW for business intelligence and analytic reporting.
  • Created, consolidated and maintained EDW (Enterprise Data Warehouse) data models.
  • Analyzed the Historical data in the Legacy system to suit the EDW requirements.
  • Have done installation and configuration for EDW using SQL Server 2012.
  • Analyzed and maintained EDW design.
  • Designed the EDW data model and create the table in EDW.
  • Involved in extracting the data from ODS and transform and load it to EDW (Teradata).
  • Developed expense and capital scorecards utilizing the Concur expense and Oracle JD Edwards EnterpriseOne systems.
  • Performed Oncall 24x7 production support for all 4 data marts of EDW.
  • Experienced with AT&T data warehouses such as eCDW & EDW.
  • Created mappings in order to load the flat files into relational database so as to support ad-hoc reporting on EDW tables.
  • Lead the effort of Analysing ETL business rules from Rosetta existing Datamarts to new designed Enterprise DataWarehouse (EDW).
  • Proposed the EDWdatadesign to centralize the data scattered across multiple datasets.

Show More

44. Netezza

demand arrow
low Demand
Here's how Netezza is used in Senior Data Analyst- jobs:
  • Migrated the source code from Oracle into NetezzaDatabase.
  • Worked in Database using Oracle, XML, DB2, Teradata14, Netezza, SQL server, Big Data and NoSQL.
  • Developed stored procedures on Netezza (NZPLSQL scripts) and SQL server for data manipulation and data warehouse population.
  • Extracted data from various sources like Oracle, Mainframes, flat files and loaded into the target Netezza database.
  • Created Complex workbooks and Dashboards by connecting to multiple data sources (Hive/Netezza/Excel/SQL Server) using data blending.
  • Create Data Extracts connecting to Hive and Netezza database, writing custom SQL queries based on requirement.
  • Involved in developing and modifying software applications using PL/SQL, SQL on Netezza Database.
  • Analyzed the source data coming from Oracle11g, Netezza and flat files.
  • Worked on Netezza to build ETL table along with some external tables.
  • Extract the data from SAP HANA, Netezza and various RDBMS data bases.
  • Provided analysis documents for initial programs to migrate data sources from Teradata to Netezza system.
  • Worked in Netezza to Oracle12cShell script for loading tables which are required by DB2 Tools from Netezza in to the Oracle.
  • Applied Hot-bug fixes and also version patches for Netezza, Oracle, SQL server and Informatica in Windows environment.
  • Created ETL package using SSIS that exports data from SQL server2012 and Netezza into a CSV file.
  • Involved in creating tables in Putty and transferring those tables from Hive to Netezza via Sqoop process.
  • Involved in SQL queries and optimizing the queries in Oracle10g, DB2, and Netezza, Teradata.
  • Worked with Data Warehouse built in Netezza and Teradata Familiar with MDM concepts.
  • Used Netezza Analytical functions like RANK, ROW_NUMBER etc.
  • Developed ad hoc queries to generate reports and involved in unit testing of ad-hoc reports on NETEZZA and Teradata.
  • Assisted the database marketing team in transitioning the lead generation process from DoubleClick Ensemble to Unica Affinium/Netezza.

Show More

45. Data Dictionary

demand arrow
low Demand
Here's how Data Dictionary is used in Senior Data Analyst- jobs:
  • Worked on data analysis concepts like data definition, data dictionary and business matrix.
  • Maintained data dictionary and lineage documentation for key areas of business.
  • Experience using copybook layouts and affiliated data dictionary.
  • Created Data mapping and Data Dictionary Documents.
  • Monitor and control Data Dictionary usage.
  • Generate data dictionary and maintain metadata.
  • Applied data naming standards, created the data dictionary and documented data model translation decisions and also maintained DW metadata.
  • Maintained the Data Dictionary, Repository of models, performed model merging's for all the tracks.
  • Identified non-compliant metadata in the Enterprise Data Dictionary and produced a plan to correct the discrepancies.
  • Created documentation (data dictionary), data flow diagrams and assisted in Data Modeling.
  • Documented the procedure for generating the Data Dictionary and Data Model Diagrams from Erwin.
  • Enforced naming standards and data dictionary for logical and physical data models.
  • Create, publish and maintain data dictionary and metadata.
  • Created an enterprise data dictionary and maintained standards documentation.
  • Finalize the naming Standards for Data Elements and ETL Jobs and create a Data Dictionary for Meta Data Management.
  • Worked with SMEs to create and update Data Dictionary Mapping from database to user interface.
  • Created and maintained Meta data for the enterprise such as data dictionary, data definition.
  • Maintained Meta Data both in the data model and in Master Data Dictionary.
  • Documented database ERDs and produced live searchable source to target map, data dictionary, and business rules for data warehouse.
  • Utilized Popkin System Architect case for business procedures, processes, rqmts, data dictionary and data modeling.

Show More

6 Data Dictionary Jobs

No jobs at selected location

46. Pivot Tables

demand arrow
low Demand
Here's how Pivot Tables is used in Senior Data Analyst- jobs:
  • Created highly accurate and extensive Excel reports and pivot tables from raw data for client tracking, documentation and research purposes.
  • Advanced use of Microsoft Excel / Access to create pivot tables and charts as part of data manipulation and marketing analysis.
  • Performed dicing and slicing on data using Pivot tables to acquire the churn rate pattern and prepared reports as required.
  • Utilize pivot tables and crystal reports to provide an accurate, efficient, and maintainable presentation layer for users.
  • Worked with advanced Excel functions to generate spreadsheets and pivot tables to help with creating reports.
  • Created databases of data extracted, created Pivot Tables from data extracted.
  • Generated reports using Microsoft Excel Pivot tables.
  • Worked with Excel Pivot tables.
  • Create reports and measures using SQL Server, SSIS, SSRS, and pivot tables.
  • Managed, updated and manipulated report orientation and structures with the use of advanced Excel functions including Pivot Tables and V-Lookups.
  • Created analytical reporting using Advanced Excel features like spreadsheet functionality including V-look-up, Pivot tables, and charts and excel graphs.
  • Translated findings into meaningful information and presented them using Microsoft Excel based reports, pivot tables and charts and Microstrategy.
  • Experience in Power Point Presentation (Financial Data, Charts) Expertise in generating graphs using MS Excel Pivot tables.
  • Managed projects and created analysis using Excel pivot tables and communicated status of each project to key operations personnel.
  • Involved in creating the pivot tables and bar charts for the schedule fields requiring the obligor financial data.
  • Experienced using SSIS to create pivot tables to transform data for a single column type (i.e.
  • Present data to users for final signoff using pivot tables and SQL Server Reporting Services.
  • Used Pivot Tables and Vlookup to extract and analyze data for easy visualization.
  • Performed various statistical and mathematical calculations in Excel and created Pivot tables, V Lookups, and H Lookups for analysis.
  • Used MS Excel to create Derivative Sub Instrument Reports via Pivot Tables and VLookups.

Show More

47. Technical Specifications

demand arrow
low Demand
Here's how Technical Specifications is used in Senior Data Analyst- jobs:
  • Gathered and translated business requirements into detailed, production-level technical specifications detailing new features and enhancements to existing business functionality.
  • Develop outcomes and process measures, including technical specifications to enable population measurement, guideline implementation, and evaluation.
  • Interacted with client and the technical team for requirements gathering and translation of business requirements to technical specifications.
  • Analyze and capture external and internal data feeds including technical specifications to Thomson Reuters Legal applications.
  • Deliver tagging requirements/technical specifications for site functionality in alignment with business goals and reporting requirements.
  • Experience in creating Functional/ Technical Specifications, Data Design Documents based on the requirements.
  • Worked with business in gathering requirements and translating them to technical specifications.
  • Translate business requirements and assist IT with the development of technical specifications.
  • Prepared Technical Specifications and database change requests based on data analysis.
  • Develop and maintained Technical Specifications Documentation for the Technical team.
  • Analyzed functional and technical specifications and developed logic flowcharts.
  • Review standardized technical specifications for accuracy and coherency.
  • Analyze business requirements and produce functional/technical specifications.
  • Designed database tables as per technical specifications.
  • Created Technical specifications documents based on the functional design document for the ETL coding to build the data mart.
  • Develop ETL code meeting 100 percent of technical specifications and business requirements according to the established designs.
  • Involved in creating the design and technical specifications for the ETL process of the project.
  • Prepared detailed technical specifications to hand off to the development team.
  • Develop and integrate SAS applications/database in conjunction with internal IT and external vendors Define and document functional and technical specifications.
  • Meet with development team to review technical specifications and identify issues, signoff and target dates.

Show More

1 Technical Specifications Jobs

No jobs at selected location

48. Governance

demand arrow
low Demand
Here's how Governance is used in Senior Data Analyst- jobs:
  • Established guidelines for data governance, data stewardship, and reference data management standardization.
  • Involved with Data governance in understanding the data relationships for compliance and regulatory reporting.
  • Created technical documentation to support data governance operations
  • Developed comprehensive project portfolio reporting data, supplying data for governance, process and training and PM arms of the ITPMO.
  • Developed Data Mapping, Data Governance, and Transformation and cleansing rules for the Master DataManagement Architecture involving OLTP, ODS.
  • Conducted the Data model review sessions with Senior DA's, Product Owners, and Governance team to get approval.
  • Ensured that Business, Data Governance and Integration team leads are deeply involved in critical design issues and decisions.
  • Work with data governance team in coming up with business definition of tables/attributes used in the data model.
  • Managed the Data Governance framework by creating compliance processes and data policies in accordance of industry standards.
  • Involved in data governance activities such as setting standards for data definition, class words.
  • Serve as the Data Governance Council Leader for cross functional project management.
  • Developed the best practices and standards for Data Governance Processes.
  • Worked on data governance for improving data quality.
  • Worked with Data governance and quality.
  • Designed organization-wide standards to protect student privacy and restrict access to data, established data governance guidelines and created data-sharing agreement.
  • Formulate and apply data modeling and other optimization methods using specialized tools to develop data governance workflows.
  • Involved with Data Profiling activities for new sources before creating new subject areas in warehouse Extensively worked Data Governance, i.e.
  • Help define and track Data Quality and Data Governance metrics and helped prepare MDM platform roadmaps for current vs. future state.
  • Performed various functions related to Teradata governance for the Teradata platform team.
  • Risk Data Governance Impl).

Show More

36 Governance Jobs

No jobs at selected location

49. Cognos

demand arrow
low Demand
Here's how Cognos is used in Senior Data Analyst- jobs:
  • Personalized Cognos Connection for specified display options for testing regional options and personal information.
  • Develop Oracle PL/SQL Packages, Procedures, and Materialized Views to create a flattened version of the data/structure for Cognos reporting.
  • Developed PL/SQL Business Functions and calling into the Cognos Tools Designed and Developed Power Prompts for Web Users for Flexible Querying.
  • Developed complex SQL for COGNOS BI reports to extract data from the Backend and also for Validation of data.
  • Created custom reports for presenting results using IBM Cognos and MS Access.
  • Tested whether the reports developed in Cognos are as per company standards.
  • Worked with business team to test the reports developed in Cognos.
  • Involved in testing the Cognos reports by writing complex SQL queries.
  • Worked with Cognos reporting team and trained for better customer support.
  • Worked with Business Analysts to design weekly reports using Cognos.
  • Tested cognos reports for verifying and validating the data.
  • Migrated reports from Cognos 8.4.1 to Tableau 8.
  • Involved in Cognos report development.
  • Involved in the development (create, load and test) of custom tables for cognos reports using Informatica.
  • Tested different master detail, summary reports, ad-hoc reports and on demand reports using Cognos Report Studio.
  • Created an array of CMS Program Integrity Matrics Reports for senior management using IBM Cognos.
  • Designed and coded Fact, Dimension builds and jobs streams using Cognos Datamanager.
  • Worked with Datastage ETL and Cognos reporting.
  • Experience in Migrating/testing reports from Crystal Reports to Cognos 8 Experience in Integrating Cognos 8 with SQL Server and Oracle.
  • Developed Executive Dashboard reports using Cognos Report Studio, Workspace and Workspace Advanced.

Show More

6 Cognos Jobs

No jobs at selected location

50. Sybase

demand arrow
low Demand
Here's how Sybase is used in Senior Data Analyst- jobs:
  • Monitored market data and post processing data from over 140 external data providers to ensure accuracy within Sybase relational database.
  • Used Sybase Power Designer tool for relational database and dimensional data warehouse designs.
  • Participated in creating database, tables, indexes, store-procedures, and triggers in the SQL Server and Sybase databases.
  • Experienced in development and design of RDBMS -OLTP, dimensional modeling using data modeling tool ERWIN, Sybase Power Designer.
  • Worked on business Objects ETL tool to create mapping from Sybase existing data to newly created database Oracle 11g.
  • Developed and implemented database triggers, T-SQL and stored procedures within Oracle, SQL Server and Sybase.
  • Developed the data model using Sybase Power Designer 15 & printed reports to support the data dictionary.
  • Converted a Sybase database to a SQL Server replica for use by management and reporting systems.
  • Generated Sybase SQL scripts that include creating tables, Primary Keys, and Foreign Keys.
  • Involved in querying Sybase, Oracle databases using Rapid SQL to troubleshoot issues.
  • Performed data modeling to correct problems with the current Sybase database.
  • Designed and supported Snapshot Replications from SQL Server to Sybase.
  • Provide database coding to support business applications using Sybase T-SQL.
  • Used Sybase Power Designer in designing the data model.
  • Modified Informatica mappings and Sybase data structures in support of reporting system
  • Compared physical models to Sybase databases using Embarcadero ER/Studio Data Architect to document, report and resolve any variances.
  • Developed databases to interface with SQL Server, Oracle, Teradata, Sybase, and MS Access databases.
  • Involved in Data from Sybase IQ to Netezza and make Informatica Code changes for the compatibility with Netezza.

Show More

Senior Data Analyst- Jobs

NO RESULTS

Aw snap, no jobs found.

20 Most Common Skills For A Senior Data Analyst-

Data Warehouse

22.4%

Business Requirements

12.5%

Database

9.7%

ETL

6.2%

Data Analysis

6.0%

Teradata

4.1%

Test Cases

3.8%

Informatica

3.8%

Pl/Sql

3.4%

Unix

3.3%

Windows XP

2.7%

Visio

2.7%

Metadata

2.7%

Toad

2.5%

Dashboards

2.5%

SAS

2.5%

Tableau Server

2.4%

Ssis

2.3%

DB2

2.2%

Schema

2.0%
Show More

Typical Skill-Sets Required For A Senior Data Analyst-

Rank Skill
1 Data Warehouse 16.2%
2 Business Requirements 9.0%
3 Database 7.0%
4 ETL 4.4%
5 Data Analysis 4.3%
6 Teradata 2.9%
7 Test Cases 2.8%
8 Informatica 2.8%
9 Pl/Sql 2.5%
10 Unix 2.4%
11 Windows XP 2.0%
12 Visio 1.9%
13 Metadata 1.9%
14 Toad 1.8%
15 Dashboards 1.8%
16 SAS 1.8%
17 Tableau Server 1.7%
18 Ssis 1.7%
19 DB2 1.6%
20 Schema 1.4%
21 Source Systems 1.4%
22 User Acceptance 1.4%
23 XML 1.3%
24 BI 1.3%
25 Ssrs 1.2%
26 QA 1.2%
27 UAT 1.2%
28 Oltp 1.1%
29 Sharepoint 1.1%
30 Olap 1.0%
31 SQL 1.0%
32 DDL 1.0%
33 ODS 1.0%
34 DBA 0.9%
35 Source Data 0.9%
36 Data Integrity 0.9%
37 T-Sql 0.8%
38 Powerpoint 0.8%
39 Suite 0.8%
40 JAD 0.8%
41 VBA 0.8%
42 Reverse Engineering 0.8%
43 EDW 0.7%
44 Netezza 0.7%
45 Data Dictionary 0.7%
46 Pivot Tables 0.7%
47 Technical Specifications 0.7%
48 Governance 0.7%
49 Cognos 0.6%
50 Sybase 0.6%
{[{skill.rank}]} {[{skill.name}]} {[{skill.percentageDisplay}]}%
Show More

26,198 Senior 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.