Software Engineer (Kansas City, MO)
Software Engineer (Kansas City, MO)
JOB SUMMARY
Assist in design, development and maintenance of software components and products that support H&R Block business applications. Work closely with the QA, UX and other related teams to ensure consistent understanding of software requirements and approach. Design and develop database object using Azure PaaS SQL Server. Design, develop, schedule & monitor Azure Data Factory pipelines. Perform unit testing on all deliverables. Develop Ad hoc SQL queries for Fraud, Legal, and other relevant stakeholders requests. Participate in technical design and code reviews for all new enhancements and maintenance work delivered. Design, develop, and manage API proxies and policies using Google Apigee. Create, build and release pipelines in Azure DevOps. Deployment using Azure DevOps. Provide troubleshooting and support of production environment. Perform year-end database tuning, performance, and maintenance activities. Provide on-call responsibilities to ensure high availability of production environment, databases, and tables.
QUALIFICATIONS
Bachelor's degree in Computer Science, Computer Information Systems, Information Technology, or related field.
Four years of IT experience including:
• Business Intelligence;
• Data Warehousing;
• Database objects - design, development, and deployment;
• Create reports;
• Extract, Transform and Load (ETL);
• SQL Server Analysis Services (SSAS) Cube;
• Perform validations and create technical documentations;
• Unit test scripts;
• SQL Server, MySQL, Oracle, and Teradata;
• SQL Server Reporting Services (SSRS) and MicroStrategy; and
• SQL Server Integration Services (SSIS).