Principal Data Engineer
3 Months ago • 10 Years + • $140,000 PA - $145,000 PA
Data Analysis
Job Description
Brillio is seeking a Principal Data Engineer to join their team. The role involves collaborating with Product Management to understand use cases and requirements, conducting data discovery and analysis of source systems, and developing conceptual and logical data models. The engineer will translate logical models into physical data models for Salesforce Data Cloud, including source-to-target mapping documentation with transformation rules. Responsibilities include supporting engineering teams during the implementation of physical data models. The ideal candidate needs strong communication and influencing skills, the ability to work autonomously, and think creatively.
Good To Have:
- Experience with Salesforce Data Cloud, Marketing Cloud, and Tableau
- Practical experience with sales and marketing data
- Experience working with globally distributed teams
- Availability to work in the Pacific time zone
Must Have:
- 10+ years experience in data modeling and design for OLTP and analytical systems
- Solid understanding of data modeling principles and best practices
- Expertise in canonical and semantic data modeling concepts
- Proficiency in data modeling software (e.g., ER Studio, ERwin)
- 10+ years experience in data analysis and profiling using SQL
About Brillio:
Brillio is one of the fastest growing digital technology service providers and a partner of choice for many Fortune 1000 companies seeking to turn disruption into a competitive advantage through innovative digital adoption. Brillio, renowned for its world-class professionals, referred to as "Brillians", distinguishes itself through their capacity to seamlessly integrate cutting-edge digital and design thinking skills with an unwavering dedication to client satisfaction.
Brillio takes pride in its status as an employer of choice, consistently attracting the most exceptional and talented individuals due to its unwavering emphasis on contemporary, groundbreaking technologies, and exclusive digital projects. Brillio's relentless commitment to providing an exceptional experience to its Brillians and nurturing their full potential consistently garners them the Great Place to Work® certification year after year.
Principal Data Engineer
Primary Skills
- data modeling software (e.g., ER Studio, ERwin) and design for OLTP and analytical systems
Job requirements
- Location: Onsite at San Francisco, California
- 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.
- 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.
- 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.
The ideal candidate will possess strong communication, influencing, and negotiation skills to independently drive consensus and consistency across multiple teams. The Data Modeler must be able to work autonomously, think creatively, and take ownership of resolving challenges.
Key Responsibilities:
Minimum Qualifications:
Preferred Qualifications:
Know more about:
Know what it’s like to work and grow at Brillio: https://www.brillio.com/join-us/
Equal Employment Opportunity Declaration
Brillio is an equal opportunity employer to all, regardless of age, ancestry, colour, disability (mental and physical), exercising the right to family care and medical leave, gender, gender expression, gender identity, genetic information, marital status, medical condition, military or veteran status, national origin, political affiliation, race, religious creed, sex (includes pregnancy, childbirth, breastfeeding, and related medical conditions), and sexual orientation.
#LI-SR1
Set alerts for more jobs like Principal Data Engineer
Set alerts for new jobs by Brillio
Set alerts for new Data Analysis jobs in United States
Set alerts for new jobs in United States
Set alerts for Data Analysis (Remote) jobs
