As an engineer, the incumbent would be responsible for evaluating, developing, maintaining and testing database solutions for various analytics projects
Be responsible for building data warehouses, data marts & OLAP solutions preferably using SSAS
Organize and manage data architecture documentation
Define standards for data management, and train staff on principles of data architecture
Improve the maturity of data architecture and data governance across the enterprise
Plan data management scenarios to support the needs of the development, QA and production environments.
Create best practices for data loading and extraction (ETL framework).
Develop data architecture, data modeling, and ETL mapping solutions and data warehouse consistency.
Would have a strong focus on collecting, parsing, managing, analyzing and visualizing large sets of data to turn information into insights using multiple platforms
Qualification & Experience
Strong competency in data modeling and data design. This includes logical and physical modeling, partitioning strategies for large tables, and other database optimizations
Solid experience with Relational Databases, specifically SQL Server and Sybase, Data Warehousing, OLAP, and Business Intelligence Reporting. Must be able to write PL/SQL Stored Procedures
Solid understanding of pros and cons for different data warehouse methodologies and architectures (Kimball/Inmon/Data Lake/Hybrid)
Experience designing Star, Snowflake Schemas, Dimensional Data Modeling, SCD (Slowly Changing Dimensions), and CDC (Change Data Capture) preferably using SSIS
Exposure to emerging data technologies such as NoSQL; must understand them sufficiently to guide the organization in understanding and adopting them
Experience working with cloud platforms such as Amazon Web Services or Google Cloud Platform
Good communication skills