Sr Data Analyst - Education

For more information about the position, including the complete job description and the compensation information, click Apply Now.

 

 

Duties and Responsibilities:

 

 

 

• Works with internal and external clients to identify analytical requirements.
• Writes advanced SQL queries and perform complex data mining techniques to capture appropriate data.
• Produces reports, dashboards, and data visualizations to satisfy client requirements.
• Automates business processes with Power Apps and Flows.
• Documents processes and procedures used to produce reports.
• Performs business analysis to identify opportunities for business improvement.
• Interprets results of data analysis to business users.
• Leads special projects, including delegation and validation of tasks to other team members.
• Liaises with IT team on regarding data governance and requirements of the data warehouse.
• Participates in an Agile team as a Team Member.

 

 

 

Required / Desired Experience: 

 

 

 

• Bachelor's degree (Required).
• 4+ years' work experience in Data Analysis

 

 

Required Skills:

 

 

• T-SQL (complex queries, joins, unions, creating tables, etc.).
• Reporting Services & Report Builder.
• Power BI.
• DAX.
• SQL Server (SSMS, SSIS).
• Microsoft Power Apps.
• Microsoft Flow.
• Excel (PivotTables, various functions like VLOOKUP, SUMIFS, etc.)
• R and M a plus.
• Strong understanding of relational databases and data warehouses.
• Microsoft Office.
• Critical thinking and problem solving.

 

 

 

Remote Work Statement: 

 

 

 

This position is a remote, work from home position. PCG is a remote-friendly organization and is committed to creating a culture where remote work remains a vital part of the company’s success. To be successful in a remote work role at PCG, you must:

 

 

 

• be available during your set working hours
• have a safe, private, and distraction-free environment in which to complete your work, and
• be able to give your full attention to the completion of your PCG job duties

 

 

 

Some travel to the office or elsewhere may be required for team meetings, client meetings, etc.

 

 

 

#REMOTE

#LI-REMOTE

#LI

#EDU

 

Public Consulting Group LLC (PCG) is a leading public sector solutions implementation and operations improvement firm that partners with health, education, and human services agencies to improve lives. Founded in 1986, PCG employs approximately 2,000 professionals throughout the U.S.—all committed to delivering solutions that change lives for the better. The firm is a member of a family of companies with experience in all 50 states, and clients in six Canadian provinces and Europe. PCG offers clients a multidisciplinary approach to meet challenges, pursue opportunities, and serve constituents across the public sector. To learn more, visit www.publicconsultinggroup.com. 

 

Public Consulting Group is an Equal Opportunity Employer dedicated to celebrating diversity and intentionally creating a culture of inclusion. We believe that we work best when our employees feel empowered and accepted, and that starts by honoring each of our unique life experiences. At PCG, all aspects of employment regarding recruitment, hiring, training, promotion, compensation, benefits, transfers, layoffs, return from layoff, company-sponsored training, education, and social and recreational programs are based on merit, business needs, job requirements, and individual qualifications. We do not discriminate on the basis of race, color, religion or belief, national, social, or ethnic origin, sex, gender identity and/or expression, age, physical, mental, or sensory disability, sexual orientation, marital, civil union, or domestic partnership status, past or present military service, citizenship status, family medical history or genetic information, family or parental status, or any other status protected under federal, state, or local law. PCG will not tolerate discrimination or harassment based on any of these characteristics. PCG believes in health, equality, and prosperity for everyone so we can succeed in changing the ways the public sector, including health, education, technology and human services industries, work.