Job Description

Top 3 skills: • Analyze and provide database schema and data flow design for OLTP and OLAP data model • Work with application owner, analyst and developers and oversee end to end solution implementation • Strong experience ER data modeling tools and with SQL (design and profiling) RESPONSIBILITIES • Gather business requirement and translate into logical and physical data model design • Reverse engineer current applications design and provide enhanced model and data flow architecture • Design application relational model (OLTP), Star schema model (OLAP) and ETL documentation (STM) • Work with application owner, analyst and developers and oversee end to end solution implementation • Data profiling current RDBMS application and related system to assure model and data quality • Work in a prototyping and development environment, test your solution with developers and produce database DDL for production • Optimize design to prevent application bottlenecks and implement data archiving strategy • Provide estimate, work breakdown structure (WBS) and progress status • Conduct and create scenarios for functional and integration unit testing in different environment • Post deployment application support, fix and enhancement to data model REQUIREMENTS • Strong experience with SQL language • Strong experience with ER data modeling tool (ex: Erwin, Oracle Data Modeler, etc.) • Experience with SQL server • Experience with Git and Team Foundation • Experience with Word, Excel and PowerPoint • Experience in both data warehouse and OLTP databases architecture • Communication skills and team collaboration • At least 5 years of experience in data modeling • Bachelor degree in computer science, engineering, or equivalent related project experience. Other beneficial skills: • Programming knowledge on ASP, VB.NET, C# and JAVA