Title: Business Intelligence Technician (764918)
Location: 219 Finance Building Harrisburg PA 17120
Note: This 40-hour-a-week position is primarily remote. The candidate will have to periodically come on-site (once a month) to meet with the business team.
Method of interview is initial virtual interview via Teams followed potentially by an in-person interview (at 219 Finance Building Harrisburg PA 17120).
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 to the business unit (Bureau of Savings Programs) with close collaboration with Treasury s IT department.
- 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.
- Bachelors 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.
If you are: bright motivated skilled a difference-maker able to get things done work with minimum direction
enthusiastic a thinker able to juggle and multi-task communicate effectively and lead then
we would like to hear from you. We need exceptionally capable people for this role for our client
so get back to us and tell us why you think you are a fit.
About Us:
firm in the Philadelphia region. Tri-Force specializes in IT staffing software development (web and mobile apps)
systems integration data analytics system automation cybersecurity and cloud technology solutions for government
and commercial clients. Tri-Force works with clients to overcome obstacles such as increasing productivity
increasing efficiencies through automation and lowering costs. Our clients benefit from our three distinguishing
core values: integrity diligence and technological excellence.
Tri-Force is a six-time winner among the fastest-growing companies in Philadelphia and a four-time winner on the
Inc. 5000 list of the nations fastest-growing companies.
Minimum 5 years of experience in data analys is 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.
Education
Bachelor's degree in Computer Science, Statistics, Mathematics or related field.