Job Description

Applications must be filed at

https://capps.taleo.net/careersection/ex/jobdetail.ftl?job=00041241

About the Comptroller's Office

Innovation, collaboration, and a commitment to excellence best describes the culture here at the Comptroller's Office. We take pride in the work we do serving as Texas' accountant, tax collector, treasurer, and much more!

Culture

Our agency workforce is as diverse as the people of Texas we serve. We value our employees and take very seriously our collective commitment to public service. Personal development opportunities are strongly encouraged through available workshops, teambuilding exercises, and on the job training. We offer flexible scheduling that helps employees maintain a healthy work-life balance. If you are seeking to gain knowledge, build your career, and network among goal-oriented professionals, this is the place for you!

Click here to see an inside look at the Texas Comptroller's office! Click here to see a video from the Texas Treasury Safekeeping Trust Company!

General description

Join the Texas Treasury Safekeeping Trust Company as a Developer! Work involves performing highly advanced and/or supervisory (senior-level) computer programming work. Work involves overseeing programming projects; analyzing proposed applications; and designing software solutions. May supervise the work of others. Works under minimal supervision, with extensive latitude for the use of initiative and independent judgment.

Minimum Qualifications

• Graduation from an accredited four-year college or university with a bachelor's degree in data processing, computer science, business, or a related field, required.
• Six years of full-time experience in a combination of the following:
• MS Visual Studio, NET and .NET Framework
• C#
• ASP.NET
• HTML
• JavaScript
• XML
• Web Services
• AJAX
• MS Team Foundation Server or other relevant source control systems
• VB Script
• VB.Net
• Six years of full-time experience performing MS SQL development for the following:
• Stored procedures
• SSIS Packages
• SSRS Reports
• Three years of experience with Microsoft MVC, JSON, jQuery, Restful Services, Angular JS, and NodeJS
• Three years of experience working in an AWS or Microsoft Azure environment.
• Experience operating within and supporting multiple environments, including production.
• Five years of experience developing within an investment environment.
• Five years of experience in development with advanced T-SQL queries and objects which include:
• Common Table Expressions (CTEs)
• Indexes
• Triggers
• User Defined Functions (UDFs)
• Experience with investment accounting systems, bank wire systems, financial web portal applications, and investment tracking systems

Preferred Qualifications

• RSA Token application integration
• Experience with LDAP queries
• Experience working with integrated systems in a hybrid environment.

Substitution:

• One additional year of full-time minimum experience as stated above may substitute for each year (30 semester hours) of the required education with a maximum substitution of 120 semester hours (four years).

In this role you will:

• Assists with developing requirements and programming of applications, interfaces, data imports/extracts and reports utilizing a development full stack for both on premise and hosted solutions. Development efforts will be heavily focused on tools, interfaces and applications to support investment portfolio management, risk management and investment analytics.
• Assists Business Analysts with the support of daily operations for a suite of financial applications which includes issues resolution and operational requests to resolve daily workflow issues such as bugs and enhancements utilizing scripts, SSIS, SSRS, JSON, ASP.Net, C#, Python, JavaScript, Angular JS and Visual Studio in the analytics of investment performance data.
• Performs research and presents options for the enhancement of tools, processes and methods utilized on the development team to support improvements in investment analytics.
• Assist with other IT and staff technical requests as needed.

Qualifications:

Have Knowledge of:

• The principles, practices, and techniques of computer programming and systems analysis.
• Computer operations procedures and systems.
• Computer programming languages:
• C#
• ASP.NET
• T-SQL
• HTML
• Javascript
• Angular JS
• Microsoft MVC
• XML
• JSON
• Rest Services
• Computer programming languages: MS SQL Server developer (including stored procedures and SSIS packages).
• Computer programming languages: LDAP queries.
• MS Visual Studio.NET and .NET Framework/Core, ASP, MS SQL Server Reporting Services Reports, MS SQL Server Integration Services, Team Foundation Server, AJAX, Web Services, MS IIS, MS Visio, VB Script, and VB.
• RSA Token application integration including modification of RSA Client Templates.
• Investment accounting systems, bank wire systems, financial web portal applications or investment performance systems.

Skill in:

• Modifying programs for computer applications.
• Various software architectures (n-tier, mvc, microservices, cloud, soa).
• SQL Server management.
• Effectively conveying information and encouraging an exchange of ideas.
• Identifying, defining, and solving problems.

Ability to:

• Maintain confidentiality and protect the privacy of state employees, taxpayers, and other members of the public.
• Follow all agency confidentiality, privacy, and information security policies and procedures.
• Appropriately store, secure, and protect sensitive records and other confidential documents and data in accordance with the agency's certified Records Retention Schedule.
• Seek guidance and clarification from relevant agency specialists when potential confidential issues arise.
• Use discretion and appropriate judgement in communicating confidential and sensitive information.
• Work with others to achieve a common goal.
• Adjust to changing workplace demands.
• Meet the needs and expectations of internal and external customers.
• Effectively demonstrate skill and ability to perform the specific job duties and tasks as defined by a job description.
• Be dependable, meet deadlines and produce high-quality work.

Veterans:

To receive veteran's preference a copy of your DD214 (Member 4) is required.

Veterans, Reservist or Guardsmen with an MOS or additional duties that fall within the essential duties of the job position or other related fields pertaining to the minimum experience requirements may meet the minimum qualifications. All active duty, reservists, guardsmen, and veterans are encouraged to apply if they meet the qualifications for this position. Please call Human Resources, CPA Veterans Liaison at 512-475-3560/800-531-5441 for more information or assistance.

If selected for the position the following must be provided for proof of veterans' preference:

• Veteran must provide form DD 214
• Surviving Spouse or Orphan must provide DD 1300 or DD 214.

Military Occupational Specialty (MOS) codes that may correspond to the state classification title for this position are listed on the State Auditor's Office Job Descriptions; click on the occupational category for the position. Additional MOS can be found at the State Auditor's Office Military Crosswalk Guide.

The Texas Veterans Commission provides helpful employment information. Go to: http://www.texasskillstowork.com, http://www.onetonline.org, https://hr.sao.texas.gov/CompensationSystem/JobDescriptions/ or www.careeronestop.org for assistance translating your military experience and training courses into civilian job terms, qualifications/requirements and skill sets.

Applications submitted through Work In Texas:

Work In Texas (WIT) applicants must complete the supplemental questions to be considered for the posting. To complete the supplemental questions please go to CAPPS Recruit to register or login and access your profile.

The Comptroller's Office is proud to be an equal opportunity workplace. We are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity.