The Office of the Chief Administrative Officer (CAO) needs to manage, support, upgrade, and troubleshoot the MicroStrategy application and its Microsoft SQL databases to ensure optimal system performance and reliability for business solutions and operations support services to House Members, Officers, and staff.
Requirements
- Ability to design logical and physical data models.
- Experience with SQL Server databases.
- Ability to perform data extraction, transformation, and loading (ETL).
- Ability to learn and apply new technologies.
- Experience with Windows Server or similar technologies.
- Experience with web development or similar technologies.
- Experience developing for accounting or financial data and processes.
- MicroStrategy software development kit (SDK), including customizing analytical applications and portal integration.
- Reporting skills, including data and style manipulations in Desktop, OLAP Services, Report Objects, Advanced Filters, Advanced Metrics, Prompts and Searches, Intelligent Cubes, Derived Elements, and Dashboards.
Responsibilities
- Administer and support the MicroStrategy applications and associated databases for the FinMart project.
- Support implementation, upgrade, and operation of MicroStrategy and SQL Server for FinMart.
- Support Microsoft SQL data extraction, transformation, and loading (ETL) into the enterprise financial data warehouse.
- Research, evaluate, recommend, and ultimately implement solutions to meet business requirements.
- Design and develop MicroStrategy reports and dashboards.
- Ensure projects are properly developed and defined for successful implementation, all stakeholders are engaged, and processes and standards are followed for proper execution and control.
- Support migration of on-premise MicroStrategy environment to the Cloud.
Other
- Ten (10) years of experience doing development, system integration, and application administration.
- Five (5) of those years must be supporting MicroStrategy deployment(s).
- Strong writing skills and comfort working with customers.
- Ability to work independently with limited guidance and oversight.
- Candidates should be committed to improving the efficiency of the Federal government, passionate about the ideals of our American republic, and committed to upholding the rule of law and the United States Constitution.
