Data Warehouse Analyst / Architect Spring, TX; Humble, TX Salary $75,000 - $110,000 Education Bachelor of Science Category Information Technology Experience At least 2 Years Required Short Data Warehouse Developer with SQL needed at growing Health Care Description company in Houston! Required Skills SQL 2005, MS Analytics, OLAP, Star Schemas, ETL, MDX, DMX,DTS / SQL Server Integration Services (SSIS), Data Mining, Healthcare industry or Hospital experience Recruiter Amy Knoell Date Updated 6/10/2012 Apply Now! Data Warehouse Developer with SQL needed at growing Health Care company in Houston! This position is open as of 6/10/2012. Are you a fit? Click here to apply now! Data Warehouse Analyst / Architect Skills Required: SQL 2005, MS Analytics, OLAP, Star Schemas, ETL, MDX, DMX,DTS / SQL Server Integration Services (SSIS), Data Mining, Healthcare industry or Hospital experience Job Description: Data Warehouse, SQL 2005, Data Warehouse Analyst, Data Warehouse developer, Data warehouse Architect SQL 2005, MS Analytics, OLAP, Star Schemas, ETL, MDX,DMX, DTS / SQL Server Integration Services (SSIS), Data Mining, Healthcare industry or Hospital experience We are a progressive Healthcare software company that is growing rapidly and in our field, there is no one else that does what we do!!! So come on and join a company that has guaranteed success. The right candidate will have strong SQL Server 2005 experience with specific SSIS knowledge and strong MS Analysis Services understanding with 3+ years of OLAP development experience (cube design, fact, dimension structure, Data Mart development, etc). We will help with relocation for the right candidate! Qualifications: • Bachelor’s degree in computer technology discipline desirable. • Strong knowledge of Data Warehousing methodologies and concepts, including and not limited to: star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools • 3 + years of experience in dimensional modeling, cube design and development using SQL Server Analysis Services (SSAS) • 5 + years DTS / SQL Server Integration Services (SSIS) • Experience Multidimensional Expression (MDX) queries and Data Mining Expression (DMX) queries for analysis services • Good working experience with OLAP and Reporting Services/MS Excel combination • Strong data modeling experience and key understanding of relational database development. • Significant experience in extracting data from multiple sources including a data warehouse environment. • Knowledge of health system functions, terminology and standard coding systems preferred. • Ability to comprehend complex technical and logical concepts and adapt quickly to changes. • Strong quantitative, analytical, problem solving, organizational, communication and interpersonal skills are required. • Attention to detail and maintaining high quality standards is a must. • Ability to prioritize and manage concurrent projects, demonstrate initiative and work independently with minimal supervision. Responsibilities: • Analyze business and technical requirements, as well as data warehouse data models, to understand the detailed data management requirements • Collaborate on the global data architecture design and planning for the physical structure and implementation of data warehouses and data marts. • Design, document and build physical database environments from table, column, index and view definitions to storage requirements and drive spacing and growth accommodations. • Work with ETL developers and data analysts to identify, design and implement solutions for extraction and integration of data to and from data warehouses and data marts for the purposes of reporting, decision support and analysis. • Develop scripts for the creation of the physical data warehouse database schema(s), data security and protection, managing performance, performing backups/ restores, and archiving data. • Document and standardize data structures, procedures and processes. • Manage, Monitor and Administer database and system performance. Including optimization and tuning of data loads, extractions and recommending appropriate procedure, query or package changes and optimizations to ensure and improve system performance and reliability. • Manage job and activity schedules to promote optimal performance, maximum availability and minimize data latency and data load durations. Environmental and Physical Demands: Position requires the ability to sit for long periods of time and prolonged computing sessions. Ability to concentrate on detailed work with some interruptions. • Bachelor's degree is mandatory, clinical experience is desired or experience in a hospital, insurance biotech • 2+ years as an analyst in the healthcare industry emphasizing on quantitative reasoning, analytical modeling, and operations reporting • Knowledge of health system functions strongly desired including terminology and coding • Strong ad-hoc SQL query development skills, working knowledge of relational databases and MS Word, PowerPoint, Access, Visio is mandatory • Superior data mining, extraction, transformation, modeling, validation testing, and presentation skills are mandatory • Reporting, technical writing and documentation experience • Actuary experience or Statistical background is a major plus What you will be doing: • Medical economics, underwriting, trend calculations and reporting • Saving projections and rate setting • Perform complex data extractions and manipulations, which culminate in the design and production of ad-hoc analyses and reports for external clients and internal management • Perform data validation to ensure accuracy and appropriateness of analytic models • Perform healthcare data analysis, including quantifying cost and utilization • Design and automate regularly scheduled reports for efficient production for multiple clients • Prepare Executive Summary reports • Documentation What's in it for you: * Very competitive compensation package * Great benefits and 401k * Work in a fast paced, progressive product development company * Have an impact on company direction and products * Competitive vacation * Flex hours * Casual environment So, if you are looking for a challenge and want to continue your career in a growing healthcare firm ...apply now! So, if you are looking for a challenge and want to continue your healthcare analyst career in a growing Health Care firm ...apply now! Must be authorized to work in the United States on a full-time basis for any employer. Want to interview today? Click Here to Do a Quick 2-Minute Online Interview! Are you a fit for this position? Please Click Here to Apply! (your information will be kept strictly confidential!) Looking forward to receiving your resume through our website and going over the position with you. Clicking apply is the best way to apply, but you may also: Email your resume in Word to: Amy.Knoell@CyberCoders.com **Please do NOT change the email subject line in any way. You must keep the JobID: CC MonsterAp : AK-newDW2 -- in the email subject line for your application to be considered.*** Amy Knoell - Executive Recruiter - CyberCoders CyberCoders, Inc is proud to be an Equal Opportunity Employer. Applicants are considered for all positions without regard to race, color, religion, sex, national origin, age, disability, sexual orientation, ancestry, marital or veteran status.
Pages to are hidden for
"Data Warehouse Analyst.doc"Please download to view full document