Associate Data Modeler-Tech Ops

As a Data Modeler at PwC, you will play a vital role in analyzing business needs, developing long-term data models, and ensuring the efficiency and consistency of data systems. Your expertise in data modeling, metadata management, and data system optimization will be crucial in this role. Key Responsibilities: - Analyze and translate business needs into long-term solution data models. - Evaluate existing data systems and recommend improvements. - Define rules to translate and transform data across data models. - Work with the development team to create conceptual data models and data flows. - Develop best practices for data coding to ensure consistency within the system. - Review modifications of existing systems for cross-compatibility. - Implement data strategies and develop physical data models. - Update and optimize local and metadata models. - Utilize canonical data modeling techniques to enhance data system efficiency. - Evaluate implemented data systems for variances, discrepancies, and efficiency. - Troubleshoot and optimize data systems to ensure optimal performance. - Demonstrate strong expertise in relational and dimensional modeling (OLTP, OLAP). - Utilize data modeling tools such as Erwin, ER/Studio, Visio, PowerDesigner. - Proficient in SQL and database management systems (Oracle, SQL Server, MySQL, PostgreSQL). - Knowledge of NoSQL databases (MongoDB, Cassandra) and their data structures. - Experience working with data warehouses and BI tools (Snowflake, Redshift, BigQuery, Tableau, Power BI). - Familiarity with ETL processes, data integration, and data governance frameworks. - Demonstrate strong analytical, problem-solving, and communication skills. Qualifications: - Bachelor's degree in Engineering or a related field. - 3 to 5 years of experience in data modeling or a related field. - 4+ years of hands-on experience with dimensional and relational data modeling. - Expert knowledge of metadata management and related tools. - Proficiency with data modeling tools such as Erwin, Power Designer, or Lucid. - Knowledge of transactional databases and data warehouses. Preferred Skills: - Experience in cloud-based data solutions (AWS, Azure, GCP). - Knowledge of big data technologies (Hadoop, Spark, Kafka). - Understanding of graph databases and real-time data processing. - Certifications in data management, modeling, or cloud data engineering. - Excellent communication and presentation skills. - Strong interpersonal skills to collaborate effectively with various teams.,