• Develop multi-dimension data models to support BI solutions developed as well as other common industry data from external systems.
• Expert in DB modeling patterns – understands snowflake, starschema as well as OLTP concepts.
• Translate the logical data model into a physical data model.
• Manage data validation and data cleansing operations.
• Design and develop scripts in ETL environment to support the movement of data from multiple data sources to the data mart.
• Develop business measures and metrics, per specifications, within the platform.
• Design solution with a focus on optimum tradeoff between performance, scalability and functionality.
• Provide product managers and customers advice on appropriate tradeoffs between data completeness, performance or calculation CPU-intensity.