PICPA is seeking a Data Analyst with strong technical and analytical skills to execute the data driven strategy for our evolving organization. This role is for a hands-on individual who is expertly adept at extracting, manipulating, and analyzing data from disparate datasets. This opportunity will have you work collaboratively with PICPA teams and individuals to understand their business requirements, identify and extract relevant data, analyze and interpret the information, and deliver visualizations, reports, and dashboards to support business decision making and operational insights.
Adept in developing ETL pipelines, stored procedures, and automations
Authoring advanced SQL, Python, and other relevant development frameworks to effectively query and navigate across multiple data domains
Provides hands-on, technical expertise to collaborate on and implement best practices in warehouse design and cloud architectures
Intuitively understand our data, ETL processes, business and transformation rules, and data consuming systems.
Data driven decision making
Identifies, creates, and facilitates the reporting and analysis of strategic and operational initiatives
Works with individuals and teams to interpret data requirements, translate requests into technical specifications, effectively prioritize, and maintain feedback loops
Troubleshoot and diagnose data quality issues and anomalies and offer data findings and analysis outcomes
Self-learner and eager to understand data, business processes, concepts, and technologies.
An integral collaborator to identify and develop key business drivers tied to data and metrics
Interacts at all levels to ensure reliable, accurate, relevant, and appropriately processed data is available for business decision making
Skills & Qualifications
Bachelor’s degree in related disciplines or equivalent experience
3 – 5+ years of experience in analytics, data extracting, reporting, and scripting.
Technical writing experience including documentation, reports, and presentations
Strong analytical and technical skills
Ability to communicate with both technical and nontechnical stakeholders at all levels
Able to understand business needs and how data can be used to find solutions
Power BI (Online and Desktop)
Strong SQL, Python, and complimentary development skill
Proficient in Excel and the Microsoft ecosystem at large (Office 365, SharePoint, Visio, PowerPoint)
Data Science and AI
Microsoft Flow/Power Automate
About the Culture
PICPA is a future thinking, equal opportunity employer fostering a positive and collaborative work environment where you can make a difference in every role. We value collaboration and personal initiative, and PICPA is committed not only to our members but to our employees’ satisfaction and success. We recognize that our people are our greatest asset, enabling PICPA to achieve outstanding results. We invest heavily in technology and provide our team with ongoing education, training opportunities, competitive benefits, and flexible work schedules.
About the Benefits
Eligible for remote work; In-office collaboration a few times a month
35-hour work week
Flexible schedules available after 6 months
Employer paid Health, Dental, Life & Disability Insurance for employees, beginning first day of employment
Employer pays a portion of deductible & dependent medical premium
401(k) and Roth 401(k) plans - After one year employer contributes 100% match up to 6% of salary, plus 2% of salary to a profit-sharing plan
10 holidays each year, PTO, and paid volunteer time off
Tuition reimbursement and professional development
PICPA is a future thinking, equal opportunity employer fostering a positive and collaborative work environment where you can make a difference in every role. A dynamic, evolving organization dedicated to providing quality, relevant and engaging opportunities for Pennsylvania’s Certified Public Accountants (CPAs). We value collaboration and personal initiative, and PICPA is committed not only to our members but to our employees’ satisfaction and success. We recognize that our people are our greatest asset, enabling PICPA to achieve outstanding results. We invest heavily in technology and provide our team with ongoing education, training opportunities, competitive benefits, and flexible work schedules.
Founded in 1897, the Pennsylvania Institute of Certified Public Accountants (PICPA) is the second-oldest CPA organization in the United States and the largest CPA association in Pennsylvania. Our more than 20,000 members include practitioners in public accounting, industry, government, and education. The PICPA supports current and future CPAs by providing education, networking, leadership, and volunteer opportunities. We represent the voice of the CPA profession in Pennsylvania thr...ough our advocacy efforts in the state legislature and promoting public confidence in CPAs and the quality of their services. Affiliation with the PICPA represents commitment to the CPA profession, including adherence to a Code of Professional Conduct and a stringent set of professional and technical standards.