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.

Analytics Consultant

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 Analytics Consultant Skills

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

These are the most important skills for an Analytics Consultant:

1. Business Requirements

demand arrow
high Demand
Here's how Business Requirements is used in Analytics Consultant jobs:
  • Reviewed business requirements and technical specification documents and analyzed uses cases, functional requirements to write detailed test cases.
  • Participated in interviews with management and business decision-makers for gathering business requirements during discovery and RAP phases.
  • Maintained responsibility for identifying and defining business requirements while translating business needs into complex analyses and recommendations.
  • Involved in managing appropriate security privileges on subject areas and dashboards according to business requirements.
  • Used Metadata Design Principles to design Repository based on business requirements and followed Best Practices.
  • Created a relationship mapping framework between data and business requirements to aid business decision.
  • Analyzed the business requirements and building logical and physical data models.
  • Gathered business requirements by conducting detailed interviews and one on one meeting with business users, stakeholders and SME's.
  • Write complex queries in SQL that capture the business requirements and ensure adherence to data management regulations and policies.
  • Design, develop, and launch reports and dashboards according to business requirements in various system and tools.
  • Gather business requirements, document BRDS and run use cases to ensure report requirements are met.
  • Modify the existing SSIS packages to reflect the new business requirements.
  • Work with marketing and sales groups to define business requirements.
  • Worked closely with each group to gather business requirements.
  • Involved in gathering Marketing and Sales Team business requirements.
  • Worked with users to define business requirements and analytical needs to maximize portfolio risk management.
  • Identified business requirements and analytical needs.
  • Designed and built InfoObjects, InfoCubes, DSO, Multi providers based on business requirements and prepared a Design documents.
  • Worked closely with Key Business Stakeholders and SMEs to gather Business Requirements.
  • Worked on Siebel Analytics webcat and created business reports and dashboards based on business requirements.

Show More

33 Business Requirements Jobs

No jobs at selected location

2. Dashboards

demand arrow
high Demand
Here's how Dashboards is used in Analytics Consultant jobs:
  • Managed security privileges for each subject area and dashboards according to user requirements.
  • Create and maintain new data visuals, dashboards and insights using Tableau software to be featured in external and internal presentations.
  • Plan, develop and construct interactive leadership dashboards for population health, quality of care, and cost effectiveness metrics.
  • Linked summary provider data to visually appealing dashboards in Excel 2007 using tables and charts to highlight provider performance.
  • Obtained Management approval and User validation on solutions for Tools, Metrics, Dashboards, and Data Consolidated.
  • Designed new Excel templates and managed Visual Basic macros which produced dashboards for use in mental health campaign.
  • Configured Intelligence dashboards by adding content such as links/images, HTML objects and folders.
  • Enhance performance of Reports/Dashboards by implementing the Aggregate tables, and Cache Management.
  • Worked on Answers to build Interactive Dashboards with drill-down capabilities.
  • Used Delivers to configure schedule and deliver personalized alerts to Interactive Dashboards using Scheduler iBots.
  • Maintained effectiveness in creating the Dashboards by appropriately including guided navigation links and drilldowns.
  • Tested different Analytics implementations and came up with improved solutions for set of tools, metrics, and dashboards.
  • Developed many Reports / Dashboards with different Analytics Views (Pivot Table, Chart, Tabular, etc.)
  • Design and deliver standard and ad-hoc reports, metrics, dashboards, and various data visualization reporting solutions.
  • Developed custom reports/Ad-hoc queries using Oracle BI Answers and assigned them to application specific dashboards.
  • Created proactive agents iBots and interactive Dashboards to alert the Marketing team about business changes.
  • Used the Catalog manager and maintained the Analytics web catalog to manage Dashboards, Answers.
  • Worked extensively to develop Dashboards and Reports so as to meet the Functional Requirements.
  • Developed BI dashboards for marketing using Domo and R
  • Created Dashboards by embedding reports and providing intuitive drilldowns and links to exploit the full benefit of Analytics.

Show More

24 Dashboards Jobs

No jobs at selected location

3. SQL

demand arrow
high Demand
Here's how SQL is used in Analytics Consultant jobs:
  • Analyzed data to identify operational problems and/or errors and created temporary solutions using SQL to ensure timely reporting.
  • Manipulated large and complex data sets (using Excel and SQL) while researching unusual traffic patterns and to extract data.
  • Created various SQL stored procedures, views, functions and temporary tables for data input to the Crystal Reports.
  • Developed procedures to transform, integrate, and validate data for data mining initiatives, using Microsoft T-SQL.
  • Created automated data flow tasks and reporting using SQL programming in Microsoft SQL Reporting/Integration Services and Crystal Reporting.
  • Aided in development and management of Access database solutions using SQL Server, including macros and reports.
  • Developed complex queries to retrieve critical data and wrote reports using SQL server 2008.
  • Extracted data from source systems like Oracle, SQL Server and Flat files.
  • Worked with Database Management System Business Intelligence that used SQL to retrieve data.
  • Utilized SQL views and stored procedures with additional joins to manipulate data.
  • Scheduled the DTS packages using the Data transformation services SQL2000.
  • Experience in Loading data from CSV, MySQL.
  • Manipulated and extracted data from SQL server database.
  • Develop robust queries and tune SQL server performance.
  • Developed complex SQL scripts in Calculation views.
  • Advanced model development using SQL and Tableau.
  • Used SQL programming language to manipulate data.
  • Perform database administration for marketing analytics SQL Server 2012 database.
  • Deployed and activated standard Attribute Views, Analytical Views, Calculation Views, SQL Scripts.
  • Used SQL, and Excel to develop interactive reports for Home Loans & Insurance department for leadership analytics.

Show More

251 SQL Jobs

No jobs at selected location

4. Analytics

demand arrow
high Demand
Here's how Analytics is used in Analytics Consultant jobs:
  • Provide consulting services in data management, marketing strategy, business analysis, and marketing analytics.
  • Managed analytics and metrics reporting projects for Population Health / Value-Based Care and Clinical Integration.
  • Prepare and present data/analytics and metrics for strategy development and business decision making.
  • Managed web analytics continuous improvement process for company's digital channel.
  • Advised clients and client-facing staff on current and planned capabilities of workstation compliance, performance, risk, and analytics systems.
  • Work with clients across North America to develop marketing strategies, campaigns, and use analytics to solve business problems.
  • Partner with various lines of businesses with Servicing Data & Analytics to gather data and reports for different areas.
  • Integrated EDW data in Web Analytics Apps thus enabling Analysts to access richer data through Site Catalyst and Discover
  • Provided immediate value by leading Insurance Marketing Analytics and research initiatives for Life Insurance.
  • Performed text analytics showing predictive value of call center data in aiding customer retention.
  • Process included text analytics and machine learning (Na ve Bayes and SVM)
  • Provide insights to business customers regarding data and use of analytics.
  • Tracked traffic levels and campaign metrics using Google Analytics.
  • Served as the SME for analytics product upgrades.
  • Author the analytics-related components of RFPs and product development efforts.
  • Dish Networks Analytics (DNA) is implemented to establish and enhance a cost effective customer management analytical system.
  • Created and presented employer health plan performance analytics to internal and external clients and brokers.
  • Piloted a Spark use case for benchmarking in-memory analytics.
  • Provided onsite claims-based analytics and program evaluation services for Cigna clients Safeway and Safeway Health in order to guide strategic decision-making.
  • Leveraged BI Tools and statistical methodologies to build quantative models for the commerical analytics group.

Show More

462 Analytics Jobs

No jobs at selected location

5. Data Warehouse

