

Solution Analyst
β - Featured Role | Apply direct with Data Freelance Hub
This role is for a Solution Analyst with 2-3 years of experience in SQL (PostgreSQL & Oracle), Power BI, and software testing. The contract lasts 7 months, offering a hybrid work model with onsite requirements for the first 90 days.
π - Country
United States
π± - Currency
$ USD
-
π° - Day rate
-
ποΈ - Date discovered
June 4, 2025
π - Project duration
More than 6 months
-
ποΈ - Location type
Hybrid
-
π - Contract type
Unknown
-
π - Security clearance
Unknown
-
π - Location detailed
Boston, MA
-
π§ - Skills detailed
#"ETL (Extract #Transform #Load)" #SQL (Structured Query Language) #Process Automation #Oracle #BI (Business Intelligence) #SQL Queries #Data Modeling #Business Analysis #Microsoft Power BI #UAT (User Acceptance Testing) #PostgreSQL #Automation #Data Extraction #Regression
Role description
Heading 1
Heading 2
Heading 3
Heading 4
Heading 5
Heading 6
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.
Block quote
Ordered list
- Item 1
- Item 2
- Item 3
Unordered list
- Item A
- Item B
- Item C
Bold text
Emphasis
Superscript
Subscript
Hybrid Details: Onsite first 90 calendar days, then 2-3 days/week onsite
Duration: 7 months to start
Position Summary
The Application and Data Services Unit within the IT Division is looking for a Solution Analyst with 2-3 years of experience in SQL query writing (PostgreSQL & Oracle), Power BI (dashboard creation, reporting, and data modeling), software testing, and business analysis. This role will bridge the gap between data, applications, and business processes to support decision-making and system improvements. The position will begin as a contract role, with the potential for transition to full-time employment after six to twelve months based on performance and business needs.
Responsibilities
β’ Write, optimize, and troubleshoot SQL queries in PostgreSQL and Oracle for data extraction and reporting.
β’ Design, develop, and maintain Power BI dashboards, reports, and data models to provide actionable insights.
β’ Conduct software testing (functional, regression, UAT) to ensure system reliability and performance.
β’ Collaborate with stakeholders to gather, analyze, and document business and system requirements.
β’ Validate and troubleshoot data inconsistencies across various applications and reports.
β’ Work closely with Vendors, business users, and IT teams to improve application functionality and efficiency.
β’ Serves as liaison and facilitator between business units to assist in addressing and resolving MyTRS issues with vendor resources.
β’ Reviews, analyzes, and completes help desk tickets as appropriate to the position.
β’ Participate in daily huddles and project meetings.
β’ Assist in process automation and system enhancements.
Qualifications
β’ Bachelor s degree in Information Technology or related discipline
β’ 2-3 years of experience in writing complex SQL queries using PostgreSQL and Oracle.
β’ 2-3 years of hands-on experience with Power BI, including dashboard development, reporting, and data modeling.
β’ 2-3 years of experience in software testing, including creating test plans, executing test cases, and reporting defects.
β’ Strong analytical and problem-solving skills.
β’ Strong written, verbal, and interpersonal skills
β’ Ability to anticipate and identify problems and provide appropriate solutions
β’ Ability to translate business needs into technical specifications and actionable solutions.
β’ Excellent communication skills and experience working with cross-functional teams