We are looking for a skilled Data Engineer with expertise in Salesforce and BigQuery to join our data team. The ideal candidate will be responsible for designing, developing, and maintaining data pipelines, ETL processes, and data integration solutions that leverage Salesforce and Google BigQuery. You will work closely with cross-functional teams to ensure the efficient flow of data, data transformation, and the availability of high-quality data for analytics and reporting.Key Responsibilities:
Qualifications and Skills:
- Data Integration and ETL: Develop and maintain data integration solutions using Salesforce APIs and BigQuery for the extraction, transformation, and loading of data from various sources into a structured data warehouse.
- Data Modeling: Create and optimize data models, data mappings, and data dictionaries to support ETL processes and ensure data integration aligns with business requirements.
- ETL Pipeline Development: Design, build, and maintain ETL pipelines to move, transform, and load data from source systems into BigQuery, ensuring data consistency and accuracy.
- Data Quality Assurance: Implement data quality checks, data validation, and error handling mechanisms to maintain the integrity of data during the ETL process.
- Performance Optimization: Identify and resolve performance issues in ETL processes and data pipelines, working closely with database administrators to enhance data efficiency.
- Collaboration: Collaborate with business analysts, data analysts, and stakeholders to understand data requirements and deliver solutions that meet business needs.
- Documentation: Maintain comprehensive documentation of data pipelines, ETL processes, data models, and integration workflows, ensuring ease of understanding and future maintenance.
- Monitoring and Support: Monitor data pipelines, diagnose and resolve issues, and provide support for production data integration systems.
- Security and Compliance: Ensure data security and compliance with data governance policies, especially in the handling of sensitive Salesforce data.
- Bachelor's degree in Computer Science, Information Technology, or related field.
- Proven experience as a Data Engineer with a focus on Salesforce and BigQuery.
- Strong proficiency in Salesforce data integration, data modeling, and ETL development.
- Expertise in Google BigQuery, SQL, and data warehousing concepts.
- Problem-solving skills and attention to detail.
- Excellent communication and teamwork abilities.
- Ability to work independently and in a team.
- Salesforce certifications related to data and integration.
- Google Cloud Platform (GCP) or BigQuery certification.
- Familiarity with other data integration tools and cloud services.
- Knowledge of business intelligence and reporting tools.
- Experience with data governance and compliance practices.