SQL/Vista Developer — Remote Data Solutions Expert

Business Information Group, Inc.; York (York County); On-site; USD 90,000 - 130,000; Full time

Job summary

Business Information Group, Inc. (BIG) is seeking a Development Consultant to design, develop, and maintain software applications and database systems. The role involves coding, testing, debugging, and delivering scalable data solutions across platforms.

You will collaborate with project managers, consultants, and other developers in a fast-paced environment. Requirements include a bachelor’s degree or 3–5 years of SQL development, strong SQL Server/T-SQL, and familiarity with cloud services

Qualifications

• Bachelor’s degree in Computer Science, IT, or a related field.
• 3-5 years of experience in developing data-driven solutions utilizing SQL, including stored procedures, triggers, views, and ad-hoc queries.
• Intermediate Microsoft SQL Server and T-SQL knowledge.
• 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 (e.g., 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.
• Proficiency in multiple programming languages (e.g., Java, C#, Python, Swift, JavaScript).
• Strong understanding of 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.

Responsibilities

• Gather requirements and prepare detailed specifications from which solutions will be developed.
• Design, code, test, and debug 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.
• Write clean, scalable, and efficient code using a variety of programming languages such as T-SQL, Java, Python, C#, JavaScript, or Swift.
• 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.

Skills

SQL

Java

C#

Python

JavaScript

SDLC

Agile

Git

Azure DevOps

Communication

Problem solving

Education

Bachelor’s degree in Computer Science or related field

3-5 years of SQL development experience

Cloud experience (AWS, Azure)

Tools

SQL Server

Crystal Reports

Power BI

Oracle PL/SQL

Job description

Business Information Group, Inc. (BIG) is seeking a Development Consultant to design, develop, and maintain software applications and database systems. The role involves coding, testing, debugging, and delivering scalable data solutions across platforms.

You will collaborate with project managers, consultants, and other developers in a fast-paced environment. Requirements include a bachelor’s degree or 3–5 years of SQL development, strong SQL Server/T-SQL, and familiarity with cloud services