Job Description :
Position : SSIS Developer
Location : Mountain View CA
POSITION SUMMARY:
Omnicell Inc. has an exciting opportunity for a Decision Support Analyst to join our Sales Analytics team located at our office in Cranberry Township, PA. The candidate will help the Sales organization increase sales effectiveness and efficiency by improving the business’s data infrastructure and developing automated performance reports from multiple data sources. The candidate will support Sales strategies and objectives via statistical data analysis, forecasting, process improvements and sales reporting.
The candidate will collaborate cross-functionally with Finance, IT/IS, Operations and Marketing to achieve organization goals.
Major Responsibilities
· Serve as the primary point of contact for Sales reporting, data and statistical analysis and data infrastructure.
· Develop and foster internal relationships across the corporation. Provide analytic and consultative support to a broad spectrum of internal customer areas and external business partners.
· Creates and/or develops new methods of analysis, database design and performance measurement or, in some cases, adaptation of existing solutions to new areas.
· Develops tools to identify historical and forecasted product and resource requirement trends and provide analysis reports and action plans to management.
· Performs modeling of data sources and flows, works with data management staff to define an operational framework that will define, develop and implement policies and security frameworks to ensure precise and secure deliver of knowledge and information.
· Maintain and manage existing reports by troubleshooting or performance-tuning where necessary
· Responsible for design, development, implementation and administration of database architecture that support business objectives
· Provides assistance and, depending on skill and experience, leads with interpretation of raw data, statistical results or otherwise compiled information, identify follow-up action items and prepare or assist in the preparation of written reports and/or oral presentation of findings to internal and external audiences, customer managers, clinical staff, compliance agencies, group accounts, providers, agent plans, and brokers.
· Develops and maintains moderate- to extremely-complex computer programs using 4GL programming languages (such as R, SQL) and other database technology
· Establishes and implements standards and strategies for data management, lifecycle, and quality.
· Extract and compile data using SQL queries with filtering, grouping, and aggregate functions as needed. Meet with Analytics and Sales team to identify reporting needs and to review data.
· Gather information from the sales team and independent representatives to assist in forecasting
· Create executive level reports to support strategic sales direction or to support proposed changes to sales direction
· Provide timely, relevant and accurate analysis of Sales performance against historical, budgeted, forecasted and strategic planning to facilitate decision-making toward the achievement of the budget and strategic plan
· Analyze the key drivers and metrics vs. historical performance, budgets, forecasts, and strategic plans and communicate results to leadership for decision support, plan reviews and operational reviews
· Utilize financial models that incorporate all relevant metrics and drivers of the business
· Communicate analytical results verbally, in writing and in presentation form to all levels of management
· Other duties as assigned.
KEY RESPONSIBILTIES:
Qlik Sense / Tableau Report Development
30%
Data Modeling / Architecture
40%
Data Analysis / Decision Support
20%
Administrative (Other)
10%
MINIMUM JOB REQUIREMENTS:
Education / Training: A Bachelor’s Degree in Information Technology, Statistics, Computer Science, Market Research
Business Experience:
· 4+ years of experience in business intelligence, data analytics, data science, computer science or related field.
· Experience in the healthcare industry is preferred
· Experience with Qlik Sense and/or Tableau
· Ability to work independently:
o coordinate efforts with other members of Analytics team
o interact with project stake holders
o take responsibility for executing and delivering on time
o work with the team to design solutions and troubleshoot new issues
Specialized Knowledge/Skills:
· Advanced skills in data analysis, definition, design, logical modeling, and physical implementation of relational and dimensional databases, primarily using Microsoft SQL Server, Tableau or Qlik Sense
· Must be comfortable and proficient using large and complex databases.
· A high threshold for ambiguity and lack of structure and process during early phases of engagements
· Extremely proactive with a strong bias for action; naturally inquisitive; desire to continuously improve current business practices/processes.
Effective verbal and written communications skills and effective presentation and negotiation skills with demonstrated ability t
Send me the below details for Submission
Full Name as per the Passport
Present location (city, state or ZIP)
Work Authorization
Education (Highest Degree and year)
Tel No
E-mail ID
Skype ID
Open to Relocate
Total onsite experience, working in US
Overall relevant experience of candidate
Availability for Interview (Preferred Time)
Linked in Profile Link ( Mandatory ) :
References
1.
1 Name
2 Email id
3 Phone number
4 Designation
2.
1 Name
2 Email id
3 Phone number
4 Designation