Development Consultant (Heavy SQL/Vista)

Business Information Group; Northern (KY); Hybrid; USD 90,000 - 130,000; Full time

Job summary

Business Information Group, Inc. is seeking a Development Consultant to design, code, test, and maintain software applications and database solutions for varied clients. This role emphasizes heavy SQL, database design, and data integration across platforms.

You will work in a collaborative team, gather requirements, produce specifications, and deliver scalable, secure solutions while keeping up with industry best practices in a fast-paced remote environment.

Qualifications

• Bachelor’s degree in Computer Science or related field required.
• 3–5 years of SQL development with stored procedures and ad-hoc queries.
• Experience with SQL Server, T-SQL, and cloud familiarity (AWS/Azure) preferred.

Responsibilities

• Gather requirements and prepare detailed specifications for solutions.
• Design, code, test, debug, and maintain SQL and application components.
• Collaborate with cross-functional teams to deliver scalable, reliable systems.
• Document architecture, code, and changes; provide support and troubleshooting.

Skills

SQL Development

SDLC & Agile

Backend development

Frontend basics

Communication

Problem Solving

Education

Bachelor’s degree in Computer Science or related field

3-5 years SQL development experience

Tools

Microsoft SQL Server

T-SQL

Azure DevOps

Git

Crystal Reports

SSRS/SSAS/SSIS

Vista by Trimble

Job description

All Jobs > Development Consultant (Heavy SQL/Vista)

Development Consultant (Heavy SQL/Vista)
Fully Remote Remote Worker - N/A

ABOUT BUSINESS INFORMATION GROUP, INC (“big”)

When technology changes every day, it’s important to have an IT partner that delivers safe, reliable, and understandable solutions. For the past 30 years, BIG has helped hundreds of companies upgrade their technology to improve productivity, minimize downtime, and increase collaboration.

Our mission? To be an extension of our client’s business as their most trusted advisor, offering reliable technologies that provide comprehensive solutions for the built environment.

Job Summary

The Development Consultant is responsible for designing, developing, and maintaining software applications and database systems that meet the needs of the organization or clients. This role will formulate and design system scope and objectives, development requirements, and deliver data/database solutions. This role involves coding, testing, debugging, and ensuring the functionality and performance of applications and databases across various platforms. The developer will work within a collaborative team environment to create efficient, scalable, and user-friendly solutions. Additionally, the position includes supporting the maintenance of existing applications and databases, integrating new technologies, and adhering to industry best practices to improve application and database performance and user experience. This position requires the ability to work in a fast-paced, ever-changing environment.

Essential Duties and Responsibilities

• Gather requirements and prepare detailed specifications from which solutions will be developed.
• Design, code, test, and debug and database/SQL solutions in a variety of database systems.
• Work consistently at the highest technical level on all phases of a project.
• Communicate on projects interdepartmentally to confirm the business process
• Interact directly with clients of all knowledge levels, and at any level of their organization.
• Design, develop, and maintain software applications based on client requirements and business needs.
• Develop front-end and back-end solutions for web, mobile, or Windows desktop applications.
• Work closely with cross-functional teams including project managers, consultants, and other developers to ensure successful project delivery.
• Participate in regular meetings to gather requirements, discuss progress, and identify challenges.
• Provide technical guidance and support to junior developers when needed.
• Conduct thorough testing of applications and databases to ensure high performance, security, and reliability.
• Troubleshoot and resolve any bugs or issues that arise in the development process.
• Implement unit tests and participate in code reviews.
• Stay updated on industry best practices, emerging technologies, and programming languages to ensure that applications meet modern standards.
• Recommend and implement improvements in the development process, architecture, and tools used.
• Document application and database architecture, code, and any changes made during the development lifecycle.
• Create user manuals and other documentation to assist clients and end-users.
• Provide ongoing maintenance, support, and updates for existing applications and databases.
• Ensure applications and databases remain compatible with updated platforms and operating systems.

Position Details, Work Environment & Physical Requirements

• Standard office hours for this role are Monday – Friday, 8:00am – 5:00pm local time zone.
• This is a full-time, exempt role.
• This is a remote role with eligibility to work from approved states in the United States.
• Ability to sit for extended periods and use a computer and keyboard for long durations. Frequent typing and use of a mouse, with fine motor skills required for accurate data entry and navigation. Must be able to maintain good posture and adjust seating and workstation to minimize physical strain.

Education, Qualifications & Experience

• Bachelor’s degree in Computer Science, Information Technology, or a related field or a minimum of three (3) years of database/SQL development or an equivalent combination of education and experience are required.
• Minimum of three to five (3-5) years of experience in developing data-driven solutions utilizing SQL, including stored procedures, triggers, vies, and ad-hoc queries.
• Intermediate Microsoft SQL Server and Microsoft T-SQL knowledge required.
• Experience with Microsoft SQL Server
• Familiarity with cloud platform services (AWS, Azure, etc.).
• Experience with SAP Crystal Reports, SSRS, SSAS, SSIS and Microsoft BI Services is preferred.
• Experience in the Architectural, Engineering and Construction field, Finance preferred or with integrated ERP systems (Vista by Trimble, Microsoft Dynamics, Sage 300, JD Edwards) preferred
• Proven experience as an Application or Database Developer or similar role, with a portfolio of developed solutions.
• Strong understanding of software development life cycle (SDLC), agile methodologies, and version control systems (e.g., Azure DevOps, Git).
• Some familiarity with front-end frameworks (React, Angular, or Vue.js) and back-end technologies (Node.js, .NET, etc.)
• Knowledge of mobile development (iOS/Android) is a plus.
• Excellent problem-solving, debugging, and troubleshooting skills.
• Strong communication skills and the ability to work well in a team-oriented environment.
• Current state issued driver’s license, clean driving record, reliable transportation, and proof of valid auto insurance

Helpful to Have

• Knowledge of Oracle PL/SQL, MySQL, PostgreSQL, MongoDB, or IBM DB2
• Integration experience using SQL Server Integration Services
• Crystal Reports Development
• SSH/PowerShell Scripting Experience

Equal Opportunity Employer

It is the policy of Business Information Group, Inc. to provide equal employment opportunity (EEO) to all persons regardless of age, color, national origin, citizenship status, physical or mental disability, race, religion, creed, gender, sex, sexual orientation, gender identity and/or expression, genetic information, marital status, status with regard to public assistance, veteran status, or any other characteristic protected by federal, state or local law. All employees are subject to a pre-employment screening process including a background check and drug screen. In addition, we will provide reasonable accommodations for qualified individuals with disabilities. If you require reasonable accommodation in completing the application, interviewing, completing any pre-employment testing, or otherwise participating in the employee selection process, please direct your inquiries to the Human Resources department.