Overseas Adventure Travel is seeking a qualified Jr. Software Developer in our Marketing Operations department with a focus on performing back-end development in our MS-SQL-based Marketing CMS.
Seeking a Developer to design and maintain reporting and production processes, and work with the Marketing Content teams to develop new solutions.

The Developer understands business problems and opportunities in the context of internal operations and recommends solutions that enable the organization to achieve its goals of streamlining with automation and efficiency. You will primarily develop views, stored procedures, and functions in SQL, but may also be asked to work in Powershell, Visual Studio, JavaScript and HTML to support varying business needs.

Responsibilities:

• Write SQL scripts, views and stored procedures to be used by ETL processes and reports.
• Adhere to development standards for coding.
• Assist business users by analyzing data, generating ad hoc reports and training/helping with existing self-service reports.
• Create front-end forms, SQL tables and relationships using our CMS application’s administrative tools to allow business users to maintain dataset.
• Write ad-hoc queries in MS SQL Server Management Studio to support business requests.
• Support troubleshooting/testing and research to determine root causes of issues including such areas as communication, process, training, system defects or other gaps.
• Evaluate and improve business systems and how they align with user needs.
• Analyze data using a variety of techniques. Work with a dedicated project team in scrum style operations and occasionally work with other teams and business leaders.
• Perform data mapping and data translations, as needed. Ensure data accuracy, system integrity, compatibility, and standardization.
• Provide internal system support for various departments, such as answering questions, fulfilling simple data requests, investigating and trouble-shooting system errors, escalating higher level issues and requests to IT team for resolution, analyzing support requests to identify root causes of issues, find trends and propose process and/or system improvements.

Requirements:

• 2+ years of relevant experience in SQL programming or Data Analysis/Analytics
• SQL experience required
• Strong and effective communication skills
• Experience with one or more of the following: Microsoft SQL Server, SSIS, SSRS and Azure DevOps.
• Knowledge of Powershell, Informatica, HTML and JavaScript is a plus.
• Strong verbal and written communication skills; ability to tailor communications based on audience and business objectives
• Comfortable working and communicating across operational areas and working in cross-functional teams
• Ability to analyze, interpret, and apply operations research rules and procedures in a variety of situations and recommend solutions to leadership
• BA or BS college diploma in Computer Information Systems or related field preferred
• Professional knowledge of basic principles, concepts, and practices of operations research analysis to apply development techniques to analyze and optimize systems, processes, operational problems, and procedures
• Prior experience on technology development and production support
• Demonstrated project management and timeline management skills
• Experience/proficiency in all MS Office 365 applications