Data Analyst

•

About the Role

The Water & Natural Resources Department at AKRF is seeking a Data Analyst to work in our Philadelphia, PA office. This position combines full-stack data work, including ad hoc analysis, data pipeline development, and Shiny application development, with the opportunity to support and strengthen the infrastructure that supports compliance programs. You’ll work across data, technology, and compliance, partnering with project teams and subject matter experts to build better tools, improve data quality, and turn complex data into actionable insights for leadership and regulators.

Job Responsibilities:

• Transition MS Access databases to Postgres databases and accompanying Shiny apps.
• Document and codify compliance metrics.

• Develop, maintain, and oversee data pipelines supporting compliance analytics and reporting.
• Conduct complex compliance analyses and prepare reports for leadership and regulators.
• Partner with project teams and subject matter experts to improve data quality, analyses, and processes.

Essential Requirements:

• 1–3+ years of experience in data analysis or a related field, with a passion for working with large and complex datasets to produce applications, dashboards, and analyses.
• 1–3 years of experience using R, preferably, or another scripting language such as Python or Julia.
• Experience with SQL and relational databases, preferably PostgreSQL or SQL Server.
• Experience developing data applications or dashboards; experience with Shiny and Posit Connect is a plus.
• Familiarity with data and workflow tools such as GitHub and Power Automate is a plus.
• Good judgment in selecting statistical methods and applying sound coding practices.
• Excellent written communication skills, including the ability to document project scopes, standard operating procedures, and data dictionaries.
• Strong attention to detail and a commitment to producing accurate, consistent, high-quality work.

Compensation

Compensation to commensurate with experience.

Why Work at AKRF

Founded in 1981, AKRF is an award-winning consulting firm with 400 planners, engineers, designers, economists, ecologists, geologists, historians, archaeologists, acousticians, and many other types of professionals guided by the belief that to be original is to be transformative.

Professionals join and remain at AKRF for our corporate-casual environment that values flexible work schedules and locations, and balances award-winning projects with social impact initiatives, charitable giving, and plenty of fun and games. We foster a diverse, equitable, and inclusive environment where employees are respected and valued in honor of their identities; we strive to deliver on this promise every day. Our cookie exchanges and ice cream socials are quite the treat.

What We Offer

We provide employees with a benefit package that reflects our respect for your workplace contributions, professional goals, and personal priorities. The benefits program at AKRF includes:

• Medical, Dental, Vision insurance
• Vacation and Sick time
• Flexible work schedules and locations
• 401(k) retirement plan with employer matching
• Additional Voluntary Life Insurance
• Short- and Long-Term Disability
• Stock Ownership
• Tuition Reimbursement
• Training and professional development courses
• Opportunities for community outreach through internal networks
• Charitable donation match
• Transit/parking program

Equal Opportunity Company

AKRF enforces a policy of equal employment opportunity in our daily operations. The firm has a demonstrated history of hiring, training, developing, promoting and retaining minority group members and women. All employment-related decisions are based solely on relevant criteria and without regard to race, color, religion, age, sex, pregnancy, national origin, age, physical or mental disability, marital status, sexual orientation, sexual identity, caregiver status, military/veteran status or citizenship status, or any other characteristic protected by federal, state, or local law.