demand arrow
high Demand
Here's how Data Warehouse is used in Analytics Consultant jobs:
  • Produced the Business Requirements Definition, Technical Requirements documents, and project plans for large-scale data warehouse project.
  • Work closely with data warehouse architects to generate seamless business intelligence solutions for end users.
  • Used SSIS to create ETL packages to validate, Extract, Transform and load data to data warehouse and data marts.
  • Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
  • Define the overall data warehouse architecture (e.g., ETL process, ODS, EDW, Data Marts).
  • Worked on cleaning and generating patient measurements files from Insurance companies to access data warehouse for Values based Project.
  • Monitor Shared Data Warehouse for incorrect/complex queries causing performance issues to the SQL Server using Oracle Enterprise Manager.
  • Investigated forecast anomalies, identified root cause, and notified data warehouse team of any suspected ETL failures.
  • Monitored and managed the data feeds into the data warehouse as well as extraction transformation and loading.
  • Develop ETL pipelines for moving app/service data to a data warehouse for reporting & analysis.
  • Trained in data warehouse concepts like Star Schema, Snow Flake, Dimension and Fact tables
  • Assisted with analyzing data from the data warehouse to inform business decisions utilizing Oracle SQL.
  • Developed reports in Oracle Answers 10g, 11g over the existing data warehouse.
  • Administered and configured Data warehouse Application Console (DAC).
  • Assisted in the operations and development of the data warehouse.
  • Proposed process included customer segmentation on various characteristics, segmentation on product preferences and affinity analysis developed using Teradata Warehouse Miner.
  • Developed/Bench-Marked performance tuning strategies with business model-level calculations versus Data warehouse level pre-computations and aggregations.
  • Leverage the enterprise data warehouse and HRIS/HCM/ERP as primary tools for HR dashboard, reporting and analytics.
  • Negotiated with IT group and implemented major enhancements in Data Warehouse tables to better support b2b analytics.
  • Create scorecards via Adobe Data Warehouse, Advanced Excel Integration and Data Manipulation.

Show More

6 Data Warehouse Jobs

No jobs at selected location

Job type you want
Full Time
Part Time
Internship
Temporary

6. Financial Statements

demand arrow
high Demand
Here's how Financial Statements is used in Analytics Consultant jobs:
  • Prepared statistical evidence for regulatory court proceedings and financial statements.
  • Perform analysis of property-level financial statements for a portfolio of securitized assets with an outstanding principal balance of $3.3 billion.

Show More

7. SAS

demand arrow
high Demand
Here's how SAS is used in Analytics Consultant jobs:
  • Worked extensively on building and scheduling on Control-M, analytic applications using SAS related products.
  • Designed a clinical messaging system using SAS Marketing Automation suite.
  • Worked extensively on presenting SAS generated data on macro enabled Excel pivots to provide Daily, Weekly and Monthly reporting needs.
  • Experience in design and building of SAS programs to analyze and generate files, tables, listings, graphs and documentation.
  • Provided statistical analysis and SAS programming support for the USPS Transit Time Management System (TTMS) evaluation project.
  • Created permanent formatted SAS data sets and developed reports using PROC REPORT, PROC TABULATE and DATA_NULL for analysis.
  • Develop recurring SAS generated reports, shared dashboards and self-service tools that support front and back office operations.
  • Provide expertise in Disaster related events and reporting as well as Disaster monitoring through GIS data.
  • Design SAS EG processes to create Data Marts to support Managed Care Dept Actuaries in rate-setting
  • Monitored server consumption and issue notifications when necessary, using shell scripting and SAS Macros.
  • Implement test and control matching algorithm for retrospective studies using SAS GLM and Logistic models.
  • Lowered the cost of marketing campaigns by building a response model using logistic regression in SAS that identifies high responders.
  • Used SAS and Excel to perform forecasting and ad hoc statistical analyses on the Trade Desk for Mortgage Backed Securities
  • Provided long term analytical, modeling and SAS programming services for internet, marketing and financial companies.
  • Analyzed large data sets of pharmacy benefit claims data using analytical tools such as SAS, SQL.
  • Used business analytics software such as SAS and the Enterprise Miner and Enterprise Guide products.
  • Managed the for SAS UnitedHealthCare Environment for Clinical Analytics Department.
  • Developed SAS macros to modularize and reuse the code.
  • Used three stats packages to develop models - SAS, BMDP, and Mintab.
  • Managed the SAS EBI migration to SAS Grid and High Performance Analytics/Visual Analytics for the UnitedHealthCare Clinical Analytics Department.

Show More

179 SAS Jobs

No jobs at selected location

8. Data Analysis

demand arrow
high Demand
Here's how Data Analysis is used in Analytics Consultant jobs:
  • Performed detailed source data analysis to determine grain and data quality characteristics.
  • Specialized in CRM data analysis for fortune 500 telecommunications companies.
  • Lead advanced-level Data Analysis in support of standard reporting.
  • Conducted data analysis and consultation on numerous client projects.
  • Perform quantitative data analysis for STARS contract assessments.
  • Create standard process flowchart clarifying data analysis procedures.
  • Access customer database, extract relevant booking fields and build working files to Exploratory Data Analysis and modeling.
  • Performed Data Analysis, Requirement Analysis, Business Modeling, and Use Case Development in Agile environment.
  • Provide consulting services for data analysis, scorecard metrics creation and reporting.
  • Perform data profiling, data analysis, and BI reporting tasks.
  • Worked with new team members to deepen their data analysis skills.
  • Conduct independent testing and data analysis using BSA/AML/OFAC Programs.
  • Direct medical and Rx claims data analysis.
  • Field business-related questions through exploratory data analysis and use Business Objects WebI reports for ad-hoc reporting.
  • Perform data analysis in support of Operations initiatives and inter/intra departmental needs.
  • Analyzed massive and highly complex data sets, performing ad-hoc Data analysis and data manipulation and created source to targeting mapping.
  • Managed Workforce Analytics and Reporting strategies, which included creation of custom metrics, reports, and data analysis projects.
  • Hired to support our client's weekly production forecasts and perform ad hoc statistical/data analysis.
  • Provide complex data analysis to support Humana s reporting efforts in multiple states.
  • Utilized geo, demo and psychographic data analysis to determine price points and venues.

Show More

16 Data Analysis Jobs

No jobs at selected location

9. Pivot Tables

demand arrow
high Demand
Here's how Pivot Tables is used in Analytics Consultant jobs:
  • Prepare cost analyses of products by creating pivot tables of vendors with regard to cost by product type.
  • Created multiple databases to catalog and analyze trends in player performance using SQL and Excel Pivot Tables.
  • Aggregated patient records in Excel using pivot tables and filters achieving provider level summarized data.
  • Market segmentation analysis, projections by linear regression, and pivot tables.
  • Required use of pivot tables, graphs and presentation skills.
  • Use Excel to build reports, creating custom formulas, user entry forms, pivot tables and Lookups for data analysis.
  • Web Analytics dashboards combine disparate data into Excel 2013 then utilize Macros, advanced formulas and pivot tables for automation.
  • Researched and conducted various Lunch N' Learn training seminars that included Excel Pivot Tables and Working in a Strength-Based Environment.

Show More

2 Pivot Tables Jobs

No jobs at selected location

10. ETL

