Business Intelligence Analyst (Full Stack)

Horizon Farm Credit, ACA; Mechanicsburg (Cumberland County); Hybrid; USD 89,000 - 133,000; Full time

Benefits offered by this job

Medical insurance

401(k) with employer match

Paid time off & holidays

Tuition reimbursement

Student loan reimbursement

Career development opportunities

Maternity leave

Inclusive work environment

Job summary

Horizon Farm Credit, ACA is seeking a Full Stack Analytics Developer to blend application development, BI, analytics, and UX to deliver impactful solutions. You will collaborate with stakeholders, data professionals, and tech teams to build scalable apps, data models, and reporting that support a data-driven culture.

The role emphasizes Power BI reporting, API and backend services, and user-centered design to ensure usable and valuable analytics across the organization. Hybrid work is offered.

Qualifications

• Bachelor's degree in a relevant field or equivalent experience.
• 0 to 5 years in software analytics or BI roles.
• Experience with SQL and relational databases.
• Experience developing Power BI dashboards and reports.
• Experience with Python development and scripting.
• Understanding of modern web app development concepts.
• Knowledge of UX design principles.

Responsibilities

• Design, develop, test, and maintain web-based business applications.
• Create front-end interfaces using modern frameworks and best practices.
• Develop back-end services, APIs, and integrations.
• Participate in full software development lifecycle and support.
• Troubleshoot and improve performance and usability.
• Design and optimize data models for reporting and analytics.
• Collaborate with BI teammates and business teams on reporting needs.
• Develop Power BI reports, dashboards, and visual analytics.

Skills

SQL

Power BI

Python

UX Design

Data Modeling

Database Development

Dashboard Development

Application Development

Education

Bachelor's degree in Computer Science, Information Systems, Software Engineering, Data Analytics, or related field

Tools

JavaScript/TypeScript

React/Angular

HTML/CSS

REST APIs

Azure

Git / Source Control

Power Automate

AI Tools

Job description

Horizon Farm Credit is actively recruiting for a Full Stack Analytics Developer, internally referred to as a Business Intelligence Analyst, to join our team. This is an exciting opportunity for an experienced professional who enjoys combining application development, business intelligence, analytics, and user experience design to deliver solutions that drive efficiency and business value. In this role, you will work closely with business stakeholders, data professionals, and technology teams, the Full Stack Analytics Developer will build scalable applications, develop data models and reporting solutions, create intuitive user experiences, and support the organization's growing data-driven culture.

Qualified candidate may work in any available HFC branch location.

The hours of operation are typically, Monday to Friday from 8 a.m. to 4:30 p.m. This position is eligible for hybrid work schedule.

Key Responsibilities

• Application Development
  • Design, develop, test, and maintain web-based business applications.
  • Create front-end user interfaces using modern development frameworks and best practices.
  • Develop back-end services, APIs, and integrations to support business processes.
  • Participate in the full software development lifecycle, including requirements gathering, design, development, testing, deployment, and support.
  • Troubleshoot and resolve application issues while continuously improving performance and usability.
• Data & Analytics
  • Develop and optimize SQL queries, stored procedures, and database solutions.
  • Design and support data models that enable efficient reporting and analytics.
  • Collaborate with Business Intelligence teammates, analysts, and business teams to understand and fulfill reporting requirements.
  • Ensure data quality, integrity, and consistency across solutions.
• Business Intelligence & Reporting
  • Design and develop Power BI reports, dashboards, and visual analytics solutions.
  • Create meaningful visualizations that help users identify trends, insights, and opportunities.
  • Translate business requirements into actionable metrics and performance indicators.
  • Support users with report enhancements and ongoing analytics needs.
• User Experience (UX) Design
  • Design intuitive and user-friendly application interfaces.
  • Conduct user research and gather feedback to improve usability.
  • Create wireframes, prototypes, and workflow designs for new applications.
  • Apply UX and accessibility best practices to improve user adoption and satisfaction.
• Collaboration & Continuous Improvement
  • Work closely with business stakeholders to understand processes and identify opportunities for improvement.
  • Document technical solutions, processes, and development standards.
  • Participate in code reviews and contribute to development best practices.
  • Stay current on emerging technologies, development tools, and analytics capabilities.

Required Qualifications

• Bachelor's degree in Computer Science, Information Systems, Software Engineering, Data Analytics, or related field, or equivalent combination of education and experience.
• Generally, 0 to 5 years of experience in software development, analytics, business intelligence, or related technical roles.
• Experience with SQL and relational database concepts.
• Experience developing Power BI dashboards and reports.
• Experience with Python development and scripting.
• Understanding of web application development concepts and modern development frameworks.
• Knowledge of UX design principles and user-centered design practices.
• Strong analytical, problem-solving, and troubleshooting skills.
• Strong written and verbal communication skills.

Preferred Qualifications

• Experience with JavaScript, TypeScript, React, Angular, or similar front-end frameworks.
• Experience developing APIs and back-end services.
• Experience working with Microsoft SQL Server.
• Familiarity with cloud platforms such as AWS and on-prem solution development.
• Experience integrating multiple data sources and business systems.
• Knowledge of data visualization and dashboard design best practices.
• Exposure to AI, automation, or machine learning technologies.
• Experience working in Agile development environments.

Technical Skills Required

• SQL
• Power BI
• Python
• UX Design
• Data Modeling
• Database Development
• Dashboard Development
• Application Development

Technical Skills Preferred

• JavaScript / TypeScript
• React or Angular
• HTML/CSS
• REST APIs
• Azure
• Git / Source Control
• Power Automate
• AI and Generative AI Tools

Who are we?

Horizon Farm Credit is an expert in agriculture, with over 100 years of serving rural America. As a premier rural lender, we're constantly growing and seeking new members for our team. As part of the Horizon Farm Credit team, you have the opportunity to make a difference for agriculture and rural communities.

What can we offer you?

• Medical insurance with dental and vision care options
• 401 (k) with significant employer matching
• Paid time off, holidays, and volunteer time to support work/life balance
• Tuition reimbursement and training opportunities
• Student loan reimbursement
• Leadership and career development opportunities
• Paid maternity and bonding leave
• Fun and inclusive work environment

The salary range for this position is $89,100 to $132,800, with a midpoint of $110,800. This range reflects current market compensation data and our commitment to competitive, equitable pay. The starting rate is based on the applicant's relevant experience, qualifications, and internal equity considerations. Most new hires are offered a starting rate between the minimum and midpoint of the range, although placement elsewhere in the range may be appropriate based on the candidate's qualifications and experience.

Equal Opportunity Employer including veterans and individuals with disabilities.