MicroStrategy Developer/BI Engineer
(HYBRID - 1 day onsite at Baltimore MD)
At Tria, we are a dynamic professional community driven by a mission rooted in service to colleagues, customers, and the community. Tria invests in its employees with a top-tier benefits package to support their physical, mental, and financial well-being.
Job Description:
We are seeking a skilled MicroStrategy Developer with strong Oracle and PostgreSQL database expertise and advanced SQL skills to design, develop, and maintain enterprise BI solutions. The ideal candidate must have hands-on experience with MicroStrategy Workstation, along with exposure to modern BI tools such as AWS QuickSight and/or Power BI. This role will also leverage AI/GenAI tools to help automate report generation, documentation, and data analysis workflows, and support natural language query (NLQ) capabilities for BI dashboards to improve self-service analytics. Experience with Snowflake is a plus
Requirements:
- Ability to obtain a U.S. Federal Position of Trust clearance designation.
- Must reside in and be able to perform work in the United States.
- Must have lived in the United States for 3 of the last 5 years.
- Bachelor’s degree in computer science, engineering, technology, data science, statistics, analytics, or related quantitative and software development field.
- Candidate is required to travel to our Baltimore office once a week (Tuesday).
- 5+ years of MicroStrategy development experience, including MicroStrategy Workstation.
- Strong hands-on experience with Oracle and PostgreSQL databases.
- Advanced SQL skills, including performance tuning and query optimization.
- Solid understanding of data warehousing concepts and dimensional modeling.
- Experience with BI/visualization tools such as AWS QuickSight, Tableau, or Power BI.
- Strong analytical and problem-solving skills.
- Familiarity with Generative AI tools (ChatGPT, Copilot, etc.) for data analysis and productivity.
- Must show appetite for active learning, embracing change and mentoring others in organization.
Responsibilities:
- Design, develop, and deploy MicroStrategy reports, dashboards, and schema objects using MicroStrategy Workstation.
- Write and optimize complex SQL queries across Oracle and PostgreSQL databases.
- Build and manage MicroStrategy metadata (attributes, facts, hierarchies, transformations).
- Collaborate with business stakeholders to translate requirements into BI solutions.
- Optimize reports, dashboards, and queries for performance and scalability.
- Integrate MicroStrategy with Oracle, PostgreSQL, and other data sources.
- Troubleshoot and resolve data and reporting issues.
- Maintain documentation for BI solutions and data models.
- Leverage AI/GenAI tools to automate report generation, documentation, and data analysis workflows.
- Build or integrate natural language query (NLQ) capabilities for BI dashboards (e.g., “ask your data” features).
Key Skills:
- MicroStrategy Workstation (Must Have)
- Oracle & PostgreSQL (Must Have)
- Advanced SQL
- MicroStrategy Reporting & Schema Design
- Data Modeling & Warehousing
- AWS QuickSight (or similar BI tools)
- Snowflake (Nice to Have)
Preferred Qualifications:
- Experience with Snowflake (Nice to Have).
- Experience with AWS services (S3, Redshift, Lambda, etc.).
- Familiarity with ETL tools and data pipelines.
- Experience with performance tuning (execution plans, indexing, partitioning).
- Experience in Agile/Scrum environments.
Nice to Have Skills, Knowledge & Experience:
- Python or scripting.
- API/data integration experience.
- Knowledge of data governance and security.
Public Trust Clearance:
Many of our roles require the hired candidate to go through public trust clearance. A minimum of 3 years of stay in the U.S. within the last 5 years is required to be eligible to qualify for public trust clearance sponsorship.
Work Location:
Headquartered in Arlington, VA, we also have a primary office in Baltimore, MD for those who prefer to work on-site. However, with employees spread across 40+ states, we have many remote roles.
