Posted today
At Near, we connect top talent in Latin America with exciting remote opportunities at U.S.-based companies. Our mission is to create better lives by fostering a remote work culture that transcends borders.
About the Role:
We’re looking for a BI Engineer who combines strong technical skills with a sharp eye for design. You’ll rebuild and expand an existing set of Tableau reports into Power BI on top of Azure Synapse, build and maintain the data ingestion pipelines that feed it from eCommerce, advertising, and ERP sources, and collaborate closely with the Director of Information Systems and other stakeholders to deliver clean, interactive, business-ready dashboards. This role requires someone proactive and fast-paced, comfortable working from sometimes high-level requirements, who can be self-sufficient and produce high-quality, visually compelling reports.
You Will:
Rebuild existing Tableau reports and dashboards in Power BI, focusing on the visual/reporting layer (no Tableau data migration needed).
Design and implement interactive Power BI reports and dashboards on top of an Azure Synapse / serverless SQL data model.
Build and maintain data ingestion pipelines from sources including, but not limited to, Amazon (Seller/Vendor Central, SP-API, Amazon Ads), Shopify, Meta Ads, and Google Ads.
Work directly with source APIs, handling authentication and token refresh, pagination, rate limits, and API version changes.
Manage scheduled and incremental loads and backfills, and handle data that arrives late or gets restated (ad attribution windows, returns, and refunds).
Write SuiteQL against core NetSuite tables and tie reports back to NetSuite financials (P&L, balance sheet), explaining any differences.
Work from high-level reporting needs (e.g., sales, fulfillment, portfolio performance) and translate them into clear, usable visualizations.
Reuse and adapt existing report structures, building initial templates and then iterating and tweaking views as business needs evolve.
Understand and navigate the existing semantic model to correctly join, filter, and aggregate data.
Write and optimize queries (primarily with SQL, SuiteQL, and Power BI query tools) to support reporting requirements.
Collaborate with the Director of Information Systems and business stakeholders to prioritize the report backlog and clarify requirements.
Ensure consistency, performance, and usability across a large number of reports and views.
Contribute to documenting report logic, data definitions, pipeline behavior, and usage guidance for business users.
About You:
Your Background:
Several years of hands-on experience building reports and dashboards with Power BI as a primary tool.
Deep knowledge of Power BI, including data modeling/semantic models, relationships, measures, and building interactive dashboards.
Strong understanding of data structures and SQL; comfortable querying and exploring relational data.
Hands-on experience building and maintaining data ingestion pipelines from eCommerce and advertising sources (Amazon Seller/Vendor Central, SP-API, Amazon Ads, Shopify, Meta Ads, Google Ads, or similar).
Experience working with APIs directly: authentication and token refresh, pagination, rate limits, and API version changes.
Experience with scheduled and incremental loads, backfills, and late-arriving or restated data (e.g., ad attribution windows, returns, refunds).
Solid understanding of the NetSuite data model and comfort writing SuiteQL against the main tables.
Ability to reconcile reports with NetSuite financials (P&L, balance sheet) and explain any variances.
Experience working with data sourced from cloud data warehouses (ideally Azure Data Factory and Azure Synapse).
Hands-on AI/LLM experience (Anthropic/MCP ideally).
Excellent communication skills: comfortable working in English with distributed teams.
Self-sufficient, proactive, and organized: you take ownership of requirements, ask the right questions, and drive reports to completion.
Able to work at a fast pace and handle a high volume of reporting requests while maintaining quality.
Nice to Have:
Familiarity with ERP/financial concepts beyond NetSuite (e.g., invoices, shipments, transactions, daily sales).
Experience reporting on eCommerce/retail data, particularly Shopify and Amazon.
Experience blending marketplace data with ERP data for deeper customer-level and order-level insights.
Exposure to AI-assisted analytics or chatbot-style interfaces that sit on top of reporting data (e.g., answering questions about portfolio performance).
Prior experience in multi-entity or portfolio reporting environments.
What’s in it for you
Compensation range: $4,000 - $5,000 USD per month. Please note that the final salary offer may vary based on the candidate’s seniority, specific skill set, and performance throughout the evaluation and interview process.
Paid time off for company US holidays, with flexibility to take additional unpaid time off as needed.
Opportunity to work with a fast-paced, technology-focused business and learn about their operations and decision-making.
Exposure to a variety of business domains and data/reporting needs beyond just the technical work.