Business Intelligence Developer

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, * 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).

• 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., * 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.

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., 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.