MicroStrategy Developer (BI Engineer)

MicroStrategy Developer(BI Engineer)

Softrams, a Tria Federal company, prides itself in leading the charge for innovation and transformation in the federal government space. We offertechnologicalimplementations and build customer-centric services that are simple, intuitive, and usable across multiple industries. By partnering with federal agencies, our specialized digital services are reimagining and reshaping the digital landscape to bring positive change for millions of Americans.

Softrams,acquiredin November 2024, forms the core of Tria Federal's new Public Health business unit. Tria Federal (Tria)deliversmission-critical technicalexpertiseand digital services informed by deep customerexpertiseto Health and Public Safety agencies across the federal sector.

At Tria, we are a dynamic professional community driven by a mission rooted in service to colleagues, customers, andthecommunity. Tria invests in its employees with a top-tier benefits package to support their physical, mental, and financialwell-being.

Job Description:

We are seeking a skilled MicroStrategy Developer with strong Oracle and PostgreSQL databaseexpertiseand advanced SQL skills to design, develop, andmaintainenterprise BI solutions. The ideal candidate must have hands-on experience with MicroStrategy Workstation, along with exposure to modern BI tools such asAWSQuickSightand/or PowerBI. 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.

• Mustresidein 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.

• Candidateis required totravel 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 AWSQuickSight, 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 andoptimizecomplex 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.

• Optimizereports, 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

• AWSQuickSight(or similar BI tools)

• Snowflake (Niceto 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 yearsis required tobe eligible to qualify for public trust clearance sponsorship.

Work Location:

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

EEO Statement:

Softrams, a Tria Federal Company, is an affirmative action and equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, disability, age, sexual orientation, gender identity, national origin, veteran status, or genetic information. Softrams iscommitted to providing access, equal opportunity, and reasonable accommodation for individuals with disabilities in employment, its services, programs, and activities. To request reasonable accommodation, or toparticipatein the job application or interview process, contact the Talent Acquisition Team atrecruiting@softrams.com

Know your rights poster:https://www.eeoc.gov/sites/default/files/2023-06/22-088_EEOC_KnowYourRights6.12ScreenRdr.pdf