Business Intelligence Technician Jobs

Ocean Blue Solutions

Location:
United States, Harrisburg

Category:
IT - Software Development

Contract Type:
Not provided

Salary:

Not provided

Save Job

Apply Position

Job Description:

PA Treasury is looking for a Business Intelligence Technician to build a comprehensive business intelligence solution for the Bureau of Savings Programs, which administers the PA 529 College and Career Savings Program, PA ABLE, and Keystone Scholars. The Business Intelligence Technician will be responsible for organizing, automating, analyzing, and interpreting large datasets to help identify trends, inform marketing strategies, enable market segmentation, make business decisions, and evaluate program results, with the ultimate objective to help families save for their future. The Business Intelligence Technician will have an understanding of data structures, and experience in data management, analysis, and reporting. This position will report into the business unit (Bureau of Savings Programs) with close collaboration with Treasury’s IT department.

Job Responsibility:

Serve as liaison between the business unit and IT to define, design, implement and maintain a data storage, management, reporting and analysis solution
Work with business unit to identify business requirements and translate them into data project specifications
Synthesize data from various sources and transform into uniform formats for manipulation and analysis
Work with a variety of Microsoft reporting and analytics tools and techniques to explore data (Azure Dataverse, SQL Server, Power BI, Power Automate, etc.)
Develop efficient algorithms and queries to clean and process data
Analyze and interpret data using statistical methods and analytical tools like Excel, SQL, Power BI, Python, etc.to identify patterns, trends, and insights
Create visualizations and reports to communicate data-driven insights to stakeholders
Work within Treasury IT framework, toolsets, and security policies to create repeatable, efficient, and scalable data automation and analytic solutions
Evaluate and recommend opportunities to automate computational processes to increase efficiency and accuracy of cleaning, validating, organizing, and processing data and, once approved by business unit, execute those processes
Establish processes to monitor and evaluate the sustainability of data analytic related capabilities

Requirements:

Bachelor's degree in Computer Science, Statistics, Mathematics or related field
Minimum 5 years of experience in data analysis or related field
Expert proficiency in Microsoft reporting tools (Azure Dataverse, SQL Server, Power BI, Power Automate, Etc.)
Strong analytical and problem-solving skills
Excellent communication and presentation skills

Additional Information:

Job Posted:
December 10, 2025

Employment Type:

Fulltime

Work Type:

Hybrid work

View All Jobs In This Company

Job Link Share:

Business Intelligence Technician