What are the responsibilities and job description for the Data Modeler position at Signature Consultants?
Data Modeler
Merrimack, NH or Boston, MA
Onsite Hybrid
Must-Haves :
Data modeling Experience
Erwin or Power Designer
Data mapping / data taxonomy
SQL knowledge
Snowflake
Experience / Skills :
- 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
Dexian is a leading provider of staffing, IT, and workforce solutions with over 12,000 employees and 70 locations worldwide. As one of the largest IT staffing companies and the 2nd largest minority-owned staffing company in the U.S., Dexian was formed in 2023 through the merger of DISYS and Signature Consultants. Combining the best elements of its core companies, Dexian's platform connects talent, technology, and organizations to produce game-changing results that help everyone achieve their ambitions and goals.
Dexian's brands include Dexian DISYS, Dexian Signature Consultants, Dexian Government Solutions, Dexian Talent Development and Dexian IT Solutions. Visit https : / / dexian.com / to learn more.
Dexian is an Equal Opportunity Employer that recruits and hires qualified candidates without regard to race, religion, sex, sexual orientation, gender identity, age, national origin, ancestry, citizenship, disability, or veteran status.
