Data Engineer

Responsible for implementing data migration from SQL Server to the SAAS platform named SODA, focusing on optimizing workflows to minimize data processing time through the use of complex stored procedures;

Independently manage sensitive payments and donor data using SQL Server Management Studio, ensuring data quality by conducting metrics analysis and creating key performance indicators (KPIs) within Tableau dashboards for analysis;

Track project progress, monitor deliverables, and manage ticket issues efficiently using Jira, ensuring timely project delivery and ongoing support;

Assist stakeholders in making budgeting, marketing, and campaigning decisions by developing and presenting consumer insights in interactive dashboards. These insights are derived from data sourced from various online marketing platforms and presented using Tableau;

Implement and manage Git repositories using Bitbucket for version control, collaborating with development teams to establish proper branching strategies and facilitate efficient code integration and review processes using Visual Studio Code;

Collaborate with DevOps engineers to configure and manage Git repositories and CI/CD pipelines using Jenkins, with a focus on optimizing project performance, scalability, and security to ensure efficient and reliable project delivery.

Responsible for acquiring, cleaning, and structuring COVID-related patient data from vaccination sites using SQL scripts, ensuring data accuracy and quality for further processing;

Developed and maintained ETL Data Pipelines using Pentaho and AWS architecture to facilitate seamless data migration to target applications such as Salesforce and AWS, optimizing data analysis across various infrastructures;

Independently scheduled vaccination dose appointments using bulk email marketing, leveraging SendGrid to manage and communicate with vaccine recipients efficiently;

Played a significant role in contributing to data model decisions for projects involving data integrations and migrations to different target applications, such as Salesforce, AWS, and SQL Server. Ensured data integrity was maintained between systems by building custom integrations using APIs;

Responsible for developing and maintaining ETL Data Pipelines, enabling the movement of large structured and unstructured data from sources including SQL Server, flat files, and APIs. This data was loaded into Amazon Redshift data warehouse and database clusters to facilitate efficient data analysis.

Diligently monitored and customized user accounts within Salesforce CRM, ensuring a seamless user experience;

Responsible for the generation of reports and dashboards in Salesforce CRM to provide valuable insights and support data-driven decision-making;

Analyzed and constructed detailed client profiles within Salesforce, contributing to the enhancement of CRM marketing strategies and troubleshooting any related issues;

Successfully collected and migrated business data from Excel worksheets to Salesforce through bulk uploads using data loader, ensuring data accuracy and consistency;

Managed and maintained the company's Salesforce.com portal website using Community Builder setup, ensuring a user-friendly and informative online presence;

Provided valuable recommendations to the Director by leveraging predictive sales and engagement data analysis, aiming to improve customer engagement and revenue;

Acted as the primary point of contact for various departments within the organization regarding data and report requests, retrieving necessary data from custom objects and APIs in Salesforce using SOQL queries via Salesforce Inspector;

They played a key role in integrating Salesforce CRM with third-party applications like Mailchimp and QuickBooks, streamlining processes and enhancing data synchronization between systems.

Responsible for acquiring, cleaning, and structuring business data from multiple sources, ensuring data quality and presentation met high standards;

Developed proficiency in analytical practices using Python, harnessing data to enhance decision-making processes within the organization;

Actively constructed reports and dashboards using Tableau, visually representing key insights that led to data-driven actions aimed at improving business performance;

Maintained, queried, and regularly reviewed databases using MS SQL Server, seeking opportunities to enhance business models and processes;

Created detailed Excel workbooks that incorporated sales, public, and demographic data, employing complex formulas and macros to facilitate data analysis;

Identified, communicated, and recommended resolutions for data-related issues by querying the databases within MS SQL Server;

Dedicated efforts to optimize and monitor business performance to achieve increased accuracy, gain better insights, and streamline processes for improved efficiency.