demand arrow
high Demand
Here's how ETL is used in Analytics Consultant jobs:
  • Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, etc.)
  • Performed Dimensional modeling, identified Fact tables to store Measures and Dimension table to store business attributes, before ETL.
  • Developed advance Java-based Regular Expression (RegEx) code to facilitate ETL data extraction and enhance data integrity.
  • Created and maintained metadata and ETL documentation that support business rules and detailed source to target data mappings.
  • Design, configuration and documentation of Logical and Physical Data Model and ETL process & mapping configuration.
  • Prepared the ETL Mapping spreadsheet and Fact Dimension Matrix simultaneously prior to performing the ETL process.
  • Developed an entire application in SAS including the front end, data extraction and ETL transformations.
  • Skilled at ETL operations using SAS/Base, SAS/Advanced, SAS Macro and Enterprise Guide.
  • Developed ETL solutions for data transfer into the EKB data mining application.
  • Used ETL processes to accommodate changes in source systems and new requirements.
  • Involved in ETL code optimization, performance enhancements and code reviews.
  • Experienced in ETL, data modeling, and data warehousing.
  • Included set up of environments, ETL, SAS and SQL testing, Programming, Escalation, Analysis and Signoff.
  • Designed ETL packages to transfer files into SQL Databases and designed reports to present the Data to end-users.
  • Involved in creating some of the ETL mappings from source to target using different transformations.
  • Customized new and existing ETL plans in DAC by importing Sessions and Workflows.
  • Re-defined/optimized of the datawarehouse ETL process (Informatica mappings).
  • Involved in developing the Incremental ETL process using Oracle PL/SQL packages, and Informatica Mappings & Mapplets using various Transformations.
  • Based on USER's requirement, worked on Informatica ETL mappings and populated the new columns into OBIEE Analytics.
  • Installed Analytics Server and Informatica ETL/DAC platform components in Development & Test Environment.

Show More

16 ETL Jobs

No jobs at selected location

11. R

demand arrow
high Demand
Here's how R is used in Analytics Consultant jobs:
  • Contributed to founding organizational structure of enterprise wide cognitive computing strategic deployment.
  • Designed and implemented client-specific research studies on integrated pharmacy and medical data.
  • Drive automation capabilities into reporting solutions.
  • Acquired and maintained product and program knowledge to effectively communicate financial values and outcome projections of services to clients.
  • Presented actionable marketing strategy recommendations to client's management, uplifting revenues for core brands by 50%.
  • Prepare and vet analysis plans and expected outcomes to ensure business needs will be met.
  • Identify key product metrics and help create a framework for creating meaningful reports and dashboards.
  • Advise on development of and derive actionable business insights from claims data.
  • Completed seven strategic and SaaS client engagements.
  • Consulted with clients to validate the ability of a differential mobility spectrometer (DMS) to distinguish between aerosolized biological substances.
  • Supervised pharmacy POC for training, developing and deploying IBM Watson cognitive solution for self-service and clinical bioinformatics applications.
  • Influence and aid in the optimization of digital analysis and tactics across the Deckers Direct-to Consumer Organization
  • Develop interactive dashboards offering analytical and reporting solutions.
  • Sourced deals from $5-20 million for producers in need of capital for pre-production, print, advertising and final distribution.
  • Develop, create Chinese text categorization rules to specific industries; analyze & proofread survey feedback from customers of clients.
  • Provide analytical chemistry expertise on a consulting basis to companies in the Boston area.
  • Experienced in project management, data analytics, and process improvement.
  • Power Point Decks no longer needed).
  • Maintained facts regarding healthcare marketplace, pharmacoeconomics, and outcome reporting.
  • Please see www.deloitte.com/us/about for a detailed description of the legal structure of Deloitte LLP and its subsidiaries.

Show More

12. Key Performance Indicators

demand arrow
high Demand
Here's how Key Performance Indicators is used in Analytics Consultant jobs:
  • Created Microsoft Excel dashboards and reports on daily weekly basis analyzing key performance indicators using Adobe Report Builder.
  • Provided monthly traffic analysis and key performance indicators reports for 30+ local franchisees.
  • Create, design and implement Webtrends reports, custom views, Key Performance Indicators, management dashboards, and scorecards.
  • Conducted ad hoc gap analysis (e.g., behavioral segmentation) of key performance indicators to identify opportunities.
  • Key Accomplishments: Designed, monitored & analyzed daily, weekly and monthly key performance indicators report.
  • Create and maintain monthly metric dashboard to measure web site performance against key performance indicators.
  • Prepared regular ad-hoc reports with key performance indicators (KPIs).

Show More

8 Key Performance Indicators Jobs

No jobs at selected location

13. ROI

demand arrow
high Demand
Here's how ROI is used in Analytics Consultant jobs:
  • Initiated and guided ROI analysis to evaluate direct marketing strategies which identified incremental profitability of $13 million.
  • Formulate statistical modeling algorithms for use in predicting customer behavior, optimizing campaign response and maximizing ROI.
  • Managed paid search, SEO & PPC campaigns across multiple engines and ensure program specific ROI goals are being met.
  • Worked to create financial projections of potential benefit changes, by identifying the cost and any potential ROI.
  • Provided program optimization analyses to create ROI based comparative tools for campaign, media and tactic level evaluations.
  • Analyze marketing campaign performance for AutoNation by measuring key performance metrics such as ROI and response rates.
  • Consulted on coding software use and edit system, denials, ROI and effective delivery.
  • Utilized random forest algorithm to help optimize ROI of an email marketing campaign.
  • Recommended online media for highest ROI based upon Google Analytic trends and statistics.
  • Performed ROI, break even analysis & risk analysis to evaluate project feasibility.
  • Analyzed and reported on campaign performance ROI and delivered presentations to clients.
  • Designed and executed return-on-investment (ROI) studies on disease management programs.
  • Structured 2009 marketing model, ROI modeling and media benchmarks.
  • Determine promotional sales lift and ROI for each in-store event
  • Documented ROI of these systems was 10 to 1.
  • Tested dashboards on desktop and Android devices
  • Measured and reported performance of all major digital marketing campaigns, and assess against goals (ROI and KPIs).
  • Performed debugging to enable end-to-end, client-facing testing of websites and mobile apps for iOS and Android platforms.
  • Provide clients with decision tools using objective analysis, reports, and comprehensive ROI dashboards.
  • Build data models for Quantitive Analysis using Alteryx software for Supply Chain ROI.

Show More

14. Siebel

demand arrow
high Demand
Here's how Siebel is used in Analytics Consultant jobs:
  • Developed different reports using pivots, charts, global and local filters using Siebel Answers.
  • Worked Extensively on Siebel Answers to create the reports as per the client requirements.
  • Participated in testing Data matching between Siebel and OBIEE Databases and Dashboards.
  • Implemented Siebel SFA, Call Center & Sales v99.
  • Performed all the activities on Siebel Analytics - Presentation Services, Server, Repository, catalog Manager and Data sources.
  • Developed user training materials to educate user group with new Siebel functionalities and UI presentation layers.
  • Associated with interfacing teams from Siebel perspective to provide information on Data Mapping relating to Siebel.
  • Created templates for presenting results and Analytics and modified the Siebel Dashboard using cascading style sheets.
  • Used Session variables and Created group accesses and privileges for the Siebel Analytics Web reports.
  • Worked extensively on Siebel applications (Siebel Answers, Delivers, and Dashboards).
  • Supported the existing production issues on EDW and Siebel Analytics.
  • Worked with Siebel Analytics Dashboards to create Dashboards and pages.
  • Developed Dashboards and Reports for users through Siebel Analytics Web.
  • Created Users and user groups in Siebel Analytics web.
  • Configured Column and Dashboard Filters in Siebel Analytics.
  • Created/Modified Metadata repository (.rpd) and Configured Metadata Objects using Siebel Analytics Server Admin tool.
  • Worked with Siebel Analytics Delivers to create and schedule iBots.
  • Performed Gap analysis (data-model (star schemas,...)) between Siebel Analytics and the user needs.
  • Created Test Cases for Siebel Analytics Admin Functionalities and iBots.
  • Worked extensively on Siebel Answers, Siebel Delivers, and Siebel Intelligent Dashboards for Compliance department using Siebel Analytics stand-alone/integrated implementation.

