Hybrid Data Engineer & Operations Specialist

Concertina Team; United States; Hybrid; USD 110,000 - 170,000; Full time

Benefits offered by this job

Competitive salary with performance‑dr

WFH setup

HMO coverage for employee and family

Job summary

Concertina Team is seeking a Hybrid Data Engineer & Operations Specialist to build and maintain reliable reporting pipelines across a multi-site retail environment. The role centers on data engineering, BI, and reporting automation while also supporting facilities coordination and lease administration.

The ideal candidate has 5+ years in data engineering, BI, or analytics, with strong Power BI, SQL, data pipelines, APIs, and retail systems experience.

Qualifications

• 5+ years of experience in data engineering, BI development, analytics, or related field.
• Strong hands-on Power BI experience, including semantic modeling, DAX, refresh management, and workspace governance.
• Experience building scheduled data pipelines using Python, Power Query, Azure Data Factory, or similar tools.
• Experience integrating data from ERP, e-commerce, POS, or other operational systems.
• Experience with REST APIs, including authentication, pagination, and scheduled ingestion.
• Strong analytical, troubleshooting, and root‑cause analysis skills.
• Ability to work independently and communicate with U.S.-based stakeholders.
• Attention to data quality, documentation, and reporting accuracy.

Responsibilities

• Build and maintain repeatable data extracts from ERP, e-commerce, POS, payroll, and related systems.
• Design and document ETL/ELT workflows with scheduling, dependencies, and failure monitoring.
• Standardize store, product, brand, calendar, and employee data across systems.
• Monitor data pipelines, investigate errors, and resolve root causes.
• Build and maintain Power BI semantic models, DAX measures, refresh schedules, and workspace governance.
• Develop reporting for sales, store performance, labor productivity, inventory movement, and brand/category performance.
• Replace manual spreadsheet reporting with governed, refreshable dashboards.
• Deliver ad hoc analysis with clear assumptions, caveats, and executive-friendly summaries.
• Reconcile reporting outputs back to source systems and document known variances.
• Maintain data dictionaries, calculation logic, source-of-truth definitions, and refresh schedules.
• Establish appropriate access controls for sensitive financial, labor, and sales data.
• Identify unreliable or incomplete data and elevate issues before inaccurate information is published.
• Manage intake, triage, and prioritization of store maintenance and facilities requests.
• Coordinate vendors, quotes, scheduling, completion verification, and maintenance records.
• Maintain accurate facilities tickets including status, cost, vendor information, and resolution notes.
• Escalate safety, customer-experience, and budget-sensitive issues appropriately.
• Maintain lease abstracts, key terms, rent schedules, and document records within lease administration systems.
• Track renewals, escalation dates, option windows, CAM reconciliations, and other critical lease milestones.
• Support landlord and property-manager communication while maintaining accurate decision records.
• Reconcile lease-related costs against accounting records and flag discrepancies.
• Communicate proactively with U.S.-based stakeholders regarding risks, dependencies, reporting issues, and operational priorities.
• Balance analytical project work with operational requests while protecting the reporting roadmap and data quality.

Skills

Power BI

SQL

Data pipelines

APIs

Retail/e-commerce systems

BI development

Tools

Azure Data Factory

Power Query

dbt

Microsoft Fabric

Job description

Hybrid Data Engineer & Operations Specialist

We are seeking a Hybrid Data Engineer & Operations Specialist to build and maintain reliable reporting pipelines while supporting operational administration across a multi-site retail environment. The primary focus of this role is data engineering, business intelligence, and reporting automation, with secondary responsibility for facilities coordination and lease administration.

The ideal candidate has 5+ years of experience in data engineering, business intelligence, analytics, or related work, with strong hands‑on expertise in Power BI, SQL, data pipelines, APIs, and retail or e-commerce systems. You should be comfortable owning technical reporting infrastructure while also handling operational responsibilities with strong organization, judgment, and follow‑through.

Job Responsibilities:

• Build and maintain repeatable data extracts from ERP, e-commerce, POS, payroll, and related systems.
• Design and document ETL/ELT workflows with clear scheduling, dependencies, and failure monitoring.
• Standardize store, product, brand, calendar, and employee data across multiple systems.
• Monitor data pipelines, investigate errors, and resolve root causes independently.
• Build and maintain Power BI semantic models, DAX measures, refresh schedules, and workspace governance.
• Develop reporting for sales, store performance, labor productivity, inventory movement, and brand/category performance.
• Replace manual spreadsheet reporting with governed, refreshable dashboards.
• Deliver ad hoc analysis with clear assumptions, caveats, and executive‑friendly summaries.
• Reconcile reporting outputs back to source systems and document known variances.
• Maintain data dictionaries, calculation logic, source‑of‑truth definitions, and refresh schedules.
• Establish appropriate access controls for sensitive financial, labor, and sales data.
• Identify unreliable or incomplete data and elevate issues before inaccurate information is published.
• Manage intake, triage, and prioritization of store maintenance and facilities requests.
• Coordinate vendors, quotes, scheduling, completion verification, and maintenance records.
• Maintain accurate facilities tickets including status, cost, vendor information, and resolution notes.
• Escalate safety, customer‑experience, and budget‑sensitive issues appropriately.
• Maintain lease abstracts, key terms, rent schedules, and document records within lease administration systems.
• Track renewals, escalation dates, option windows, CAM reconciliations, and other critical lease milestones.
• Support landlord and property‑manager communication while maintaining accurate decision records.
• Reconcile lease‑related costs against accounting records and flag discrepancies.
• Communicate proactively with U.S.-based stakeholders regarding risks, dependencies, reporting issues, and operational priorities.
• Balance analytical project work with operational requests while protecting the reporting roadmap and data quality.

Qualifications:

• 5+ years of experience in data engineering, BI development, analytics, or a closely related field.
• Strong hands‑on Power BI experience, including semantic modeling, DAX, refresh management, and workspace governance.
• Practical experience building and maintaining scheduled data pipelines using Python, Power Query, Azure Data Factory, or comparable tools.
• Experience integrating data from ERP, e-commerce, POS, or other operational systems.
• Experience working with REST APIs, including authentication, pagination, and scheduled ingestion.
• Strong analytical, troubleshooting, and root‑cause analysis skills.
• Ability to work independently and communicate effectively with U.S.-based stakeholders.
• Strong attention to data quality, documentation, and reporting accuracy.

Strongly Preferred:

• Experience with NetSuite and Shopify.
• Experience with MRI ProLease or comparable lease administration software.
• Experience in retail, e-commerce, or multi‑site operations.
• Familiarity with retail metrics such as sell‑through, units per transaction, labor productivity, and comparable‑store performance.
• Experience with Microsoft Fabric, Azure Data Factory, dbt, or similar modern data‑stack tools.
• Exposure to facilities, property, or multi‑site operations.
• Experience replacing spreadsheet‑based reporting with governed BI dashboards.

Requirements:

• Updated Resume/CV.
• Ability to work in a fast‑paced, dynamic environment.
• Reliable internet connection and personal computer.
• UPS/battery backup to ensure continuity during power interruptions.
• Competitive salary with performance‑based incentives.
• WFH set‑up.
• Opportunities for career advancement.
• HMO coverage for employee and immediate family members.

Can't find the job that you are looking for?