Data Modeler (SQL)
Apply NowCompany: Saxon Global
Location: Boston, MA 02115
Description:
- 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