Microstrategy Lead

Comtech LLC

Santa Clara (CA)

On-site

USD 100,000 - 130,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

An IT solutions provider is seeking a Business Intelligence professional in Santa Clara, California. This role involves migrating existing client warehouses from SQL Server to AWS Aurora, remapping reporting layers, and developing technical documentation. The ideal candidate should have over six years of Business Intelligence experience, expertise in MicroStrategy, and strong SQL skills. Excellent communication and teamwork abilities are essential for success in this position.

Qualifications

  • 6+ years in Business Intelligence.
  • 5+ years of MicroStrategy Platform experience.
  • Fluent in SQL with complex queries.
  • Experience with big data environments.
  • 3+ years in SQL reporting services.

Responsibilities

  • Migrate client warehouse from SQL server to AWS Aurora.
  • Remap reporting layer to AWS Aurora.
  • Define technical specifications for reports.
  • Develop and modify mappings in MicroStrategy.
  • Provide post-deployment support.

Skills

Business Intelligence
MicroStrategy
SQL
Agile/Scrum
Problem Solving
Teamwork

Tools

Informatica Cloud
MicroStrategy
AWS Aurora

Job description

Comtech 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 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 DB
  • Require to remap reporting layer (Microstrategy and SQL reports) to point from SQL server to AWS Aurora
  • Work with users and business SMEs to define technical specifications to develop reportingrequirements, and technical documentation
  • Promote and apply reporting best practices
  • Develop/Modify Mappings in Microstrategy and SQL reportings
  • Work with business analysts and process owners on the development of test cases and scripts
  • Post deployment support and defect resolutions
  • Experience with Agile/Scrum methodology
  • Excellent oral, written communication and presentation skills
  • Strong teamwork and problem solving abilities.
Qualifications
  • 6+ years in Business Intelligence
  • 5+ years of MicroStrategy Platform experience, including: Advanced Analytics Reports, Visual Insight Dashboards and Report Services Document creation and experience in administration too
  • Fluent in SQL and able to read and write complex queries, views and stored procedures
  • Experience in core Business Intelligence/ Data warehousing technology: RDBMS, Web, Client/ Server, OLAP, etc
  • Experience with big data environments (Hadoop, Spark, Cassandra, etc.)
  • Experience working with capturing reporting on Current and Historical Data
  • Experience 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 services
Additional Information

**Please share me your updated word copy of Resume.

**I Appreciate, if you can refer someone who is looking for this position.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior MicroStrategy BI Developer & Analytics Lead
Senior MicroStrategy BI Developer & Analytics Lead

Artech LLC. • McLean (VA)

On-site
USD 100,000 - 130,000
Microstrategy Developer
Microstrategy Developer

Artech LLC. • McLean (VA)

On-site
USD 100,000 - 130,000
Microstrategy developer
Microstrategy developer

HSSSoft • Jersey City (NJ)

On-site
USD 100,000 - 130,000
MicroStrategy BI Administrator | Data Warehouse Expert
MicroStrategy BI Administrator | Data Warehouse Expert

Usmsystems • Bedminster Township (NJ)

On-site
USD 80,000 - 120,000
Informatica Consultant
Informatica Consultant

Comtech LLC • Santa Clara (CA)

On-site
USD 120,000 - 150,000
Senior MicroStrategy & AWS Cloud BI Administrator
Senior MicroStrategy & AWS Cloud BI Administrator

Compunnel Inc. • McLean (VA)

On-site
USD 120,000 - 150,000
MicroStrategy Lead
MicroStrategy Lead

TecTammina • Lyndhurst (NJ)

On-site
USD 90,000 - 120,000
Microstrategy Developer/Lead/Architect
Microstrategy Developer/Lead/Architect

HSSSoft • New Jersey

On-site
USD 90,000 - 130,000
MicroStrategy
MicroStrategy

Sonsoft Inc • Bethpage (NY)

On-site
USD 90,000 - 130,000
Microstrategy Administrator
Microstrategy Administrator

Sonsoft Inc • Middletown (NJ)

On-site
USD 90,000 - 120,000