Software EngineerH & R Block
Across multiple technology platforms create, implement, manage, and optimize a comprehensive multi-channel marketing database. Configure database for email, direct physical mail, loyalty programs, and marketing activities. Utilize SAS Enterprise Guide (EG) software for reporting and analytical tasks. Use query builder to run queries against the tables and sub setting the data. Extract, transform, and load data using SAS. Extract financial data from the database using SAS PROC SQL and create SAS permanent data sets in SAS library. Use SAS system macros for error handling, code validation, date stamping of log files, collected files to a given directory. Write SQL, PL/SQL, Stored Procedures on SSMS to build database-centric business components. Develop core Class Library. Perform examination of source code review and ensure source code is in standard, deployment code for QA to perform system and integration testing. Document and implement the final source code in production environments. Resolve production support issues and work on bug fixes by writing new source code. Work with offshore team daily and communicate the changes implemented at onsite and participate in daily call to track all changes and coordinate with external vendors. Be available for on-call production support 24x7 on a weekly rotating schedule.
Bachelor’s degree or the equivalent in Computer Science, Information Technology, or related field.
3 years of experience to include:
- SAS EG, Reporting, SAS PROC SQL, SAS Library
- Development & QA environments support
- SSMS, Visual Studio data tools, Oracle
- SQL queries for Ad-hoc reports, PL/SQL
- Agile Scrum Methodology, Visual SourceSafe, Kanban
- .Net 3.5 Framework, ADO.NET, jQuery, Ajax
- T-SQL to create tables, views, cursors/ triggers, and stored procedures
- SAS Programming, C# coding, SSIS/ETL
- Maintenance and scheduling jobs using adTempus
- Requirement gathering and documenting
In lieu of a Bachelor's plus 3 years of experience, a Master's plus 1 year of experience in the requirements listed above is acceptable.
Position is in Kansas City, Missouri but will also consider remote workers in the United States. Must be available for on-call production support.
Domestic travel 5% of the time to headquarters.
For complete details and to apply, please go to: http://www.hrblock.com/careers and reference corporate job # 337703BR.