Job description

Van Ausdall & Farrar is seeking a detail-oriented and tech-savvy Associate Business Intelligence & Systems Analyst to support and enhance our internal business systems, including CRM, ERP, and ECM platforms. This entry-level role is ideal for individuals with a strong analytical mindset and a passion for data integrity, system optimization, and cross-functional collaboration. As an Associate BI & Systems Analyst, you will serve as an internal administrator and technical liaison, responsible for maintaining data accuracy, troubleshooting system issues, supporting system upgrades and enhancements, and helping drive smarter business decisions through data-driven insights. You’ll work closely with stakeholders across departments to translate business needs into system functionality, while also recommending tools and processes that improve efficiency and user experience. This is a great opportunity for someone early in their career who is eager to grow their skills in data analytics, business intelligence, and enterprise system management within a dynamic and collaborative environment. Hours: Monday-Friday, 8:00 a.m.-5:00 p.m. Location: 6430 E. 75th Street, Indianapolis, IN 46250 Benefits At Van Ausdall & Farrar, our people are our number one asset. Our employees are the driving force that allows us to be successful now, and in the future. Below is an overview of our comprehensive benefits: • Generous PTO • 7 paid holidays + 1 personal holiday of your choosing • Weekly Employee Engagement Activities • Paid volunteer time • Monthly Fitness Reimbursement • Tip Lead/Business Referral Program • Medical, Dental & Vision with corresponding Flexible Spending Account (FSA) and Health Savings Account (HSA) What You Have • Analytical mindset with attention to detail. • Ability to communicate technical information to non-technical stakeholders. • Self-motivated and resourceful problem solver. • Excellent verbal and written communicator—internally and externally. • Meticulous attention to detail with a passion for clean, accurate data. • Able to balance reactive troubleshooting with proactive system improvement. • Comfortable working independently and collaboratively across functions. • Not afraid to speak up, ask questions, or challenge the status quo when needed. • Self-starter with strong project ownership and organizational skills. • Comfortable working in a fast-paced, collaborative environment. What You'll Do • Act as the internal CRM, ERP, ECM, and other internal business systems administrator, ensuring data integrity and system performance. • Collaborate with internal stakeholders to gather requirements, troubleshoot, improve, and optimize workflows, integrations, reporting, and analytics. • Proactively monitor system health, identify data issues, and maintain system documentation for our internal business systems. • Manage user accounts, roles, security settings, and reports. • Support new feature rollouts, training, and adoption. • Maintain a strong understanding of data models, object relationships, SQL and formula logic. • Research and recommend new tools, apps, or solutions that improve system performance or user experience. • Support data integrity and quality by troubleshooting issues and validating results • Help maintain documentation related to system workflows, data sources, and reporting logic • Participate in testing and support for upgrades or enhancements to business systems • Assist with user training and respond to support requests related to reporting and system usage • Act as a liaison between internal and external customers and vendors What You'll Bring to the Role • Bachelor’s degree in Information Systems, Information Technology, Computer Science, Data Analytics, or related field • Professional or internship experience in a data analytics, BI, or systems analyst role • Passionate about or motivated by data, data flows, databases, data warehousing, data relationships, integrations, programming, scripting, workflows, learning and using new formulas • Strong grasp of relational databases, formulas, object relationships, and basic scripting. • Mid-level to advanced Microsoft Excel skills. • Basic proficiency with SQL and understanding of relational databases • Strong analytical thinking and problem-solving skills • Good verbal and written communication skills • Experience with Microsoft Server 2019+ • Proficiency in Microsoft Office Suite specifically Microsoft Excel • Ability to obtain and maintain industry certifications. • Understanding of data governance and privacy best practices • Creating processes to improve efficiency and output. Preferred Qualifications • Exposure to data modeling or data warehouse concepts • Familiarity with Microsoft SQL Server 2019+, MySQL, NoSQL • Azure Data Factory, Data Lake, Synapse, and Azure AI • Advanced SQL skills. • CompTIA A+ certification or equivalent experience • Power BI or other analytical tools experience • Microsoft Visio for data and architecture modeling • Designing interfaces with HTML and CSS • Knowledge of programming and/or scripting (Python, Apex, C#, PHP, or JavaScript), Power Automate, REST APIs, webhooks, integrations, and automation • Experience working with ERP or CRM systems About VAF Van Ausdall & Farrar is Indiana's leader in business office technology services since 1914. We provide Cloud Solutions, Cybersecurity, IT Managed Services, Copy & Print Solutions, Internet/ISP Services, Phones, Video Surveillance, Document Conversion, and much more. We are a privately-owned, Indianapolis based business whose mission is to provide value-driven technology solutions to meet the individual needs of our customers, while providing world-class customer service & making a positive impact on our community. At Van Ausdall & Farrar Inc, we are committed to fostering an inclusive and welcoming environment. We are an equal opportunity employer (EOE) and evaluate qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, or any other protected status. We encourage individuals of all backgrounds to apply, and we actively seek to promote a workplace where everyone feels valued, respected, and empowered to contribute their best. Please contact us to request reasonable accommodation to participate in the job application or interview process. Ready to take your career to the next level? Apply today and join a team that’s redefining technology solutions for the modern workplace.

Requirements