BI & Analytics Developer

Description

At First Community Bank, we are committed to making our community, the places where we live and work, a better place each day. With a true focus on "community banking," employees find that they can make an impact through company-sponsored programs such as paid volunteer time, matching gifts for charitable contributions, and team participation in charitable events. We offer comprehensive benefits including health, vision, and dental insurance, 401(k) plan with employer match, life insurance, and paid vacation days, holidays, and other time off options. With over 60 locations in four states, First Community Bank offers the personal service you would expect from a company that knows your community. We welcome all applicants and look forward to new colleagues joining our community!

We are seeking a Business Intelligence & Analytics Developer with experience in both traditional BI reporting and applied analytics. This role focuses on building dashboards and reports using the Microsoft BI stack while also developing and supporting basic machine learning models in Python to enhance analytical insights and decision-making.

The ideal candidate has production experience with Power BI and SQL, along with hands-on exposure to applied machine learning using scikit-learn.

Duties and Responsibilities:

• Develop and maintain dashboards and reports using Microsoft Power BI and SSRS.
• Create and manage Power BI datasets, including DAX calculations and measures.
• Partner with business stakeholders to translate reporting and analytical needs into practical solutions.
• Write and optimize T-SQL queries, views, and stored procedures to support reporting and analytics workloads.
• Develop, train, and maintain machine learning models in Python using scikit-learn for use cases such as forecasting, classification, or anomaly detection.
• Integrate model outputs into BI reports or downstream analytical processes.
• Support data preparation workflows, including exposure to SSIS or similar ETL tools.
• Participate in established deployment and release processes using Azure DevOps (or similar tools).
• Monitor and troubleshoot production reporting and analytics solutions.

Requirements

• Bachelor's degree in a quantitative or technical field, or equivalent practical experience.
• 3-5 years of experience in BI, analytics, or data-focused roles.
• Strong experience developing reports and dashboards in Power BI.
• Solid T-SQL skills, including joins, aggregations, and query optimization.
• Hands-on experience using Python for data analysis or modeling.
• Practical experience building machine learning models using scikit-learn (training, evaluation, and basic tuning).
• Experience working in production environments with structured deployment processes.
• Strong attention to data quality, accuracy, and documentation.

Preferred Skills and Qualifications:

• Exposure to SSIS for ETL or data preparation workflows.
• Familiarity with Azure DevOps for source control and deployment of BI and analytics assets.
• Experience operationalizing analytical or ML outputs into reports or business processes.
• Experience supporting analytics in regulated or data-sensitive environments.