Best Canditate
The successful candidate will be an integral part of the Enterprise Data Warehouse team, responsible for managing and optimizing data assets. This role entails applying technical standards, principles, and theories to solve a range of technical challenges with varying levels of complexity. The candidate will develop a deep understanding of the data warehouse and data management assets within our data platforms and serve as a subject matter expert on data and its practicality for operational use. Regular interaction with customers, data management colleagues, and product development partners will be required to enable data-driven decision-making.
Job Requirements:
- Bachelor's Degree in Computer Science, Information Systems, or a related field.
- 10 to 15 years of experience in Data Warehousing and Data Modeling.
- Strong grasp of Normalized/Dimensional modeling concepts and similar data warehousing methodologies.
- Extensive experience with ETL/ELT concepts for data integration, consolidation, enrichment, and aggregation in large volume datasets.
- Expertise in SQL and/or SQL-based languages, along with proficiency in SQL query performance tuning.
- Working knowledge of Data Pipelines, stream processing, and highly scalable 'big data' data stores.
- Familiarity with various data storage technologies, including RDBMS (Oracle, SQL Server, etc.), columnar, tabular, document store, and NoSQL databases.
- Experience with ETL/ETL tools such as ODI, SSIS, Informatica Power Center, Talend, IICS, etc.
- Exposure to cloud-based data warehouses like Snowflake, BigQuery, Azure Synapse, RedShift, etc.
- Ability to create comprehensive documentation, including metadata and entity relationship diagrams, as well as process flow and business process documentation.
- Collaboration with business users to normalize and aggregate large datasets based on business requirements.
- Proficiency in data validation to ensure data integrity, identify discrepancies, and resolve them promptly.
- Strong communication skills to convey findings effectively to both technical and non-technical stakeholders.
- Familiarity with Analytical/Reporting Solutions like Tableau, Power BI is a plus.
- Competence in virtual team collaboration tools such as WebEx, Zoom, etc.
- Excellent written, verbal communication, and interpersonal skills.
- Strong problem-solving abilities.