Show More

15. Google Analytics Premium

demand arrow
average Demand
Here's how Google Analytics Premium is used in Analytics Consultant jobs:
  • Diagnose the issues, advantages of having to migrate from WebTrends to Google Analytics Premium.

Show More

16. Informatica

demand arrow
average Demand
Here's how Informatica is used in Analytics Consultant jobs:
  • Developed Informatica Mappings using various transformations for ETL enhancements of Items, Components Cost and Vendors information.
  • Worked on various Informatica mappings as per business requirement.
  • Designed & Reviewed the ETL Routines (SDE and SIL mappings in Informatica) to populate the Warehouse Tables.
  • Load All Opportunity Prospect Contacts, Customer Surveys to Contact Fact/Survey Fact OLAP Using Informatica 5.
  • Involved in Informatica Mappings migration from DEV to QA, QA to Prod.
  • Used Informatica to load data from Flat Files to Oracle using various transformations.
  • Evaluated data quality solutions from SAP, Pitney-Bowes, Informatica and Data- Flux.
  • Implemented the session partitions (Database and Informatica) for performance issues.
  • Designed the ETL for sales measures using Oracle PL/SQL and Informatica.
  • Developed many incremental ETL using Informatica mappings & Oracle PL/SQL procedure.
  • Created Informatica mappings for initial load and daily updates.
  • Developed SDE to SIL mappings in informatica.
  • Created business term definitions to the Customer Business Glossary and uploading it to the Informatica Business Glossary.
  • Developed ETLs for Data Extraction, Data Mapping and Data Conversion using Informatica Power Center 7.1.
  • Maintained extensive documentation for design, implementation and testing Siebel Analytics reports, Dashboards and Informatica mappings.
  • Executed Informatica SDE/SIL ETL mappings to populate Siebel Pharma facts/dimensions.
  • Designed eFannie inbound Interface from XML Siebel EIM (Opportunity/Account/Contact) using Informatica ETL Session.

Show More

12 Informatica Jobs

No jobs at selected location

17. Project Management

demand arrow
average Demand
Here's how Project Management is used in Analytics Consultant jobs:
  • Project Management of multiple high-profile projects.
  • Received a Star Performance Award for proactive project management and implementation, as well as outstanding client service performance.
  • Helped architect a new project management system to track billable time and monitor consultant/vendor costs.
  • Created and maintained QlikView dashboards for various Project Management metrics.
  • Designed and rolled out automated Excel reports to enhance project management through tracking resource utilization and resource scheduling.
  • Managed all inter-company allocations, client invoicing and project management analytics.
  • Provide Project Management support on scheduling, sizing estimates, and project communication for midrange projects.
  • Prepare & present analytical reports to non-technical Executive Management Project Management of multiple high-profile projects.

Show More

19 Project Management Jobs

No jobs at selected location

18. Teradata

demand arrow
average Demand
Here's how Teradata is used in Analytics Consultant jobs:
  • Develop logic and SQL queries to translate existing reporting cross platform to Teradata requiring comprehensive understanding of financial metrics.
  • Distributed data residing in heterogeneous data sources, is loaded to target Teradata database.
  • Migrated existing controls from an SAS/UNIX/Oracle environment to a SAS/UNIX/Teradata environment.
  • Utilized SAS/CONNECT for implementing queries, extracting and manipulating data on Teradata
  • Performed Teradata/SAS consulting and SAS administration for large several large US Retailers.
  • Utilized SAS, SQL, Teradata, Oracle, and UNIX.
  • Used SAS/ACCESS to read datasets from Teradata Databases, Flat files, also read and write other PC File formats.
  • Used Tableau, Excel, OBIEE dashboards, Teradata, Datameer as necessary.

Show More

38 Teradata Jobs

No jobs at selected location

19. Unix

demand arrow
average Demand
Here's how Unix is used in Analytics Consultant jobs:
  • Point person within the team to manage space, batch id and automation within UNIX.
  • Modified and enhanced SAS code for migration to Unix platform from a Windows platform.
  • Created scripts in UNIX to help improve the efficiency of the application.
  • Design process was done using a combination of UNIX and PC SAS.
  • Developed Unix and Linux shell to run the EIM jobs.
  • Conduct monthly data transfers from Mainframe to UNIX environment using sftp and NDM.
  • Developed complex unix shell scripts for the batch loading.

Show More

1 Unix Jobs

No jobs at selected location

20. KPI

demand arrow
average Demand
Here's how KPI is used in Analytics Consultant jobs:
  • Generated and maintained weekly/monthly KPI reports.
  • Decreased wasteful image requests by ~500% site wide with a focus on optimized information pertaining to relevant KPI and CRO.
  • Supported senior management in setting goals and KPI's for the entire division.
  • Designed Intelligent Dashboards for different user groups to view updated KPI's.
  • Facilitated Design sessions to develop LOB Subject Areas and identify KPI's.
  • Designed & developed key departmental automated reports and KPI Dashboards.
  • Developed Executive dashboards and other dashboards for KPI tracking.
  • Created dashboard and Monitored KPI's as needed.
  • Create KPI for model performance monitoring and tracking.
  • Analyze the KPI of multichannel marketing promotions and provide fine-tuned customized marketing campaign at channel level.
  • Consulted with business areas to develop specific KPIs and reporting capabilities.
  • Collected requirements to track identified appropriate KPIs and tracked corresponding metrics.
  • Presented monthly, quarterly and annual KPIs to content owners, leaders and stakeholders that support resource alignment and business planning.
  • Created financial management dashboard, KPI and sales performance metrics reporting for Visionworks (formerly Eye Care Centers of America).
  • Work with LOB to develop an effective set of dashboards, reports, KPIs and metrics.
  • Create and enhance executive and operational NPS KPIs with complex SSRS reports and dashboards.
  • Develop KPI's and analyze web traffic using Google Analytics.
  • Consult for e-commerce clients to set up their KPIs in analytics, increase conversions.
  • Translated 5-year strategic plan into digital KPIs to track website performance Resolved analytics implementation to generate 400% more visitor data
  • Experienced in interpreting metrics and KPI's to determine "how" and "why" a business is performing.

Show More

21. CRM

demand arrow
average Demand
Here's how CRM is used in Analytics Consultant jobs:
  • Developed and delivered Customer Relationship Management (CRM) presentations to sales, financial and marketing executives of Fortune 100/500 companies.
  • Provide analytic support to translate data from the CRM database to actionable customer insights.
  • Represent Epsilon at client s office (Fashion Retailer s CRM team).
  • Manage executive dashboards and reports for the client s CRM team.
  • Trained internal staff on CRM marketing strategy & business processes.
  • Related data sources were derived from Siebel CRM as well as numerous enterprise applications, retail and supply chain systems.
  • Build CRM subscriber databases, fixed faulty email addresses, remove dups.
  • Share of Wallet modeling: CRM offer versioning.
  • Performed setting up of complete Siebel analytics environment and the required connectivity for integration with CRMR Data Warehouse.
  • Assessed cross-brand 80 mil record database for broadcast client including CRM, Adobe Analytics and 3rd party demos.
  • Managed migration/upgrade from Siebel v6 to Siebel v7.8 (Siebel CRM & Siebel Financial Analytics systems).

