*Sr. BI Developer with SSAS & TSQL*
*Location- Dayton, Ohio*
*6 Months*
*Rate- 55/hr.*
Position Description
The Business Intelligence (BI) Analyst’s role is to study business
requirements and design and implement BI software and systems to resolve
those requirements that is commensurate with the incumbent’s years’ of
experience and job level. This includes integrating databases, data
warehouses, and data access tools with business processes to drive success.
Job activities include prioritizing and selecting projects, gathering
requirements, designing, testing, deploying, and supporting BI solutions to
business constituents both within and without WinWholesale. In addition to
these technical skills, these activities require the ability to effectively
estimate tasks and work to achieve published goals and milestones.
Job Dimensions
Job Knowledge
Applicant must have
Experience with the concepts of modern relational database management
systems.
Be able to write basic TSQL queries against database objects as directed
Have an understanding of the difference between operational and decisional
databases.
Experience with Microsoft SQL Server 2008 or 2012 including
SQL Server Management Studio (SSMS)
SQL Server Integration Services (SSIS)
SQL Server Reporting Services (SSRS)
SQL Server Analysis Services (SSAS)
TSQL, including 2008 TSQL extensions
Understanding of the various information domains in a typical data
warehouse environment
Must be able to do basic tuning and optimization of both operational and
data warehouse databases warehouse
Must know how to tune queries to be more efficient and understand the
basics of indexing schemes, contraints, be able to write fairly complex
stored procedures, and be comfortable studying query execution plans
Must be able to write stored procedures, triggers, and views
Must be able to do basic Integration Services (SSIS) tasks such as
importing and exporting data
Must be able to create prompted Reporting Services (SSRS) reports
Must be comfortable discussing database usage with developers
Must have a grasp of basic statistical analysis concepts
Impact of Decisions
Decisions will impact defined functionality within the business
intelligence / data warehouse environment
Must be able to identify key decision criteria
Decisions impact specific functions and uses of the BI / DW environment
Problem Analysis and Resolution
Assist users with questions, problems, communications, and training
Discover and troubleshoot issues as they arise in the technical environment
Teamwork and Leadership
Work as an individual contributor in a team environment on specific tasks
as assigned
Participates in project and production support environments
Assists in ad-hoc projects as assigned
Able to work with both technical and general business resources to resolve
business needs
Supervision Requirements
Under general supervision perform complex maintenance and project tasks
Ask for guidance and help as needed
Provide detailed status and problem updates and analyses to all constituents
Provide guidance to others within the department and across other IS groups
Communication Skills
Demonstrates basic written, verbal and presentation skills
Accepts and provides feedback
Begins to build trusting relationships through interactions, both formal
and ad hoc
Adept and forging and maintaining relationships both within the broad IT
and general business environments
Education and Experience
BA/BS in Information Technology, Information Systems, or Mathematics
6+years of relevant IT or IS experience
2+ years of database experience
*Thanks and Regards*
*Shweta Ojha*
Technical Recruiter | Sage Group Consulting
*Direct: *732-784-6492
*Email: *[email protected]
*Gtalk: *sojha1290*|Ymail: *ojha1290
--
You received this message because you are subscribed to the Google Groups
"USITCV" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/usitcv.
For more options, visit https://groups.google.com/d/optout.
