Job descriptionResponsible for day to day management of the Business Intelligence and Reporting Team.Collaborate with internal and external partners to plan, design, and implement cost-effective technology decisions.Lead overall BI User Experience, working closely with Executives and end-users to define how they access, interact, and utilize business dataExperience in writing and tuning SQL queries, view, stored procedures, and functionsProven Experience with front-end reporting tools, preferably LogiAnalytics (formerly LogiXML) along with SQL Server Reporting Services (SSRS), web application development, design, and implementation.A hands-on technical role is responsible for data warehousing and business intelligence, emphasizing reporting, and data analytics through the entire project life cycle.Meet with stakeholders to gather and document data warehouse and reporting requirements to ensure development work meets business objectivesProvide dashboard / reporting functionality and create key performance indicators, calculations, and metrics on web and mobile applicationsSSAS design and build Experience, including multi-tier infrastructures, partitioning, aggregations, proactive caching, actions, role, and data-level security.Create Microsoft SQL Server Integration Services packages (SSIS), scripts, and other elements to move data from the source databases into the data warehouseExtract, transform, and load (ETL) data from various source systems to the data warehouse, covering multiple technical scenarios encountered in constructing complex data warehousing solutions.Proven experience sourcing data from various applications, creating OLAP models, and generating multi-dimensional cubes using SSAS.Prepare deliverables such as Source to target mappings and transformation rules documentation.