Data Modeler, Waltham, MA (10+ Years)

Position: Senior Data Modeler Location: Hybrid – must be onsite in Waltham, MA 1-2 days a week soon Duration: 6+ months to HIRE, Required Skills: - 5+ years’ experience as a Data Modeler - SQL experience - Erwin/ ERStudio experience - Snowflake experience What will get the WIN: - not a need - AMI (Advanced metering infrastructure experience) Below is the Full job description Position Description: Our client is currently seeking an innovative, technically talented Senior Data Modeler who can drive and implement the data architecture for major initiatives within our Data Engineering team. The Senior Data Modeler role will own and define the enterprise data model key to our core data engineering and operations teams. The role will consist of performing a detailed analysis of data management requirements across all systems, platforms and applications. Responsibilities: • Create, validate, publish, and maintain conceptual, logical, and first cut physical data models for relational/ OLTP systems. • Data Modeler will be expected to leverage their knowledge of data modeling best practices along with cross industry data expertise and data modeling tool expertise. • She or he will be expected to work either individually or as part of a team to develop and/ or maintain the conceptual, logical, and first cut physical data models. • There may be instances where the modeler will be finalizing a physical deployment model but the primary responsibilities are for the conceptual, logical, and first cut physical data models. • Map data sources and targets for data movement and analyze it to ensure appropriate integrity and quality of all data. • Prepare documents for data architecture and maintain knowledge base for the data structure. • Need to identify the current paint points that need to be addressed as part of the new data architecture and provide solutions for the same. Required Skills: • Bachelor's degree in Computer Science, Big Data Administration, Systems Administration or in the related field • At least 10 years of relational/ OLTP data modeling experience including at least the creation and design of 3+ data models from conceptual/ logical to first cut physical which include standard data modeling patterns such as party, sub-type & supertype, complex relationships, and many to many resolution. • Experience with data modeling best practices in creating, updating, or revising new or existing models or reverse engineering data bases to create new physical models. • Experience with facilitating meetings with business and other representatives to gather requirements, interpret and explain data modeling representation options, understanding business needs and directions along with being able to explain/ guide technical teams with de-normalizing options. • Experience with delivery of at least two independent data models using at least one formal data modeling tools (such as, ErWIN or ERStudio). With a preference for multiple types and formats. • Understanding of different types of keys, business rules or relationships, representing differing history requirements, and different levels of abstraction, and normalization/ de-normalization. • Understanding of multiple representational techniques in a data model (such as variations on rendering recursive joins, hierarchies, supertype options, history, etc.). • Desired experience in both working individually or as part of a data team. • Desired experience in understanding different types of databases, data movement, and analytic engines. • Hands-on working experience with modern cloud data tools. (Preferably Azure). • Demonstrated ability to effectively work both independently and within cross functional project teams • Proven ability to prioritize and execute tasks • Understands business goals and strategic priorities • Promotes respect and can work effectively with diverse groups and environment • Highly developed oral and written communication skills; strong presentation skills Desired Skills (not required but candidate will have exposure to these skills in this role): • Background in utilities industry • Experience working with AMI Thanks & Regards Syam B, 630-923-6952 syam@thoughtwavesoft.com