Show More

22. Powerpoint

demand arrow
average Demand
Here's how Powerpoint is used in Analytics Consultant jobs:
  • Coordinated research projects across teams, and provided updates using weekly PowerPoint presentations.
  • Develop automated Dashboard reports in excel and PowerPoint.
  • Create and maintain monthly and quarterly executive decks using Excel and PowerPoint for a wide audience including senior management.
  • Communicate with Management to gather requirements of data to be analyzed and created in both Excel and PowerPoint.
  • Created a metric based PowerPoint presentation for the CEO to present to the bank's board of directors.
  • Performed statistical analysis and prepared presentations on the data obtained (Excel and PowerPoint).
  • Backed different strategies by showing data and charts as PowerPoint presentations to senior management.
  • Create PowerPoint presentations that provide clear, compelling, actionable cost drivers and solutions.
  • Translate specifications, findings, recommendations into PowerPoint and present in meetings.
  • Created several PowerPoint presentations for the leaders.
  • Utilize PowerPoint and advanced communication skills to walk high level technical and non-technical clients through analytics findings and processes.
  • Create, deploy & present process maps in Microsoft Visio & PowerPoint.

Show More

9 Powerpoint Jobs

No jobs at selected location

23. Google Analytics

demand arrow
average Demand
Here's how Google Analytics is used in Analytics Consultant jobs:
  • Evaluated online presence through Google Analytics to develop advertising promotions to increase brand awareness while tracking website interactions.
  • Tested and deployed Google Analytics and Google Tag Manager accounts for multiple Health and Human services public web sites.
  • Documented a cookbook for the marketing team with clear instructions on how to create various reports using Google Analytics.
  • Developed custom dashboards and reports in Google Analytics to more easily measure performance toward key goals.
  • Installed Google Analytics software on their sites, and ran reports for these organizations.
  • Utilize Google Analytics data to bolster clients digital marketing strategies and derive insights.
  • Worked with Google analytics team to incorporate their experiences, specially holiday traffic.
  • Involved in identifying trends, patterns and paths using Google Analytics.
  • Implemented Google Analytics and Google Tag Manager (2011).
  • Web Tools: Google analytics, Google Tag Manager
  • Worked on Google Analytics reporting.
  • Implement Google Analytics including page tags, conversion tracking, custom events, and ecommerce tracking using Google Tag Manager.
  • Created unifying methods to track Google Analytics data with the Web Trends data and Netezza Warehouse Data.
  • Created and exported custom reports in Google Analytics to facilitate business decisions using KPIs.
  • Analyzed Web Analytics reports through adobe Analytics and Google Analytics to provide insight on trends to management.
  • Use of Adobe Analytics, Google Analytics, Tealium Tag Manger, and Microsoft tools.

Show More

4 Google Analytics Jobs

No jobs at selected location

24. Omniture

demand arrow
average Demand
Here's how Omniture is used in Analytics Consultant jobs:
  • Managed strategic vendor relationships and client engagements with Adobe & Omniture (Consulting, Training, ClientCare) and Radian6.
  • Managed Omniture software releases for code deployed globally.
  • Develop and maintain reports, dashboards, and scorecards for mobile unit using Omniture Site Catalyst and Google Analytics Reporting Tools.
  • Developed, deployed and manage Site Catalyst (Omniture) and Tealium integration.
  • Manage Omniture implementation and use for Starwood Hotels.
  • Build out data structure and implement tools including Adobe Analytics(Omniture) and Google Analytics.

Show More

25. Python

demand arrow
average Demand
Here's how Python is used in Analytics Consultant jobs:
  • Performed general system administration and automation tasks with bash and Python.
  • Led analysis of R&D efforts, summarizing findings in Python notebooks and presenting findings to project leadership.
  • Set up a Python script that tracks, scrapes, and analyzes relevant social media content.
  • Combined and analyzed data using Python to quantify previously unknown user behavior on the site.
  • Utilize expert technical skills including SQL and Python to perform influential analysis.
  • Worked extensively on R, Python, SQL and PostgreSQL.
  • Build predictive analytics using R, Python, and command line tools for call center optimization.
  • Developed Python application to manage petabyte-scale benchmarking across 90+ servers in a sharded database architecture.

Show More

26. VBA

demand arrow
average Demand
Here's how VBA is used in Analytics Consultant jobs:
  • Developed and implemented an application to load large data sets into SQL Server 2008 R8 tables using MS-Access 2010/VBA.
  • Used Excel, SQL, VBA, and Business Objects to automate processes and saved over 1,000 hours annually.
  • Migrate all MS Access DB to SQL server DB using ETL SSIS and convert VBA codes into stored procedure.
  • Developed tools in excel (VBA macros) to automate frequently used processes.
  • Automated once a month manual mapping process using VBA.
  • Automated screen scraping in SEI using VBA.
  • Design an automated VBA tool which generates insurance recommendations for employers reducing turnaround time significantly.
  • Scripted automated VBA/Ruby analytics dashboards allowing clients to receive real time updates on improvement.
  • Developed tools by leveraging VBA scripts and ipython, streamlining the data management of Balance Sheet data across three fiscal years.

Show More

27. Workflow

demand arrow
average Demand
Here's how Workflow is used in Analytics Consultant jobs:
  • Identified process workflow gaps and recommended areas for improvements.
  • Used power center workflow manager for session management, database connection management and scheduling of jobs to be run.
  • Interview Application Leads and Users to understand departmental workflows & data, gather and document report specifications.
  • Worked extensively on Workflow, Validation rules, Triggers, Classes, Page Layouts and application enhancements.
  • Solved workflow challenges by automating certain job steps and eliminating wasted time and motion.
  • Used Workflow Monitor to monitor the performance of the Jobs.
  • Monitored the process flows using Oracle Workflow monitor.
  • Deploy Process Flows to the workflow manger.
  • Implemented data and workflow management tools.
  • Managed workflow manager, repository manager, designer and workflow Monitor.
  • Performed Unix shell developments to encapsulate the Informatica workflows.
  • Implemented Interfaces between the Siebel implementations and the back-office systems using workflows, EIM, EAI, ActiveX and XML.
  • Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Batches of sessions and workflows.
  • Worked on Workflow Groups, Work Policies, Workflow Process and Business Services.
  • Worked on Mapping designer, workflow designer, workflow monitor etc.
  • Created and Configured Workflows, Work lets and Sessions to transport the data to target warehouse tables using Informatica Workflow Manager.
  • Performed Informatica developments (mapping, workflows, scheduled sessions and batchs).
  • Performed Linux shell developments and enhancements to the existing Unix shell to encapsulate the Informatica workflows and run the Analytics dataloads.
  • Used Workflow manager and Workflow monitor for Workflow, sessions and database connection management and workflow monitoring.
  • Designed worklists and basic/generic workflows Managing worklists and basic workflows.

Show More

5 Workflow Jobs

No jobs at selected location

28. Business Model

demand arrow
average Demand
Here's how Business Model is used in Analytics Consultant jobs:
  • Identify areas of business opportunity and recommend redevelopment or new business models as and when required.
  • Created Aggregated Tables and Configured the Content in Business Model Layer to use the Aggregate Tables for better Performance.
  • Enhanced existing Business Models & created Customized Dashboards for revenue ratio reports for North America and Asia Pacific regions.
  • Configured measures in the Business Model Layer and mapped to multiple logical source tables.
  • Identified conversion and buy rate drivers based on business model simulations.
  • Exposed various business models in the presentation layer for querying.
  • Developed business model for contract lab function.
  • Developed business model for Business Analytics to service Sales and Marketing organizations; Collaborated with external partners to optimize business resources.
  • Create business models to analyze Analytic health of different EBay assets.

