Principal Data Engineer
| Company | Brillio |
|---|---|
| Location | Seattle, WA, USA, San Francisco, CA, USA |
| Salary | $140000 – $145000 |
| Type | Full-Time |
| Degrees | |
| Experience Level | Expert or higher |
Requirements
- 10+ years of hands-on experience in data modeling and design for OLTP and analytical systems.
- Solid understanding of data modeling principles and best practices, with expertise in canonical and semantic data modeling concepts.
- Proficiency in at least one data modeling software (e.g., ER Studio, ERwin).
- 10+ years of experience in data analysis and profiling using SQL and other relevant tools.
Responsibilities
- Collaborate with Product Management to understand and evaluate use cases, as well as functional and technical requirements.
- Conduct data discovery and analysis of source systems to identify the necessary data to fulfill business requirements.
- Develop conceptual and logical data models to validate requirements, pinpointing essential entities and relationships with full documentation of assumptions/risks.
- Translate logical data models into physical data models for Salesforce Data Cloud, including the production of source-to-target mapping documentation that outlines data movement from source to destination and specifies transformation rules.
- Support engineering teams through the implementation of physical data models, including source-to-target mapping and the application of transformation/business rules.
Preferred Qualifications
- Experience with our technology stack, including Salesforce Data Cloud, Marketing Cloud, and Tableau, is highly desirable.
- Practical experience with sales and marketing data.
- Experience working with globally distributed teams is an advantage.
- Availability to work in the Pacific time zone.