Software Developer

Smx Corporation Limited - Indianapolis, IN

Full-time

Indianapolis, IN

Administrative and Support Services

About the position

SMX is seeking a Software Developer to support the IMITSS program. The individual will be capable of working independently, able to act with a sense of urgency, and willing to contribute as an active member of the team. This role will be responsible for the development and maintenance of customer FlankSpeed data tools and applications, as well as the development of new tools and transitioning existing tools to the FlankSpeed environment. The position is remote but requires the ability to travel to client sites, preferably for candidates in the PST time zone. Additionally, this position requires a DoD secret security clearance, which necessitates US citizenship for work on DoD contracts. The Software Developer will engage in various essential duties and responsibilities, including the development and maintenance of data tools and applications, executing and creating SQL scripts, and maintaining existing tools using Microsoft Visual Basic For Applications (VBA) tools such as Excel and Access. The role also involves performing data operations as needed, executing and maintaining Informatica Workflows, and managing Extract, Transform, and Load (ETL) processes. The developer will draft technical documentation and participate in all aspects of software analysis, design, coding, testing, implementation, and documentation of financial Microsoft Office process tools. Problem analysis, solution identification, maintaining and debugging software tools, and testing are also key components of this position.

Responsibilities

• Development and maintenance of data tools and applications
• Developing new and transitioning existing tools to cloud/FlankSpeed environment
• Maintaining existing tools using Microsoft Visual Basic For Applications (VBA) tools (Excel and Access)
• Performing data operations as needed
• Executing and/or creating SQL scripts
• Executing and/or maintaining Informatica Workflows, and Extract, Transform and Loads (ETLs)/Mappings
• Drafting technical documentation
• Participating in all aspects of software analysis, design, code, test, implementation and documentation of financial Microsoft Office process tools
• Problem analysis, solution identification, maintaining (writing code), debugging, and testing of software tools

Requirements

• 3-6+ years previous related experience (Oracle, SQL Plus, Informatica, Microsoft Visual Basic for Applications (VBA) in Excel and Access, MS PowerApps, PowerBI, SharePoint)
• Working knowledge of databases (MS Access, Oracle 11g, SharePoint Lists)
• Working knowledge of automating processes in MS Office software (Excel and Access VBA, MS PowerApps, PowerBI)
• Working knowledge of administering SharePoint sites including user administration
• Ability to self-learn
• Flexibility, adaptability, and punctuality
• Good organizational and dependable time management skills
• Strong communications skills, verbal and written
• Teamwork and collaboration skills
• Ability to pay attention to detail, thoroughly and accurately
• Ability to follow instructions
• Good problem solving skills (analytical thinking)
• Ability to travel to the client site as needed

Nice-to-haves

• Experience working in the FlankSpeed environment
• Exposure to JIRA
• Exposure to SPORK