Show More

3 Business Model Jobs

No jobs at selected location

29. Toad

demand arrow
average Demand
Here's how Toad is used in Analytics Consultant jobs:
  • Used different application development tools like TOAD (Oracle).

Show More

30. Business Partners

demand arrow
low Demand
Here's how Business Partners is used in Analytics Consultant jobs:
  • Added transparency to IT operations by developing strong business partnerships and formalizing the lines of communication.
  • Conducted post campaign analysis with operational and financial summary for upper management and business partners.
  • Consult with HR business partners about engagement survey interpretation and strategic use.
  • Interacted with business partners to develop actionable execution processes.
  • Consult with business partners on analytic solutions to drive value for commercial, Medicare and Medicaid lines of business.
  • Provide consultative support to business partners on appropriate use of data the application of reporting and quality assurance standards.
  • Partnered with IT and business partners to determine data feeds, table structures, and appropriate system resources.
  • Identify improvements at clients and business partners to realize process enhancements and cost savings.
  • Engaged external and internal business partners to meet the business needs of internal clients.
  • Provide consultation to business partners and leads cross-functional teams to address business issues.
  • Worked with team members to summarize and present information to business partners.
  • Interact with non-technical team members and business partners to follow internal processes.
  • Solved business analytics problems by obtaining data, developing descriptive statistics, assisting business partners in identifying and investigating opportunities.
  • Engage business partners to determine their business requirements, analytical needs and recommend process improvements.
  • Provide analytical support to answer questions from business partners and regulators.
  • Consult with internal business partners regarding reporting and analytics projects.

Show More

93 Business Partners Jobs

No jobs at selected location

31. Sharepoint

demand arrow
low Demand
Here's how Sharepoint is used in Analytics Consultant jobs:
  • Created SharePoint documentation of current processes and existing procedures.
  • Maintain and create communities within SharePoint as they relate to relevant users for content, information, and updated relevant attachments.
  • Generate reports in MS SharePoint to understand the trends of the team's day-to-day operations in the change management process.
  • Use of SSIS packages within BIDS -Business Intelligence Development Studio to move data in and out of SharePoint.
  • Completed and uploaded Vendor Profiles and Inherent Risk Questionnaires (IRQ) to VMSOR and SharePoint.
  • Utilize SharePoint for collaboration of tasks, projects, documents, and creation of surveys.
  • Managed SharePoint Site by granting and removing access.
  • Used SharePoint for sharing and deploying the reports.
  • Analized SharePoint security settings, developed and implemented policies and procedures for streamlining SharePoint usage.
  • Managed Outlook and SharePoint customer relationships for any program issues/gaps and/or discrepancies.Program Manager
  • Enhanced existing SharePoint site to create lists, develop web forms, architect layouts and file structures, and managepermissions.
  • Acted as a SME regarding data and business rules, leveraging Project, Visio and SharePoint.
  • Created a workflow tool in SharePoint to document and track the status of performance reporting.
  • Developed SharePoint workspace to collaborate with co-worker on monthly reporting tasks and issues.
  • Created an Analytics request form list using InfoPath in SharePoint streamlining the analytics request of the supply chain management department.
  • Created and published ad-hoc and scheduled reports via Access, Excel, and Sharepoint.
  • Export CSV and Text Data from various Business Systems including resting APIs Maintain Analytics SharePoint, Security/Visibility settings and workflow.

Show More

32. Predictive Models

demand arrow
low Demand
Here's how Predictive Models is used in Analytics Consultant jobs:
  • Designed predictive models to forecast workforce growth and requirements and utilized the results to quantify associated budget implications.
  • Project Description: Developed predictive models and conducted statistical analysis using SAS.
  • Designed and implemented actionable predictive models of user behavior.
  • Oversee and direct the work of other statisticians who build predictive models and cluster/segmentation solutions.
  • Assist in developing predictive models to evaluate potential clients.
  • Helped develop methodologies for improving predictive models and executed targeted promotional campaigns.
  • Advised multiple startups on creating meaningful metrics on sales, marketing, conversion, growth and creating predictive models/algorithm as required.

Show More

33. A/B

demand arrow
low Demand
Here's how A/B is used in Analytics Consultant jobs:
  • Worked on Adobe Target implementation and performing A/B testing campaigns to increase conversion rates and maximize user experience.
  • Developed A/B test plan and methodology, streamlining efforts and improving efficiency of process 40%.
  • Led planning, measurement, and execution efforts for A/B testing and deep-dive analysis.
  • Developed A/B testing campaigns to increase conversion rates and maximize user experience.
  • Managed optimization, A/B and multivariate tests for redcross.org donation purchase funnels using Visual Website optimizer.
  • Leveraged analytics to drive positive impacts in support of business and created structure for A/B campaign testing online.
  • Developed various A/B tests and MVts for analyzing customer web interactions.
  • Performed site optimizations using tools like A/B and Multivariate testing in conjunction with Omniture analytics data through tagging.

Show More

34. Ssrs

demand arrow
low Demand
Here's how Ssrs is used in Analytics Consultant jobs:
  • Worked on Report generation using SQL Server Reporting Services (SSRS) that could be used to send information to Client.
  • Generated Drill down and Drill through reports with Drop down option, sorting the data and defining subtotals in SSRS 2012/2008/2005.
  • Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
  • Assessed requests and recommended solutions for reporting in either SSRS, SAS or MS products based on business need.
  • Created and developed query for Tabular and Matrix Reports using SQL Server 2008 Reports Services (SSRS).
  • Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
  • Create, develop and deploy tabular, matrix, list, drill-down, drill-through using SSRS.
  • Promoted Reporting Definition Language (RDL) to Reporting Service Server (SSRS).
  • Created and deployed SSRS reports on the portal for user accessibility.
  • Constructed a model that breaks value down by component in SSRS.
  • Create report Dashboard using HTML and administer SSRS report manager.
  • Create Global banking Dashboard and Wholesale Partner Dashboard using SSRS.
  • Experienced in pulling reports using Crystal Reports and SSRS.
  • Designed SSRS reports for month-end accounting processes.
  • Convert MS Access Reports to SSRS.
  • Developed reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS.
  • Used SSRS to develop different kinds of reports like canned, ad-hoc reports for the marketing and finance users.
  • Created Drill-through reports, parameterized reports and linked reports using SSRS 2005 and 2008..
  • Conceptualized and developed Microsoft SSRS and Power View dashboards to visualize the defined metrics.
  • Used SSRS to develop different kinds of reports like canned, ad-hoc reports.

Show More

43 Ssrs Jobs

No jobs at selected location

35. QA

demand arrow
low Demand
Here's how QA is used in Analytics Consultant jobs:
  • Review implementation specifications and perform QA on new implementation projects.
  • Developed Repository by checking out and checking in into Repository and done migration from DEV, QA to PROD environments.
  • Analyze NCQA, UDS & Meaningful Use data sets for Federally Qualified Health Centers.
  • Provide guidance to develop tagging framework and provide QA support.
  • Involved in Moving the RPD from DEV to QA, QA to PROD.
  • Automated manual project status tracking processes QA all data before submission to Health Plans to assure it as Medicare compliant
  • Perform data QA on reports to ensure validity of results for campaigns and ad hoc request.
  • Provided Adobe Analytics Solution expertise and QA d all sites and implementations successfully.
  • Work with the Testing/QA team to debug/test the web analytics tags.
  • Coordinated the Analytics RPD and Web Catalog objects migration from Dev environment to QA environment and to the Production environment.
  • Migrated Jobs, RPD and Webcat from development to QA to Production environments Defined production support methodologies and strategies.

