*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 "Open Source Erp & Crm" group. To unsubscribe from this group and stop receiving emails from it, send an email to open-source-erp-crm+unsubscr...@googlegroups.com. To post to this group, send email to open-source-erp-crm@googlegroups.com. Visit this group at https://groups.google.com/group/open-source-erp-crm. For more options, visit https://groups.google.com/d/optout.