1. Organized individual that demonstrates responsibility, good judgement, strong analytical skills, initiative, and resourcefulness, and is able to provide leadership for junior team members.
2. Independently able to architect or design ETL and templates that are used to collect and store the data from external sources so that data can be accessed by internal or external business and technology partners or users.
3. Perform code review, troubleshoot, develop, or modify custom database packages/SSIS packages.
4. Advanced T-SQL skills.
5. Provide design and structural recommendations for database application tuning and performance enhancements to development team.
6. Install, configure, support, and troubleshoot Microsoft SQL Server, or other relational database and its supporting Windows Server, Operating Systems (OS) and associated hardware.
7. Provide leadership in the overall database designs and setup in support of the client and industry standards.
8. Design, create, or modify database tables, indexes, constraints, links, stored procedures, and functions.
9. Provide direction and methodology for the data warehouse design, creation, and maintenance to include data schemas and associated ETL in conjunction with business needs.
10. Establish standards for data integrity in the client data warehouse through data reconciliation techniques, data analysis, or ETL design issues.