Microstrategy Lead

Company DescriptionComtech is a woman-owned small business founded in 1998 and headquartered in Reston, VA. We offer IT solutions across the disciplines of program/project management, applications development, infrastructure, Cyber security, and enterprise content/data management services. We have developed our methodologies and processes based on the IT Infrastructure Library (ITIL) v.3 Framework across enterprise infrastructure operations. These methodologies and processes are reinforced through our organization’s externally accredited certifications, which include ISO 9001:2008 Quality Management System (QMS), ISO/IEC 20000-1:2011 IT Service Management Systems (SMS, corporate ITIL certification), ISO 27001:2005 Information Security Management System (ISMS), and CMMI-DEV Level 3"Job DescriptionJob description:Migrate existing client warehouse(ODS & DM) from SQL server to AWS Aurora. This involves modifying the ETLs on Informatica Cloud and reconfiguring them to point to AWS Aurora DB. Remap existing BI layer to interact with the updated DBRequire to remap reporting layer (Microstrategy and SQL reports) to point from SQL server to AWS AuroraWork with users and business SMEs to define technical specifications to develop reporting requirements, and technical documentationPromote and apply reporting best practicesDevelop/Modify Mappings in Microstrategy and SQL reportingsWork with business analysts and process owners on the development of test cases and scriptsPost deployment support and defect resolutionsExperience with Agile/Scrum methodologyExcellent oral, written communication and presentation skillsStrong teamwork and problem solving abilities.Qualifications6+ years in Business Intelligence5+ years of MicroStrategy Platform experience, including: Advanced Analytics Reports, Visual Insight Dashboards and Report Services Document creation and experience in administration tooFluent in SQL and able to read and write complex queries, views and stored proceduresExperience in core Business Intelligence/ Data warehousing technology: RDBMS, Web, Client/ Server, OLAP, etcExperience with big data environments (Hadoop, Spark, Cassandra, etc.)Experience working with capturing reporting on Current and Historical DataExperience working with Transformations, Complex reports, Report Services Documents (Dashboards), Rolling Metrics, Nested Metrics, Relationship Filters, VLDB Properties (multi-pass sql, hints, etc)3+ years in SQL reporting servicesAdditional Information**Please share me your updated word copy of Resume.**I Appreciate, if you can refer someone who is looking for this position.Contact:Nayan HazareIT Recruiter at Comtech LLCCall- 703-962-6656nhazare@ comtechllc.comSummaryType: Full-timeFunction: Information TechnologyExperience level: Mid-Senior LevelIndustry: Information Technology And Services