Database Developer

Database Developer MAHIN-JOB-32480

Role : Database Developer

Locations : Colorado Springs, CO; Lenexa, KS; Lubbock, TX; Purchase, NY; Topeka, KS (Day 1 onsite from any of the location)

ROLE RESPONSIBILITIES

• Collaborate with the business teams to understand their current state and future state workflows and business / validation rules, existing MS Excel solution, data integration with external systems, and data warehouse reports to be designed and implemented.
• Collaborate with various technical teams, and subject matter experts, to design and implement the future state data warehouse solution.
• Collaborate with various technical teams and business units to ensure optimal performance of the data warehouse pipelines, calculations, and reports.
• Work closely with the technical teams of the frontend applications to understand their data models and to build routines to extract, transform, and load data into the data warehouse.
• Work closely with the business units to implement calculation routines.
• Build validation and balancing routines to ensure that valid data is loaded to the data warehouse and that the data is accurately extracted and loaded.
• Create test cases to validate that the warehouse data is being accurately extracted, validated, stored, and reported.
• Create test cases to certify that the calculation routines are accurate.
• Create test cases to measure and report on the performance of the data warehouse. Implement performance improvements, as necessary.
• Collaborate with the Quality Assurance Team to create test cases and scripts for certifying the performance of the data warehouse and accuracy of the calculation routines, and that warehouse data is being accurately extracted, validated, stored, and reported.
• Work with analytics and business teams on improving data models that feed business intelligence tools, increasing data accessibility, and fostering data-driven decision making across the organization.

TECHNICAL QUALIFICATIONS

GENERAL QUALIFICATIONS

Education : -