Data Engineer

We are implementing a Media Mix Optimization (MMO) platform designed to analyze and optimize marketing investments across multiple channels. This initiative requires a robust on-premises data infrastructure to support distributed computing, large-scale data ingestion, and advanced analytics. The Data Engineer will be responsible for building and maintaining resilient pipelines and data systems that feed into MMO models, ensuring data quality, governance, and availability for Data Science and BI teams. The environment integrates HDFS for distributed storage, Apache NiFi for orchestration, Hive and PySpark for distributed processing, and Postgres for structured data management.This role is central to enabling seamless integration of massive datasets from disparate sources (media, campaign, transaction, customer interaction, etc.), standardizing data, and providing reliable foundations for advanced econometric modeling and insights.Responsibilities:Data Pipeline Development & Orchestration o Design, build, and optimize scalable data pipelines in Apache NiFi toautomate ingestion, cleansing, and enrichment from structured, semi-structured, and unstructured sources.Ensure pipelines meet low-latency and high-throughput requirements for distributed processing.Data Storage & Processingo Architect and manage datasets on HDFS to support high-volume,fault-tolerant storage.o Develop distributed processing workflows in PySpark and Hive tohandle large-scale transformations, aggregations, and joins acrosspetabyte-level datasets.o Implement partitioning, bucketing, and indexing strategies tooptimize query performance.Database Engineering & Managemento Maintain and tune Postgres databases for high availability, integrity,and performance.o Write advanced SQL queries for ETL, analysis, and integration withdownstream BI/analytics systems.Collaboration & Integrationo Partner with Data Scientists to deliver clean, reliable datasets formodel training and MMO analysis.o Work with BI engineers to ensure data pipelines align with reportingand visualization requirements.Monitoring & Reliability Engineeringo Implement monitoring, logging, and alerting frameworks to trackdata pipeline health.o Troubleshoot and resolve issues in ingestion, transformations, anddistributed jobs.Data Governance & Complianceo Enforce standards for data quality, lineage, and security acrosssystems.o Ensure compliance with internal governance and externalregulations.Documentation & Knowledge Transfero Develop and maintain comprehensive technical documentation forpipelines, data models, and workflows.o Provide knowledge sharing and onboarding support for cross-functional teams.Bachelor’s degree in Computer Science, Information Technology, or related field (Master’s preferred).Proven experience as a Data Engineer with expertise in HDFS, Apache NiFi, Hive, PySpark, Postgres, Python, and SQL.Strong background in ETL/ELT design, distributed processing, and relational database management.Experience with on-premises big data ecosystems supporting distributed computing.Solid debugging, optimization, and performance tuning skills.Ability to work in agile environments, collaborating with multi-disciplinaryteams.Strong communication skills for cross-functional technical discussions.Preferred Qualifications:Familiarity with data governance frameworks, lineage tracking, and data cataloging tools.Knowledge of security standards, encryption, and access control in on- premises environments.Prior experience with Media Mix Modeling (MMM/MMO) or marketing analytics projects.Exposure to workflow schedulers (Airflow, Oozie, or similar).Proficiency in developing automation scripts and frameworks in Python forCI/CD of data pipelines.Blend360 is a data and AI services company specializing in data engineering, data science, MLOps, and governance to build scalable analytics solutions. It partners with enterprise and Fortune 1000 clients across industries including financial services, healthcare, retail, technology, and hospitality to drive data-driven decision making. Headquartered in Columbia, Maryland, the company is recognized for rapid growth and global delivery of AI solutions through the integration of people, data, and technology.We are seeking a hands-on Data Engineer with deep expertise in distributed systems, ETL/ELT development, and enterprise-grade database management. The engineer will design, implement, and optimize ingestion, transformation, and storage workflows to support the MMO platform. The role requires technical fluency across big data frameworks (HDFS, Hive, PySpark), orchestration platforms (NiFi), and relational systems (Postgres), combined with strong coding skills in Python and SQL for automation, custom transformations, and operational reliability.Originally posted on Himalayas