The Senior SQL Programmer will develop, document, analyze and complete testing; and debug and support Yardi standardized and/or customized reports according to operations and departmental needs.
Innovate, design, develop, test, and debug Yardi reports and applications using Yardi SQL scripting, Yardi YSR, Microsoft SSRS/SSIS, and T/SQL
Support the Yardi Investment Management module and Yardi International platforms by writing custom reports and troubleshooting the Yardi application.
Work with Yardi and the USAA Real Estate Investor Reporting team on configuring and standing-up InvestorPlus.
Integrate 3rd party data sources into the Yardi database.
Develop and support NCREIF reporting out of Yardi.
Analyze Yardi data issues related to financial transactions and write data fixes.
Additional responsibilities, as assigned.
At USAA Real Estate our employees enjoy generous benefits packages including comprehensive medical, dental and vision plans, 401k, USAA Membership eligibility, educational and professional designation assistance, business casual dress attire and much more! Qualified applicants must successfully complete a pre-employment background and drug screen. The above description reflects the details considered necessary to describe the principal functions of the job and should not be construed as a detailed description of all the work requirements that may be performed in the job.
USAA Real Estate is an Equal Opportunity and Affirmative Action Employer of Females, Minorities, Veterans and Disabled.
Bachelor s degree in Business Information Systems, Management Information Systems, or relevant degree field.
5+ years recent experience with the Yardi platform and SQL programming, preferably within the accounting or finance industries.
Experience working on accounting/finance database schema.
Experience working with Excel and macros.
Knowledge of Transact-SQL (T-SQL), stored procedures, functions and views
Experience with SSIS and SSRS.
Skilled at optimizing large complicated SQL statements.
Knowledge of best practices when dealing with relational databases.
Experience in table design, including normalization.
Familiarity with Extract, Transform, and Load (ETL) processes.
Qualifications may warrant placement in a different job level.
Must be able to work in the United States without current or future employer sponsorship.
DATA SCIENCE TECHNOLOGIES LLC is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. DATA SCIENCE TECHNOLOGIES LLC will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will DATA SCIENCE TECHNOLOGIES LLC require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract