*BI Developer * *Cleveland, OH*
*6+ months* *50-52/hr* Our BI team specializes in Microsoft SSIS, SSAS, SSRS, and MDX. The Sr. Developer will play key role in developing and maintaining our BI capabilities. This role requires a broad range of skills and the ability to step in to different roles depending on the size and scope of the project; its primary day-to-day responsibility is to design, implement and maintain ETL processes using SQL Server SSIS to support cube, reports and dashboards *Job Responsibilities*: · Designing, developing and optimizing complex SQL stored procedures to meet data management and data integration objectives. · Designing, developing and maintaining ETL processes that transform data and populates data warehouse and SSAS Cube. · Creating and maintaining documentation that describes ETL solutions. · Proactively identifying problems/issues concerning data accuracy, data integrity and relevance. · Providing ongoing ETL process maintenance support through SQL query tuning and other optimization mechanism. · Work effectively with the project team to identify, estimate, prioritize and resolve issues · Develops business oriented data dictionaries. · Provide data input during an engagement that will impact scope and delivery · Provide input into the technical architecture and the data warehouse technology stack, as well as establish and follow through on data modeling and ETL standards *Job Requirements* : · Solid understanding of relational database theory, principles and best practices. · Proficient in SQL relational database modeling. · Highly proficient in T-SQL script development using stored procedures, views, user defined functions etc. · Strong understanding of ETL concepts, architecture and data warehouse development methodologies and best practices. · Solid experience in ETL package design, development, troubleshooting and performance tuning using SQL Server SSIS 2008 R2 or later version · Strong ability to analyze data and identify data quality issues. · Solid ability in understanding and interpreting Microsoft SQL Server execution plan to facilitate performance turning tasks. · Good understanding of Kimball Dimensional Design methodology, and experience in Multidimensional Data mart modeling using the methodology. · Experience in designing cubes that handle large volumes of data and meet complex business needs is a plus. · Experience in cube aggregation design, bridge tables design, ragged hierarchies, partitions and security design is a plus. · Experience in using SSIS 2012 Project Deployment Model · Proficient with data modeling concepts · Experience with dimensional and 3NF modeling · Experience with OLTP and OLAP · Excellent written and oral communication skills. · Excellent written and oral communication skills. *Good to Have * · Understanding of NoSQL platform · Experience in data mining using R and Python · Understand of Big Data platform (Cloudera, Hortonworks, MapR, HDInsight) · Experience in data modeling concepts *Thanks & Regards,* *Abhishek Ojha* *732- 837- 2138* *ao...@sagetl.com <ao...@sagetl.com>* -- You received this message because you are subscribed to the Google Groups "SAP Resource Center" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-resource-center+unsubscr...@googlegroups.com. To post to this group, send email to sap-resource-center@googlegroups.com. Visit this group at https://groups.google.com/group/sap-resource-center. For more options, visit https://groups.google.com/d/optout.