Show More

36. XML

demand arrow
low Demand
Here's how XML is used in Analytics Consultant jobs:
  • Added assertions to validate the response XML with database.
  • Modified Cascading style sheets and XML message files.
  • Validated WSDL, request and response XML.

Show More

37. Business Units

demand arrow
low Demand
Here's how Business Units is used in Analytics Consultant jobs:
  • Optimized IBM targeting and client stratification strategies across multiple business units and emerging markets with propensity modeling and clustering analysis.
  • Performed predictive modeling for new initiatives to support expansion of theme park operations in for operations and marketing business units.
  • Fostered relationships with assigned business units to understand business needs and objectives to identify and deliver appropriate sourcing solutions.
  • Collaborate with business units to define business requirements and establish testing documentation.
  • Consulted with MetLife business units to develop measurement solutions for online businesses.
  • Identified and reported populations of non-compliance to business units and management.
  • Ensured that assigned business units achieved externalization / internalization sourcing targets.
  • Created and executed marketing measurement plans for Retirement business units.
  • Provided actionable marketing optimization insights across several business units.
  • Led the market basket analyses for multiple business units that optimized product portfolios and joint marketing effort to boost cross-selling.
  • Created hierarchy based Sales Card Dashboards for different Business units and end users.
  • Work closely with internal and client business units to facilitate project completion.
  • Managed coordinate Data Governance initiative across multiple Business Units, to standardize business definitions for reporting to Customer Financials Services group.
  • Developed and implemented self-sustainable revenue generating reporting templates in Cognos for key Business Units.
  • Assisted with ad hoc reporting as requested by the business units in which I supported.

Show More

3 Business Units Jobs

No jobs at selected location

38. Pl/Sql

demand arrow
low Demand
Here's how Pl/Sql is used in Analytics Consultant jobs:
  • Developed, tested Store procedures, Functions and packages in PL/SQL for Data ETL Performed Data conversions.
  • Used many pre-processing, post-processing, and validations scripts using Oracle PL/SQL.

Show More

39. SEO

demand arrow
low Demand
Here's how SEO is used in Analytics Consultant jobs:
  • Assisted small education start-up understand their customer base, focusing on search engine optimization (SEO), and platform growth.
  • Tracked SEM campaigns, keyword placements, and optimized SEO.
  • Generated reports to help upper management understand analytics data and implement SEO based improvements to all online content.
  • Provided SEO insights and recommendations based on clickstream data from multiple reporting tools and site evaluations.
  • Provided Weekly Update to Founder on Website Traffic Quality and Quantity Managed Advertisement Buying Conducted SEO research and SEO Audit
  • Managed digital analytics, Google Analytics, AdWords and SEO/SEM activities resulting 91% brand awareness increase.

Show More

40. Ssis

demand arrow
low Demand
Here's how Ssis is used in Analytics Consultant jobs:
  • Provide project management support between internal customers and production teams, assisting in the interfacing with customers and gathering requirements.
  • Supported database construction and analytic activities, including assisting with the development of test plans and data quality resolution strategies.
  • Communicated with hospital leadership by assisting in meeting TJC requirements/ISMP standards improving productivity, efficiency and device utilization.
  • Provided assistance, training and support to business partners on the policies & procedures of the reconciliation governance tool.
  • Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.
  • Assisted with post go-live EPIC reporting & data needs in the Pharmacy (Willow Ambulatory) Data Model.
  • Assisted with Business Development and Sales efforts by developing presentations to expose value of new solutions.
  • Designed and Developed SSIS Staging Packages to Stage Source files to SQL Server Source Database.
  • Assisted in sales efforts to large utility, premium retail, pharmaceuticals and advertising companies.
  • Assist in the creation of waterfall to determine optimal population for direct mail marketing campaigns.
  • Assisted in the project requirement gathering process, creating BRD and test cases.
  • Modified the existing SSIS packages to meet the changes specified by the users.
  • Involved in Loading Dimension with the SSIS slowly changing Dimension Wizard.
  • Experience in performance tuning of SSIS Packages using row transformations.
  • Deployed SSIS packages from Development to Testing Servers.
  • Assist clients to research business and technical solutions.
  • Assisted QC and Stability in OOS investigations and troubleshoot of analytical issues for HPLC, GC, and dissolution.
  • Assist with internal development and created new Advantage Suite Basic and Advanced healthcare analytic documentation for training.
  • Investigate data abnormalities, perform root cause analysis and assist in resolving workflow & process issues.
  • Developed an Excel based pivot table scorecard to assist with analysis of claims data.

Show More

41. Cognos

demand arrow
low Demand
Here's how Cognos is used in Analytics Consultant jobs:
  • Conducted in-depth analyses of guest satisfaction data using SQL, R, PowerPivot and Cognos.
  • Install Cognos Finance and Develop ledger scripts for automatic loading from EPA Data mart.
  • Set up a reporting environment using Cognos 10 using data from Sage Millennium.
  • Create ad-hoc reporting solutions using MS Access, MS Excel, MS PowerPivot and Cognos BI.
  • Develop MS SQL based Data mart for Finance and Sales using Cognos/BPCS EPA modules and Decisionstream.
  • Created business intelligence reports, dashboards and visualizations on IBM Cognos Analytics.
  • Develop dashboards in Cognos according to wireframe.
  • Engaged in the entire life cycle development of development of Cognos Architecture conceptualize, design, develop and deploy.

Show More

1 Cognos Jobs

No jobs at selected location

42. Obiee

demand arrow
low Demand
Here's how Obiee is used in Analytics Consultant jobs:
  • Involved in designing and developing the RPD in OBIEE at all the levels of physical, business and presentation models.
  • Enhanced and designed the reports in OBIEE for Various Horizon and Snapshot date dimensions in STAR design.
  • Implemented the IBOTS for the Forecast Accuracy release and assigned the groups in OBIEE front end.
  • Implemented the row level security in OBIEE having the interface of the ORACLE Apex tool.
  • Managed and provided Permissions for Reports and Dashboards in OBIEE Presentation Services Web Catalog.
  • Implemented Data Level Security for Non-Obiee Users by creating Variables and Initialization Blocks.
  • Lead Business Intelligence (OBIEE) reports development efforts for Basel II program.
  • Used the OBIEE 10.1.3.x, to develop and enhance meta-data.
  • Set up Usage tracking and Scheduler in OBIEE.
  • Involved in full Life Cycle Implementation of OBIEE.
  • Implemented Supply Chain Subject Area in OBIEE.
  • Involved in business requirements analysis and achieved the functionality by designing the hierarchy and the OBIEE security.
  • Finance Industry * Customized unique reports for Procurement, Spend, & Human Resources using OBIEE.
  • Worked on Automation of report's package (Dashboard) to Non-obiee users using IBOTS.
  • Implemented the delivery of iBots Using OBIEE Delivers to alert the associated teams.
  • Migrated Essbase (Hyperion) data source into OBIEE Administrator tool.
  • Created monthly report and ad hoc reports from OBIEE.
  • Configured OBIEE iBots to deliver Analytics content based on schedule, automated iBots queries to obtain daily and weekly reports.
  • Used the OBIEE/Siebel Analytics Administration tool to develop and enhance meta-data and generate reports.

Show More

43. Statistical Models

