Data Engineer

Popsockets

Data Engineer role at PopSockets focusing on enterprise data warehouse solutions. Collaborate globally to optimize data processes using Microsoft technologies.

Posted 6/3/2026full-timeFaridabad • 🇮🇳 IndiaMid-LevelSeniorWebsite

Tech Stack

Tools & technologies

CloudETLPythonSparkSQL

About the role

Key responsibilities & impact

Design, build, and maintain enterprise ETL/ELT pipelines in Microsoft Fabric using Dataflow Gen2, Data Factory pipelines, and other Fabric-native tools
Collaborate closely with other Data Engineers and Developers in India to deliver scalable, well-orchestrated data solutions that support a global business
Ingest data from new and existing source systems into Microsoft Fabric using a combination of out-of-the-box connectors, APIs, and custom integration approaches
Transform and standardize disparate datasets into report-ready tables optimized for Power BI and downstream analytics use cases
Engineer and maintain dimensional models, including star schemas with fact and dimension tables, to support enterprise reporting and analytical scalability
Collaborate with analysts and business stakeholders to understand data requirements and translate them into robust warehouse and semantic-ready data structures
Create and monitor jobs, alerts, and data quality checks to identify missing, incomplete, or inaccurate data and perform root cause analysis to resolve issues
Optimize data transformations, query performance, and warehouse design to improve reliability, efficiency, and cost management
Prepare and maintain data architecture documentation, pipeline documentation, system diagrams, and ERDs to clearly communicate lineage and transformation logic
Assist in building roadmaps for new data sources, warehouse enhancements, and process automation opportunities within the Fabric ecosystem
Identify opportunities to improve reporting enablement, automation, and analytical capabilities across the business
Other duties as assigned, including ad hoc project work

Requirements

What you’ll need

Bachelor’s degree in Business Analytics, Computer Science and Engineering, Data Science, Information Systems, or another quantitatively rigorous discipline
3+ years of hands-on experience in data engineering, enterprise data warehousing, data modeling, or related disciplines
Strong understanding of ETL/ELT concepts, with practical experience using SQL, Spark, Python, and other programming languages
Hands-on experience with Microsoft Fabric, including Dataflow Gen2, Data Factory pipelines, and Fabric Lakehouse and Warehouse
Demonstrated experience designing and maintaining dimensional models, including star schemas with dimension and fact tables
Proven ability to normalize, standardize, join, and aggregate disparate raw datasets into report-ready tables at multiple levels of granularity
Experience supporting Power BI or similar BI platforms with analytics-ready datasets and semantic-friendly structures
Consistently leveraging AI to improve efficiency and processes with a desire to build data foundations that support the company’s AI initiatives
Experience building and maintaining API-based integrations, with working knowledge of MCPs, authentication methods, and common integration patterns such as REST, JSON, and webhooks
Ability to identify opportunities for performance optimization, automation, and cost efficiency across data pipelines and warehouse processes
Ability to multi-task, problem solve, and take ownership of work in a fast-paced, high-growth environment
Must be detail oriented with strong organizational, documentation, and analytical skills
Strong work ethic, initiative, and a collaborative mindset with a positive attitude
Experience with Microsoft Dynamics NAV/Business Central, QuickBooks, Salesforce Commerce Cloud, Shopify, Amazon marketplaces, and advertising data is a plus.

Benefits

Comp & perks

PopSockets is dedicated to the practice of equal opportunity employment.

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

ETLELTSQLSparkPythonDataflow Gen2Data Factorydimensional modelingstar schemasAPI-based integrations

Soft Skills

problem solvingorganizational skillsanalytical skillscollaborative mindsetattention to detailinitiativework ethicmulti-taskingownershippositive attitude