Comtech LLC logo

Microstrategy Lead - Transform Data Solutions

Comtech LLCSanta Clara
On-site Full-time

Clicking Apply Now takes you to AutoApply where you can tailor your resume and apply.


Experience Level

Mid to Senior

Qualifications

6+ years of experience in Business Intelligence.5+ years of hands-on experience with the MicroStrategy Platform, including Advanced Analytics Reports, Visual Insight Dashboards, and Report Services Document creation, along with administrative experience. Proficient in SQL with the ability to read and write complex queries, views, and stored procedures. Solid understanding of core Business Intelligence and Data Warehousing technologies such as RDBMS, Web, Client/Server, and OLAP. Familiarity with big data environments, including Hadoop, Spark, and Cassandra. Experience in capturing reporting on both Current and Historical Data. Expertise in developing complex reports, Report Services Documents (Dashboards), Rolling Metrics, Nested Metrics, and leveraging VLDB properties (multi-pass SQL, hints, etc.).3+ years of experience in SQL reporting services.

About the job

Join Our Team as a Microstrategy Lead!

Are you ready to take your career to the next level? We are seeking a talented and experienced Microstrategy Lead to spearhead our data migration initiatives. In this role, you will:

  • Lead the migration of existing client data warehouses (ODS & DM) from SQL Server to AWS Aurora, including the modification of ETL processes on Informatica Cloud and the remapping of the BI layer for seamless integration with the new database.
  • Remap reporting layers, including Microstrategy and SQL reports, to ensure they function flawlessly with AWS Aurora.
  • Collaborate with end-users and business Subject Matter Experts (SMEs) to define technical specifications for reporting requirements and create comprehensive technical documentation.
  • Promote and implement best practices in reporting to enhance data quality and accessibility.
  • Develop and modify mappings in Microstrategy and SQL reporting to align with business objectives.
  • Work closely with business analysts and process owners to develop test cases and scripts for validation.
  • Provide post-deployment support and troubleshoot any defects that may arise.
  • Utilize Agile/Scrum methodologies to manage project timelines and deliverables.
  • Exhibit excellent communication and presentation skills to effectively convey complex information.
  • Foster a collaborative team environment and demonstrate strong problem-solving abilities.

About Comtech LLC

About Comtech LLC: Founded in 1998 and proudly woman-owned, Comtech LLC is headquartered in Reston, VA. We deliver innovative IT solutions across various domains, including program/project management, application development, infrastructure, cybersecurity, and enterprise content/data management services. Our methodologies are based on the IT Infrastructure Library (ITIL) v.3 Framework, and we hold multiple externally accredited certifications such as ISO 9001:2008, ISO/IEC 20000-1:2011, ISO 27001:2005, and CMMI-DEV Level 3, ensuring quality and excellence in all our operations.

Similar jobs

Browse all companies, explore by city & role, or SEO search pages.

Tailoring 0 resumes

We'll move completed jobs to Ready to Apply automatically.