Design, develop, and maintain data pipelines to ingest, transform, and load datasets (e.g. Salesforce, Marketo) into our data warehouse.
Work closely with cross-functional teams to gather requirements, define data models, and implement solutions that meet business needs.
Collaborate with Business Intelligence analyst and business stakeholders to understand data requirements and translate them into technical specifications.
Perform basic data analysis to identify trends, patterns, and anomalies, and provide insights to support decision-making processes.
Conduct data validation and ensure data accuracy, completeness, and integrity through quality assurance checks and validation processes.
Optimize database performance and scalability by fine-tuning queries, indexing strategies, and schema design.
Monitor and troubleshoot data pipeline issues, resolve data integration errors, and ensure data pipelines are running smoothly.
Stay current with emerging technologies, best practices, and trends in data engineering and cloud computing.