Data Modeler

Job: Senior Data Modeler

Location : Merrimack, NH or Boston, MA (2 weeks onsite in a month)

Long Term Contract

Candidate Profile (Must Haves):
• Data modeling Experience
• Erwin or Power Designer
• Data mapping / data taxonomy
• SQL knowledge
• Snowflake
• Data Governance- rules and conditions of what data can be accessed.

Nice to Have: Collibra or Alation experience (These are highly preferred- Consider them as Must Haves only)

Need good soft skills- will be collaborating across many teams

Interview Process : 2 rounds over video zoom.

The Expertise and Skills You Bring:
• Bachelor’s or master’s degree in computer/data science technical or related experience
• 7+ years of experience hands-on relational, dimensional, and/or analytic experience. Python knowledge is a plus
• Strong SQL knowledge and work experience with databases such as Oracle, PostgreSQL, Snowflake, Teradata
• Hands-on modeling, design, configuration, installation, performance tuning, and sandbox POC
• Good knowledge of metadata management, data modeling, and related tools (Erwin or ER Studio or others) required.
• Demonstrated, hands-on data modeling, ER diagram` and enterprise software design experience for OLTP (relational) and analytical systems
• Good knowledge of data modeling principles and standard methodologies including a good understanding of semantic data modeling concepts and multi-Fact model
• Ability to define data modelling standards and guidelines as well help teams adopt complex large-scale & global data driven implementations
• Strong experience in data modelling activities supporting history handling time series data warehousing & data transformations
• Ability to quickly grasp technological, business concepts, key domain and entities
• Strong verbal and written communication skills; experience communicating with engineers, architects and product management to explain technical and functional concepts
• Ability to assess the accuracy completeness and consistency of data models as well as maintaining relevant documentation
• Experience with Alation, Collibra to drive data cataloging and data lineage
• Strong understanding of data governance processes and metadata repositories
• Experience of working with Data Governance team to identify and capturing business and technical metadata associated with various data entities
• Experience and desire to work within a fast-paced environment with short release cycles and an iterative development methodology.
• Able to work on multiple projects/products simultaneously and comfortable working with minimal specifications.
• Excellent communication and documentation skills.