Hi, This is Sushil from American IT Resource Group, Inc.
We have urgent job opening for *Sr. BI Developer* So, kindly forward your available consultant profile with best rate to sus...@aitrg.com As Soon As Possible. Below find the Job description: *Sr. BI Developer* *Neenah, WI* *8-10 months* *Need 8+ years candidate.* *Keywords: *SSIS SSRS SSAS* MDX Multidimensional Expressions *Position Summary:* This position is responsible for the design, construction, optimization, and operational support of extract, transform, and load (ETL) processes using SQL Server Integration Services (SSIS) and reporting solutions including SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), PerformancePoint, and SharePoint. This position translates business and functional requirements into detailed technical designs and delivers ETL and reporting solutions according to the specifications. *Essential Duties and Responsibilities:* Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. · Responsible for extracting data from multiple operational and financial sources and assemble them into meaningful business intelligence · Perform all SDLC phases related to extract, transform, and load (ETL) processes using SQL Server Integration Services (SSIS) and SQL Server stored procedures within MS SQL Server environment. · Develop and maintain complex reports, multidimensional cubes and flexible dashboards · Create and maintain data flow diagrams for existing and future ETL processes · Create and maintain detailed source-to-target ETL mapping specifications · Assist in the definition of the database requirements; analyze existing models and reports looking for opportunities to improve their efficiency; and resolve technical problems · Evaluate alternate solutions and design processes and systems which includes user impact considerations, cost and benefit analysis, and processing specifications. · Develop optimized SQL Server stored procedures, functions, and database views · Translate business requirements into BI application designs and solutions · Performance monitoring, tuning and capacity planning · Develop ETL audit process and controls to ensure data quality is compliant with defined standards and thresholds *Required Knowledge, Skills and Abilities:* • Understanding and knowledge of Microsoft's Team Foundation Server • (TFS) • Experience with Microsoft's SQL Server tool suite (SSRS, SSIS, and • SSAS) • Experience developing solutions with Microsoft's PerformancePoint and SharePoint • Working knowledge of iterative development process • Experience creating technical documentation • Excellent technical and analytical skills • Strong interpersonal communication skills • Advanced analysis and design techniques to evaluate and resolve complex business problems. *Preferred Knowledge, Skills and Abilities:* • Agile Project Methodology expertise • Experience with Microsoft SQL Server 2008 product suite, Microsoft SharePoint 2010, and Microsoft Office 2010 product suite • Microsoft Certified IT Professional: Business Intelligence Developer certification • Knowledge of Guidewire PolicyCenter, BillingCenter, and/or ClaimsCenter, ThunderHEAD NOW by ThunderHEAD Ltd., and ImageRight by Vertafore • One of the Business Support teams that works on small enhancements and defects to the ETL, data warehouse or reports for a line of business. • Agency portal project - creating a site where insurance agents can login and view insurance plan docs/info, etc. *Thanks & Regards…* *Sushil* *Technical Recruiter* *American IT Resource Group, Inc.* *1111, Plaza Dr., Suite 640, Schaumberg, IL - 60173* *Direct: 312-585-6070* *Email: sushil**@aitrg.com <http://aitrg.com>* *www.aitrg.com <http://www.aitrg.com/>* -- You received this message because you are subscribed to the Google Groups "as400placements1" group. To unsubscribe from this group and stop receiving emails from it, send an email to hrccpl+unsubscr...@googlegroups.com. To post to this group, send an email to hrccpl@googlegroups.com. Visit this group at http://groups.google.com/group/hrccpl. For more options, visit https://groups.google.com/d/optout.