Dell - Business Intelligence Analyst

- Provides analytical and business intelligence support to a business unit, segment or function. Analyzes, interprets, maintains and reports data.

- Serves as the business unit data steward, establishing validation and testing protocols to maintain the integrity of the data. Delivers ad-hoc data and report requests for client group.

- Develops, runs and prepares various statistical analyses and reports based on both internal and external data sources. Utilizes various software packages and tools for collecting, mining, interpreting and reporting data.

- May be responsible for granting and terminating system access to data.

- Analyzes business data, providing assessments of trends, identifying and explaining variances from goals.

- Elicits and documents business requirements to produce meaningful insights and metrics, identifying trends and insights that improve business performance.

- Designs, develops and implements business intelligence dashboards and reports to facilitate data review and analysis.

- Proactively analyzes trends, causes and variances.

- Champion process improvements, best practices and knowledge sharing within the organization as it pertains to business intelligence, analytics and data integration capabilities.

- Maintains databases, cleansing and validating data as needed.

- Develops database logic to extract required information for reporting.

- Creates and distributes both routine and complex ad-hoc reports. Job Duty Differentiators: Provides reports to leadership.

- Produces standard daily/weekly/monthly reports with minimal variance.

- Troubleshoots issues with standard reports and works with customers on reporting difficulties.

- Develops lower complexity analysis and publishes through well developed interfaces (Excel, Access, BI standard interface).

- Ensures timely and accurate delivery of reports.

Knowledge - Professional / Technical / Business Acumen :

- Knowledge of basic principles, methods, technologies and practices of a professional/technical field.

- Apply a basic understanding of the underlying principles of a professional discipline - typically obtained through formal study.

- General knowledge of procedures and activities within own work area.

- Ability to relate actual day- to-day work to business priorities.

- Focused on learning the key aspects and duties of the job being performed. Problem Solving - Judgement / Complexity / Ingenuity

- Applies research, information gathering and analytical skills.

- Selects appropriate alternatives from defined options

- Collects required documentation; verifies conformance of documents with standards.

- Assesses accuracy of detailed information.

- Tracks, maintains and produces regular and ad hoc reports.

- Handles detailed, structured problems.

- Identifies roadblocks to task completion and effectively brings them to management for resolution.

- Generally uses existing procedures to resolve standard problems.

- Works on assignments where judgment is required a majority of the time. Guidance

- Direction / Planning / Independence / Initiative

- Works under general direction, seeks assistance as needed.

- Completes work in accordance with accepted practices within field.

- Establishes approaches for completing assignments.

- Independently gathers information.

- Adjusts to multiple demands and shifting priorities; accepts responsibility for results of actions.

- Works with team to support achievement of project milestones and deliver on internal and/or external commitments.

- When assigned to a customer team, supports small project teams or specific components of a customer engagement. Communication

- Contributes to own team/closely related teams through quality and accuracy of own output. - Understands how work area performance impacts results.

- Builds productive internal relationships

- Collaborates with others to achieve objectives and ensure information flow.

- Conveys information in a concise and professional manner.

- Asks effective questions and solicits feedback to understand needs.

- Anticipates future needs based on past transactions.

Education :

- 2-4 years of relevant experience or equivalent combination of education and work experience.

- Understanding of how IT systems process and integrate information.

- Knowledge of general statistical principles (averages, quartiles, standard deviations, etc) and the relevancy of information.

- Proficient with Logical/Analytical and Problem Solving skills.

- General knowledge of database structures and their functions.

- Capable of writing inquiry and summary SQL statements.

- Competent in publishing through Excel, Access, and / or Dell Business Intelligence tools (Hyperion, Statistica, Business Objects, etc. Undergraduate degree and 2-4 years relevant experience or Graduate degree and 0-2 years relevant experience. BE / B Tech / Management Program / Supply Chain Analytics