Data Engineer, Business Intelligence
Fusion Connect
AWSAzureCloudERPETLGoogle Cloud PlatformPythonSQLTableau
Job Level
Mid-LevelSenior
Tech Stack
CloudETLOraclePythonSQLUnity
About the role
- Join the Marketing Operations team to support demand generation and field marketing teams.
- Design and implement robust data pipelines for ingestion, normalization, and segmentation of customer data from various sources.
- Transform raw data into clean, structured, and usable formats.
- Deploy and automate data transformation pipelines using scalable tools and frameworks.
- Design, build, and maintain scalable data ETL pipelines to integrate data from multiple sources.
- Configure data sources, destinations, and event tracking mechanisms between Data Warehouse, ABM, Web Personalization and MAP tools to ensure accurate customer data integration.
- Develop and implement data normalization processes to ensure consistency, accuracy, and usability of customer data.
- Own the creation, testing, and validation of audiences/segments and journey workflows to enable targeted marketing activities.
- Utilize and train out-of-the-box AI/machine-learning models.
- Perform ongoing data quality assurance, including monitoring and verifying data accuracy across marketing systems.
- Monitor and optimize data workflows for performance, scalability, and reliability.
- Maintain comprehensive documentation of platform configurations, operational workflows, and testing protocols.
- Troubleshoot data and platform issues promptly and collaborate with engineering teams and external vendors to escalate and resolve complex technical problems.
- Work closely with data scientists, analysts, and marketing teams to deliver actionable datasets.
- Lead complex data projects, propose innovative solutions, and mentor others in solving technical challenges.
- Translate complex concepts into clear proposals and updates for stakeholders.
- Work independently and efficiently, managing multiple tasks, priorities, and projects simultaneously and successfully.
- Stay current with innovations in data management and promote best practices in marketing data handling and integration.
Requirements
- Bachelor’s or Master’s degree in Computer Science, Engineering, or related field.
- 6+ years of experience in data engineering or related roles.
- Strong understanding of data modeling, ETL/ELT processes, and data warehousing concepts.
- Familiarity with CRM (e.g., Salesforce) is a plus.
- Knowledge of data privacy regulations (e.g., GDPR, CCPA) and best practices in data governance.
- Excellent problem-solving skills and ability to work in a collaborative team environment.
- Ability to create and manage data objects and relationships.
- Familiar with master data management concepts.
- Experience with data integration from various sources.
- Experience working with large data sets.
- General API knowledge.
- General knowledge of data normalization best practices/techniques.
- Understanding of how ID resolution and customer profile unification works in Unity.
- Ability to monitor data flows and resolve anomalies.
- Proficiency in Python, SQL, and data pipeline frameworks.
- (Beneficial) Familiarity with Marketing Automation Platforms (Eloqua, Marketo, Salesforce Marketing Cloud).
- (Beneficial) Familiarity with Customer Data Platforms (Oracle Unity, Segment, Salesforce Data Cloud, Adobe Experience Platform).
- (Beneficial) Knowledge in JSON/XML, Eloqua, Salesforce, Snowflake.
Similar jobs on JobTailor
Senior Business Intelligence Developer
Samsara
CloudETLIoTSQLTableau
Senior Consultant, Data Engineering and Marketing Effectiveness
Ekimetrics
AWSAzureCloudETLGoogle Cloud PlatformPythonSparkSQLTableauUnity
Data Engineer
Bounteous
CloudETLPythonSQL
Senior Data Integration Engineer
Employer Direct Healthcare
AzureETLJavaPythonSQL