SQL Analyst
Staffing Manager:
Shelby Moroney
Job Title/# Position(s) Open:
SQL Analyst – (1 position)
Job Location (Include Zip Code):
Department of Veterans Affairs, FSC
Contract:
Yes
Requesting Agency:
Department of Veterans Affairs
Shift Schedule/Hours Per Week:
ONSITE: Monday – Friday Shift: Day Shift 40Hrs
Pre-Employment Checks:
Yes
Degree/Education Required:
Required:
- A Bachelors Degree in Degree in engineering, or a related scientific or technical discipline is required.
- 5-10 years of work experience
- 2 years of additional work experience can be substituted for 1 year of college
Start Date:
ASAP
Interview Process:
Pre-screening interview by Tucker Rose Associate, Interview by Prime Contractor, and interview by Government Manager.
DUTIES:
REQUIRED
DESIRED
ABOUT US
Tucker-Rose Associates, LLC. Is a Service-Disabled Veteran owned small business providing expert and efficient IT Professional Services to the Federal Government, State and Local Government agencies, as well as the Private Sector.
Shelby Moroney
Job Title/# Position(s) Open:
SQL Analyst – (1 position)
Job Location (Include Zip Code):
Department of Veterans Affairs, FSC
Contract:
Yes
Requesting Agency:
Department of Veterans Affairs
Shift Schedule/Hours Per Week:
ONSITE: Monday – Friday Shift: Day Shift 40Hrs
Pre-Employment Checks:
Yes
Degree/Education Required:
Required:
- A Bachelors Degree in Degree in engineering, or a related scientific or technical discipline is required.
- 5-10 years of work experience
- 2 years of additional work experience can be substituted for 1 year of college
Start Date:
ASAP
Interview Process:
Pre-screening interview by Tucker Rose Associate, Interview by Prime Contractor, and interview by Government Manager.
DUTIES:
- Assist accountants in extracting data (writing SELECT statements) from tables and views in Oracle DBMS
- Train accountants in very basic SQL – No JOINS, CASE Statements, CTEs – to extract data themselves
- Serve as front-line support when accountants have questions regarding accounting data in Oracle DBMS
- Define requirements for database objects (tables, views primarily) to support new requirements
- Develop and run tests at least weekly to quality-check data in all tables and views
- Populate and refresh data in Oracle DBMS monthly and on ad hoc basis as necessary
- Document processes used to populate and refresh data in Oracle DBMS
REQUIRED
- BA or BS from an accredited college or university
- Demonstrated communications skills (oral and written)
- Knowledge of accounting
- Knowledge of financial system operations
- 3+ years’ experience writing SQL
- Experience creating SQL queries to retrieve data from different tables in various databases into different reports
DESIRED
- CGFM or related certification
- Expertise in budget accounting
- Federal government experience
- Oracle SQL Developer experience
- Familiarity with T-SQL and database development tasks
- Worked thoroughly within Microsoft-BI development tools such as SQL Server integration (SSIS), Reporting (SSRS)
ABOUT US
Tucker-Rose Associates, LLC. Is a Service-Disabled Veteran owned small business providing expert and efficient IT Professional Services to the Federal Government, State and Local Government agencies, as well as the Private Sector.