Business Intelligence SME – MicroStrategy (Senior)

About the Company: Cloud7Works is seeking a highly experienced Business Intelligence SME – MicroStrategy (Senior) to support a mission-critical federal reporting and analytics program. The selected candidate will provide enterprise-level business intelligence sustainment, reporting, ETL support, data visualization, analytics modernization, and MicroStrategy platform administration in a secure federal environment. This role requires deep expertise in MicroStrategy, SQL Server data warehousing, ETL operations, AWS-hosted BI environments, and federal compliance standards. About the Role: The selected candidate will provide enterprise-level business intelligence sustainment, reporting, ETL support, data visualization, analytics modernization, and MicroStrategy platform administration in a secure federal environment. Responsibilities: Business Intelligence Sustainment & Maintenance • Provide ongoing sustainment, operational support, and maintenance for the enterprise reporting environment. • Troubleshoot and resolve MicroStrategy platform issues, report failures, metadata inconsistencies, and system defects. • Monitor system performance and ensure platform stability, availability, and reliability. • Support release management, patching, deployment coordination, and environment configuration activities. Business Intelligence Development • Design, develop, enhance, and maintain enterprise reports, dashboards, scorecards, and visual analytics solutions using MicroStrategy v11.x. • Develop and optimize ad hoc queries and reporting capabilities for business stakeholders. • Create intuitive and effective data visualizations supporting operational and executive-level reporting requirements. • Administer and maintain MicroStrategy metadata objects, schemas, cubes, and security models. ETL & Data Warehouse Support • Support ETL processes and data integration workflows feeding the reporting environment. • Work with SQL Server data warehouse architecture, stored procedures, data transformations, and data validation processes. • Support AWS-based ETL workflows using services such as AWS Glue, Lambda, and Step Functions. • Analyze and resolve data load failures, performance bottlenecks, and data integrity issues. Data Quality & Analytics Support • Perform data validation, reconciliation, and quality assurance activities across reporting datasets. • Identify and remediate inconsistencies in source and downstream reporting environments. • Support business users with customized reporting, analytics troubleshooting, and data interpretation. BI Modernization Support • Support modernization initiatives involving enterprise business intelligence capabilities. • Evaluate and support integration with emerging BI technologies and reporting platforms. • Provide recommendations for scalability, performance optimization, and cloud-based BI enhancements. Quality Assurance & Testing • Develop and execute test plans, validation procedures, and regression testing activities. • Support defect tracking, remediation, and verification efforts. • Participate in Agile/Scrum ceremonies including sprint planning, backlog grooming, demos, and retrospectives. RMF & Compliance Support • Support Risk Management Framework (RMF) compliance activities and security documentation. • Ensure BI solutions comply with applicable federal security policies, data handling requirements, and system hardening standards. • Assist with audit responses, vulnerability remediation, and security assessment activities. Documentation & Training • Develop and maintain technical documentation, SOPs, architecture diagrams, and user guides. • Provide knowledge transfer, end-user support, and training related to reporting capabilities and MicroStrategy tools. Qualifications: • Bachelor’s degree in Computer Science, Information Systems, Engineering, or related field (or equivalent experience). • Minimum 10+ years of enterprise business intelligence development and administration experience. • Minimum 7+ years of hands-on experience with MicroStrategy (v11.x) development and administration. Required Skills: • Demonstrated expertise in Report development, Dashboard design, Data visualization, Metadata administration and Performance optimization • Strong experience with SQL Server data warehouse architecture, Stored procedures and query optimization, and ETL processes and enterprise data integration • Experience with AWS cloud-hosted BI environments, including AWS Glue, AWS Lambda and AWS Step Functions • Familiarity with IIS web server configuration and MicroStrategy Web deployment. • Working knowledge of Microsoft Power BI and/or Tableau or similar. • Experience supporting Agile/Scrum software development environments. • Strong analytical, troubleshooting, and communication skills. Preferred Skills: • Experience supporting federal government programs and secure enterprise environments. • Familiarity with RMF, NIST, and federal cybersecurity compliance requirements. • Experience supporting large-scale enterprise reporting environments. • MicroStrategy certifications are highly desirable. • Experience with cloud modernization and enterprise analytics transformation initiatives. On-Call Support Requirements: This position supports a mission-critical 24x7x365 production environment. The selected candidate will participate in an on-call support rotation to provide after-hours operational support for business intelligence and reporting services. Security Requirements: Must be a United States Citizen. Must be eligible to obtain and maintain a Tier 3 (T3) or higher background investigation and Position of Trust determination.