Business Intelligence Analyst (Full Stack)

Horizon Farm Credit, ACA; Mount Joy (Lancaster County); Hybrid; USD 89,000 - 133,000; Full time

Benefits offered by this job

Medical insurance

401(k) matching

Paid time off

Tuition reimbursement

Student loan assistance

Career development

Maternity leave

Inclusive workplace

Job summary

Horizon Farm Credit, ACA is seeking a Full Stack Analytics Developer (BI Analyst) to join our team. This role blends application development, analytics, and UX to deliver value-driven solutions for business stakeholders.

You will build scalable apps, model data, and create reporting and dashboards using Power BI, SQL, and Python while aligning with our data-driven culture. Qualified candidates may work from any Horizon Farm Credit location with a hybrid schedule, following standard business

Qualifications

• Bachelor's degree in CS, IS, SWE, Data Analytics, or equivalent.
• 0–5 years in software development, analytics, BI, or related roles.
• Experience with SQL and relational databases.
• Experience developing Power BI dashboards and reports.
• Experience with Python development and scripting.
• Understanding of web app development concepts and modern frameworks.
• Knowledge of UX design principles and user-centered design.
• Strong analytical, problem-solving, and troubleshooting skills.
• Strong written and verbal communication.

Responsibilities

• Design, develop, test, and maintain web-based business applications.
• Create front-end interfaces using modern frameworks.
• Develop back-end services, APIs, and integrations.
• Participate in full SDLC from requirements to deployment.
• Troubleshoot and improve performance and usability.
• Develop and optimize SQL queries and data models.
• Design and support data models for reporting and analytics.
• Design, develop Power BI reports and dashboards.
• Translate business requirements into metrics and KPIs.
• Support users with report enhancements and analytics needs.
• Design intuitive and user-friendly interfaces.
• Conduct user research and gather feedback to improve usability.
• Create wireframes, prototypes, and workflow designs.
• Apply UX and accessibility best practices.
• Collaborate with stakeholders to identify improvements and document solutions.
• Participate in code reviews and promote best practices.

Skills

SQL

Power BI

Python

UX Design

Data Modeling

Database Development

Dashboard Development

Application Development

API Development

Education

Bachelor's degree in Computer Science or related field

Tools

Azure

Microsoft SQL Server

Git / Source Control

Power Automate

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.