Senior BI Engineer

We are seeking a skilled Senior BI Engineer 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.

Tria Federal delivers digital services and technology solutions that support the health and safety of veterans, service members and civilians. For two decades, federal agencies have relied on Tria companies to advance their critical missions and modernize their systems, so that they can uphold their commitment to the American people. Today, we are pushing the boundaries of possibility through partnerships and investments in artificial intelligence and emerging technologies, developing solutions for the biggest challenges that government will face tomorrow., 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., What defines the Tria brand is more than just our dedication to excellence in our craft; it’s our incredible team of dedicated, talented, and passionate people that make Tria so exceptional. As people powering possible, we are all partners in our team’s shared success.

As a company that cares about people, we seek to cultivate a culture in which all can thrive personally and professionally. We offer a top-tier benefits package to invest in your physical, mental, and financial health and wellness so that you can be your best self - at work and in life. At Tria, we are growth-minded, entrepreneurial in spirit, and committed to fostering a culture of inclusion and opportunity for all. Whatever your background, your role, your department, or stage in your professional journey, here you will have opportunities to learn new skills, seize new challenges, and advance your career as we grow.