Senior Associate Data Modeler-Tech Ops

Data Modeler

Job Description:

Looking for candidates with a strong background in data modeling, metadata management, and data system optimization. You will be responsible for analyzing business needs, developing longterm data models, and ensuring the efficiency and consistency of our data systems.

Key areas of expertise include

• 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. 

• Strong expertise in relational and dimensional modeling (OLTP, OLAP).

• Experience with data modeling tools (Erwin, ER/Studio, Visio, PowerDesigner).

• Proficiency 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.

• Strong analytical, problem-solving, and communication skills.