Business Intelligence Technician Job Title - Business Intelligence Technician

Digitek Software, Inc.; Harrisburg (Dauphin County); On-site; USD 75,000 - 95,000; Full time

Job summary

A leading company is seeking a Business Intelligence Technician to design and implement robust BI solutions for driving data-driven decisions across various programs. The ideal candidate will have experience in managing and analyzing large datasets using Microsoft tools, particularly Power BI and SQL, to provide effective insights and automation solutions. This role demands strong analytical capabilities along with excellent communication skills, making it integral to the success of the Bureau of Savings Programs.

Qualifications

• 5+ years of experience in data analysis or related fields.
• Expert in Microsoft reporting tools and data management.
• Strong analytical skills and ability to communicate insights.

Responsibilities

• Liaison between business unit and IT for data solutions.
• Define and implement data storage and reporting solutions.
• Analyze data using statistical methods to identify trends.

Skills

Data Analysis

Problem-Solving

Communication

Presentation

Statistical Methods

Education

Bachelor's degree in Computer Science

Bachelor's degree in Statistics

Bachelor's degree in Mathematics

Tools

Azure Dataverse

SQL Server

Power BI

Power Automate

Excel

Python

Job description

One of our Client is looking for the position of Business Intelligence Technician based on following skills:

Bachelor's degree in computer science, statistics, mathematics, or related field with 5+ years of Business Intelligence experience.

Position summary

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.

Responsibilities

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.

The successful candidate may have to undergo a drug test and background check.

Rakhi,

*3137

Digitek Software, Inc.

650 Radio Drive, Lewis Center, OH 43035 Tel No ext. 3137

Email

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.