Lead Engineer / 9 - 12 Years / Bangalore


Posted 02 Mar 2018 (352 days ago)

Job Description

Position: Lead Engineer (Contract-to-hire) – 1 Position

·       Experience: 9-12 Years in IT Services / Consulting/ Technology / Software Development

·       Education: BS Computer Science / B TechComputers/BSE Computers / MS Computer Science / Masters Computer Application(MCA), BE Bachelor of Engineering

Key Characteristics:

·         Minimum of 6-8 years experience in implementing end to end business intelligence and data warehousing projects.

·         4+ years of experience designing and developing MicroStrategy dashboards, reports and solutions

·         MicroStrategy Mobile app development experience is necessary

·         Experience designing and implementing dimensional star & snowflake models, data marts, and data warehouses

·         Develop reports, cubes, dashboards, scorecards, Unit, Integration test the developed components

·         Working knowledge on Oracle relational database - ability to optimize, analyze, and improve database SQL performance on any platform

·         Gather business requirements, elicit technical requirements, prepare report specifications

·         Promote components across dev., test and production environments.

·         Provide UAT and Implementation support.

·         Strong analytical skills, above average written and verbal communication skills and strong decision making capabilities



Preferred Certifications / Skills:

·       MicroStrategy Certified Developer (MCD) ORMicroStrategy Certified Engineer (MCE)

·       MicroStrategy Architect

·       MicroStrategy Desktop, Web, Mobile Suite

·       MicroStrategy Object manager

·       MicroStrategy Enterprise Manager

·       MicroStrategy Visual Insights

·       Knowledge/Expertise with an additional BI tool(Tableau/QlikView/Spotfire/Cognos)


Key Responsibilities:

·       Performs complex analysis, design, programming, test plans, testing, debugging, modification and support for Microstrategy business intelligence system(s).

·       Provides advanced technical troubleshooting for Microstrategy and other BI reporting platforms emphasis on root cause analysis including data issues and SQL validation.

·       Applies advanced administration, management and performance tuning techniques.

·       Architects schema objects, builds grids, graphs,reports, dashboards, objects, metrics, filters, and prompts.

·       Finalizes forms, procedures, and other documentation needed for the installation, monitoring and maintenance of application programs.

·       Writes and maintains documentation describing changes/modifications to all systems.

·       Researches solutions to various business and technical problems, evaluate alternatives, scope appropriately and present recommendations with justification to management

·       Data visualization mockup, report design, and data modeling

·       Self-motivated, ability to work independently with minimal direction and be team oriented with ability to communicate to awide variety of audiences


• Lead and execute projects

• Lead Proof of Concept (POC) and Framework development

• Work with teams to assess business needs

• Provide quick Prototypes to demo concepts

• Provide both development and guidance to developers. 

• Write Technical Specs, & Design Documents


Required skill sets:

• Strong SQL Development skills and experience especially Teradata and AWS RedShift RDS

• Ability to write complex SQL themselves to perform data analysis, performance analysis

• Ability to review SQL to optimize, analyze and improve database SQL performance.

• Hands on experience with MSTR 9.0 and above

• Strong knowledge in MSTR Report Development, Report Testing, Report Tuning, Ad-hoc, Scheduling report delivery and Alerts

• Strong understanding of how MSTR interacts with reporting databases

• Must have architected MicroStrategy objects from the ground up to support scalable and optimized use of ad hoc elements and analytical dashboards.

• Should have extensive experience creating Public objects and schema objects to develop reports and dashboards

• Report development grids, graphs and dashboards

• Fine-tuned VLDB properties

• Automated Cube building process on System manager using incremental refresh reports.

• Data modelling experience

• Strong understanding of proper data modelling concepts, especially as they apply to data warehousing

• Ability to build out conceptual, logical and physical models from scratch in a dimensional model structure

• Ability to review existing data models to optimize, analyze and improve report performance

• Overall 10+ years is must on MicroStrategy Reporting 

•Must be local to Chicago, IL (work location is Oak Brook, suburb of Chicago)


Company Description

It is a public global Information Technology company committed to Empowering Business Transformation. A comprehensive set of IP based software solutions (20+), coupled with a wide range of IT services, uniquely positions the company to address the dynamic requirements of a variety of industry verticals, predominantly Banking, Insurance, Capital Markets, Asset & Wealth Management (BFSI). Furthermore it offers solutions to the government, manufacturing, retail, distribution, telecom and healthcare sectors. Among its repertoire of IPR based solutions the flagship products of the Company are Premia, MFund, Orion, Kasle and Amlock The Company has a very strong foothold and customer base in geographies like South Asia, Middle East and Africa, China, Asia Pacific, Kingdom of Saudi Arabia and North America.

Key Skills


Not Mentioned

Employment Type


Job Function

Not Mentioned

Experience Required

9 - 12 Years

No Of Positions

Salary Offered

INR 0 - 0

Interview Locations

Client Location - Not Mentioned(Interview Mode - Face 2 Face)

Also Matched Jobs



Posted 19 Sep 2018(151 days ago)

Software Developer


Posted 09 Jul 2018(223 days ago)

Java Developer


Posted 09 Jul 2018(223 days ago)

Software Developer


Posted 09 Jul 2018(223 days ago)

Selenium Tester


Posted 09 Jul 2018(223 days ago)