Senior BI Engineer

About the role

Tria Federal delivers digital services and technology solutions that support the health and safety of veterans, service members, and civilians. 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.

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

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.

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) (Nice to Have)
• Snowflake (Nice to Have)

Preferred Qualifications

• Experience with Snowflake (Nice to Have).
• Experience with AWS services (S3, Redshift, Lambda, etc.) (Nice to Have).
• Familiarity with ETL tools and data pipelines (Nice to Have).
• Experience with performance tuning (execution plans, indexing, partitioning) (Nice to Have).
• Experience in Agile/Scrum environments (Nice to Have).

Nice to Have Skills, Knowledge & Experience

• Python or scripting (Nice to Have).
• API/data integration experience (Nice to Have).
• Knowledge of data governance and security (Nice to Have).

Pay

Competitive salary based on experience and qualifications.

Schedule

Full-time position with flexible working hours.