Senior Application Developer/Data Analyst

State of Ohio • Columbus, OH

3d • Onsite

About The Position

Ohio's CollegeAdvantage program provides families across the nation flexible options and educational resources to invest in our trusted tax-advantaged 529 plans for education expenses after high school. We are seeking a highly skilled Senior Application Developer/Database Analyst to design, develop, and maintain enterprise-level applications and database solutions that support critical business operations. This role combines advanced programming, database management, and business analysis expertise to deliver secure, efficient, and scalable systems.

Requirements

• Completion of undergraduate core program in computer science or information systems; 24 mos. combined work experience in any combination of the following: assuring requirements are defined and approved, performing code reviews and ensuring application development standards are met including 12 mos. work experience in the primary technology as specified by the agency position description and job posting.
• Or completion of associate core program in computer science or information systems; 36 mos. combines work experience in any combination of the following: assuring requirements are defined and approved, performing code reviews and ensuring application development standards are met including 12 mos. work experience in the primary technology as specified by the agency position description and posting.
• Or 42 mos. combined work experience in any combination of the following: assuring requirements are defined and approved, performing code reviews and ensuring application development standards are met including 12 mos. work experience in the primary technology as specified by the agency position description & job posting.
• Or equivalent of minimum class qualifications for employment noted above.
• All applicants must be authorized and able to in our Columbus, Ohio office.
• OTTA is unable to sponsor or take over sponsorship of an employment Visa.

Nice To Haves

• Experience with Salesforce Sales Cloud, Salesforce Marketing Cloud, Sitefinity, Tableau.
• Knowledge of SSRS, SSIS, ETL processes.
• Familiarity with SFTP and secure data transmission.
• Exposure to application security practices and risk assessment methodologies.
• Proficiency in VB.NET, C#, SQL, and MS SQL Server.
• Strong understanding of relational databases and data integrity principles.

Responsibilities

• Design, develop, and maintain web and in-house applications using VB.NET, C#, SQL.
• Implement solutions leveraging Salesforce Sales Cloud, Salesforce Marketing Cloud, Sitefinity, Tableau, and SFTP.
• Develop and optimize SQL Server stored procedures, queries, and database interfaces.
• Administer relational databases and data warehouses; implement SSRS, SSIS, and ETL processes.
• Perform testing (unit, integration, system), debugging, and documentation.
• Ensure application and database security; conduct risk assessments and penetration tests.
• Provide end-user support and troubleshoot issues.
• Assist with file transmission feeds, hardware/software evaluations, and occasional operational duties.

Benefits

• Medical Coverage
• Free Dental, Vision and Basic Life Insurance premiums after completion of eligibility period
• Paid time off, including vacation, personal, sick leave and 11 paid holidays per year
• Childbirth, Adoption, and Foster Care leave
• Education and Development Opportunities (Employee Development Funds, Public Service Loan Forgiveness, and more)
• Public Retirement Systems ( such as OPERS, STRS, SERS, and HPRS ) & Optional Deferred Compensation ( Ohio Deferred Compensation )

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: Associate degree