Business Intelligence Consultant

Role: Business Intelligence Technician

Location: Remote Harrisburg, PA Must be local or within a one-hour drive

Duration: +12 Months contract

Visa: All Visa except TN and CPT

Interview: Method of interview is initial virtual interview via Teams followed potentially by an in-person interview

Candidate will have to periodically come onsite (once a month) to meet with the business team

Description:

Immediate need for Business Intelligence Technician, with 5+ years of Business Intelligence experience, to build a comprehensive business intelligence solution for the Bureau of Savings Programs, which administers the 529 College and Career Savings Program. Bachelor's degree in computer science, statistics, mathematics, or related field with 5+ years of Business Intelligence experience.

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.

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.

Minimum 5 years of experience in data analysis or related field.

Required

5

Bachelor's degree in Computer Science, Statistics, Mathematics or related field.

Required

Expert proficiency in Microsoft reporting tools (Azure Dataverse, SQL Server, Power BI, Power Automate, Etc.).

Required

Strong analytical and problem-solving skills.

Required

Excellent communication and presentation skills.

Required