Title: Senior Analyst
Location: American Flood Research, Inc.
1820 Preston Park Boulevard, Suite 1100, Plano, Texas 75093
Create and maintain SQL programs in SQL Server database including but not limited to T-SQL, SSRS, SSIS, complex scripting (Queries, Views, Stored Procedures), Windows OS scripts, etc. Create new reports and modify existing ones by using SSRS or SQL. Do data analysis to support business decisions. Database maintenance including SQL jobs, SSIS, database restores, and database performance. Review, analyze and modify programming systems including encoding, debugging, testing, and installing to support application systems. Consult with users to identify current operating procedures and to clarify program objectives. Rely on extensive experience and judgement to plan and accomplish goals. Performs a variety of tasks: work with the data files sent by clients in a timely manner and merge the information into our system; review the data files from new or prospective clients an give feedback on them accordingly; write scripts/packages needed for maintenance of database; run reports both for in-house use and for clients; review any issues brought up by the clients and determine if this is a bug or an enhancement that is needed to be done on the existing systems; work with the customer service group to help them with any issues they face. A wide degree of creativity and latitude is expected. Typically reports to a manager or head of a unit/department.
- Bachelor’s degree in CS, Mechanical Engineering or a related field (or equivalent).
- 2 year of experience as an analyst in a comparable role working with SSIS.
- 2 year of experience as an analyst in a comparable role working with SSRS.
- 2 year of experience as an analyst in a comparable role working with MSSQL.
Send resume to: 1820 Preston Park Boulevard, Suite 1100, Plano Texas 75093. Fax: 800-995-8669. No Phone Calls.