Company Description3MK Software Solutions is the leading software service soltions provider and IT Staffing Supplier company, outsourcing and complex implementation services for the business across different functional areas and technologies with a core focus on software development and web designing development and GIS Software solutions and services. Our team is our core strength, we have selected the most skilled and talented specialists from the IT industry, and we continuously invest in developing their capabilities. The core management has many years of experience and has successfully leaded complex projects for major corporate in the field of healthcare, communication, retail and finance. During the term of these projects, the team had needed to develop an advanced implementation methodology.Job DescriptionTechno-Functional Consultant/Architect – Commercial - Experience level – 10-12 Years 1. Extensive knowledge in implementing BI solution for Commercial Business Users2. Good understanding of BI Measures/Metrics, Reports and Dashboard for the Commercial Business users (Including Marketing Science, Brand Team and Head office)3. Must have experience in designing/building reporting data mart catering to Self Service BI (Preferably using Micro Strategy reporting Tool)4. Ability to architect Commercial data into Data Mart required for Business Analytics reporting 5. Good Commercial Data Knowledge that existing in the commercial data warehouse including Sales, Territory, Alignment, Customer (HCP, HCO, Payer, PBM)6. Experience with application security for user and active directory access understanding7. Familiar with SQL and SQL Server relational database 8. Excellent verbal and written communication skills9. Experience in requirement gathering and creating requirement/UAT documentsAdditional InformationAll your information will be kept confidential according to EEO guidelines.