demand arrow
low Demand
Here's how Statistical Models is used in Analytics Consultant jobs:
  • Perform exploratory analysis of the data and identify justified business factors that should be considered in the statistical models.
  • Developed statistical models to explain and predict economic indicators like unemployment claims.
  • Developed statistical models, segmentation schemes, Decision Tree and data-driven analyses.
  • Created statistical models, including linear, logistic and non-parametric models.
  • Programmed tools for debugging statistical models.
  • Design and implement complex statistical models daily to derive actionable insights and KPIs that support previously established content goals.

Show More

38 Statistical Models Jobs

No jobs at selected location

44. Spss

demand arrow
low Demand
Here's how Spss is used in Analytics Consultant jobs:
  • Conducted statistical study using SPSS on treatment effectiveness for global pharmaceutical firm.
  • Conducted statistical analysis of marketing data using R and SPSS and provided insight that improved revenue by 15%.
  • Invented the new data integration strategy and reporting automation processes for IBM customer satisfaction survey program through SPSS Modeler.
  • Acted as lead to create SPSS Modeler streams, performing data preparation, integration, audit and quality.
  • Conducted Market Research, Data Collection, Analysis and Segmentation using SPSS for ZOOS Greek iced tea.
  • Tested using ETL and database process versus using server software to open larger SPSS files.
  • Assisted in integrating InfoSphere Streams, Infosphere BigInsights, Cognos, SPSS and data modeling on SoftLayer cloud.

Show More

45. Large Data

demand arrow
low Demand
Here's how Large Data is used in Analytics Consultant jobs:
  • Developed firm knowledge of Excel, Tableau, SQL/SAS, R and large data set manipulation.
  • Manage large databases and implements additional testing queries to select high-risk assets and mitigate audit findings.
  • Analyze very large datasets to find tractable and actionable insights by developing reports and building logistic and linear models.
  • Compile and analyze large data sets, identifying anomalies and overpayments to drive cost recoveries and process improvements.
  • Analyze large datasets and prepare reports regarding Credit Risk for stakeholders.

Show More

46. Sitecatalyst

demand arrow
low Demand
Here's how Sitecatalyst is used in Analytics Consultant jobs:
  • Managed day-to-day SiteCatalyst relationship with Adobe and Client Care.
  • Provide Adobe SiteCatalyst tagging requirements, testing and validation across the desktop, mobile and tablet platforms.
  • Champion, design and implement SiteCatalyst dashboards for individual GPLT's (Global Product Line Teams).
  • Offer customers advices on common implementation practices, using JavaScript and business usage of SiteCatalyst reporting and related digital marketing tools.
  • Facilitate SiteCatalyst trainings and created SiteCatalyst training video along with accompanying documentation.
  • Implemented and configured the new SDK for SiteCatalyst (Omniture) to track the performance over web.
  • Web Tools: Adobe Insight, Adobe SiteCatalyst, Adobe Hitbox and Unica NetInsight.

Show More

47. DB2

demand arrow
low Demand
Here's how DB2 is used in Analytics Consultant jobs:
  • Developed reports for customer and internal utilization using Business Objects Web Intelligence to pull data from DB2 databases.
  • Integrated knowledge transforming efforts (Modeling, DB2 updates) to build assets for Life Science projects.
  • Respond to requests for specific customized DB2 reports

Show More

48. Data Integrity

demand arrow
low Demand
Here's how Data Integrity is used in Analytics Consultant jobs:
  • Performed regular QA of marketing database to ensure data integrity.
  • Maintain data integrity by ensuring all tags are correctly implemented.
  • Validated data integrity on SQL Server databases, portals, and websites.
  • Developed data cleansing tools and processes to maintain ongoing data integrity.
  • Debugged automated Excel reports and Access reports to ensure data integrity.

Show More

49. Olap

demand arrow
low Demand
Here's how Olap is used in Analytics Consultant jobs:
  • Provided required cost management metrics for a CMS Pioneer ACO by developing OLAP cube using MS SQL Server platform.
  • Create and implement OLAP cubes, reports and executive dashboards through MS SQL Server BI stack.
  • Experience in Creating Analysis Views using Analysis edition for OLAP (HANA OLAP connection).
  • Analyzed the transaction environment to identify the required facts and dimensions for the OLAP.
  • Worked on daily loads and initial data loads from OLTP to OLAP.
  • Added some new fields for new attributes for the requirement into OLAP.
  • Identify Source tables (OLTP) and Target tables (OLAP) for Data mapping.
  • Involved in creating bitmap and b-tree indexes in Siebel OLAP.
  • Designed Business Analytics solutions integrating IBM Cognos and SAP as well as other relational and OLAP data sources.

Show More

50. Physical Layer

demand arrow
low Demand
Here's how Physical Layer is used in Analytics Consultant jobs:
  • Created connection pools, physical tables, defined joins and implemented authorizations in the Physical Layer using OBIEE Admin Tool.
  • Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
  • Involved in RPD development using Admin tool to build Physical layer, BMM layer and presentation layer.
  • Worked in Physical layer, Business layer, Presentation layers according to business Requirement.
  • Involved in Physical Layer, Business Model & Mapping Model, and Presentation Layer.
  • Designed the Siebel Repository Physical layer and created the Star Schema in Business Model and Configured Dimensions for Drill down functionality.
  • Performed query optimizations / tuning in physical layer as well on database.

Show More

Analytics Consultant Jobs

NO RESULTS

Aw snap, no jobs found.

20 Most Common Skills For An Analytics Consultant

Business Requirements

12.4%

Dashboards

11.8%

SQL

9.7%

Analytics

8.5%

Data Warehouse

8.3%

Financial Statements

8.0%

SAS

6.5%

Data Analysis

5.8%

Pivot Tables

4.5%

ETL

3.2%

R

3.2%

Key Performance Indicators

2.7%

ROI

2.4%

Siebel

2.2%

Google Analytics Premium

2.2%

Informatica

2.0%

Project Management

1.7%

Teradata

1.7%

Unix

1.6%

KPI

1.6%
Show More

Typical Skill-Sets Required For An Analytics Consultant

Rank Skill
1 Business Requirements 9.3%
2 Dashboards 8.9%
3 SQL 7.3%
4 Analytics 6.3%
5 Data Warehouse 6.2%
6 Financial Statements 6.0%
7 SAS 4.9%
8 Data Analysis 4.3%
9 Pivot Tables 3.4%
10 ETL 2.4%
11 R 2.4%
12 Key Performance Indicators 2.1%
13 ROI 1.8%
14 Siebel 1.7%
15 Google Analytics Premium 1.6%
16 Informatica 1.5%
17 Project Management 1.3%
18 Teradata 1.3%
19 Unix 1.2%
20 KPI 1.2%
21 CRM 1.1%
22 Powerpoint 1.1%
23 Google Analytics 1.1%
24 Omniture 1.1%
25 Python 1.1%
26 VBA 1.1%
27 Workflow 1.0%
28 Business Model 1.0%
29 Toad 0.9%
30 Business Partners 0.9%
31 Sharepoint 0.9%
32 Predictive Models 0.9%
33 A/B 0.9%
34 Ssrs 0.8%
35 QA 0.8%
36 XML 0.8%
37 Business Units 0.8%
38 Pl/Sql 0.8%
39 SEO 0.7%
40 Ssis 0.7%
41 Cognos 0.7%
42 Obiee 0.7%
43 Statistical Models 0.7%
44 Spss 0.7%
45 Large Data 0.7%
46 Sitecatalyst 0.7%
47 DB2 0.6%
48 Data Integrity 0.6%
49 Olap 0.6%
50 Physical Layer 0.6%
{[{skill.rank}]} {[{skill.name}]} {[{skill.percentageDisplay}]}%
Show More

10,766 Analytics Consultant 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.