BI Developer

OIA Global provides customers with an unparalleled suite of scalable and flexible supply chain solutions. Supported by 1,300 forward-thinking employees, we specialize in 3PL, 4PL, sustainability, technology, contract logistics, packaging design and optimization, and raw materials management. Since 1988, we have grown into a $1.3 billion company with a presence in 27 countries and industry expertise in fashion and apparel, consumer goods, healthcare, energy, and industrials. OIA Global is owned by LDI, Ltd., a U.S. based family office with over one hundred years of experience growing manufacturing and logistics businesses.

Important Note: OIA Global is part of the LDI, Ltd. family of portfolio companies. OIA Global manages LDI's global shared services team, which supports multiple portfolio companies. This role will be based in the OIA Global offices in Pune but will primarily support Polygon Composites Technology, another LDI portfolio company. The role will interact directly with both OIA Global and Polygon team members.

Job title: BI Developer
Location: Pune, India
**Reports to: Senior Analyst at Polygon (**www.polygoncomposites.com)

Polygon Company is a global leader in the design and manufacture of advanced composite materials. Over the last 75 years, Polygon has become a trusted partner to some of the largest brands in the world by providing end-to-end engineering, production, and delivery of high-performance composite parts. Polygon is headquartered in Walkerton, Indiana and operates multiple manufacturing sites in the United States.

The BI Developer role will support Polygon's U.S. operations and leadership team but presents the opportunity to network and learn from a community of peers operating within the broader LDI family of companies, including OIA Global.

Summary:

The BI Developer is a member of Polygon's Analysis team and owns the company's reporting stack end to end, from the backend data structures and SQL through the semantic models to the Power BI and Grafana reports business users see. This is a hands-on technical role for someone who enjoys cleaning and structuring data, writing efficient SQL, and building reliable models, and who can work closely with business users to understand what they need.

Supervisory Responsibilities:

None

Duties and Responsibilities:

• Clean, validate, and restructure source data from Polygon's ERP and related SQL Server databases so reporting is built on consistent, trusted data.
• Design and maintain backend data structures (views, tables, stored procedures) and write efficient, performant SQL.
• Build and optimize semantic models and data models that serve multiple reports from one source of truth.
• Audit, correct, and consolidate existing Power BI reports and their backend models; retire duplicates and reports no one uses.
• Partner with finance and operations users to confirm what each report must show, and the logic, formulas, assumptions, and data sources behind it.
• Document requirements, business rules, formulas, and data lineage for every report and model.
• Build new Power BI and Grafana reports as business needs arise, using Power Query and Excel where they fit.
• Help maintain Polygon's internal MCP server tools used for data access and automate recurring tasks where practical.
• Comfortable learning and using AI tools

Required Skills and Abilities:

• To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions.
• Strong MS SQL Server skills: complex joins, CTEs, window functions, views, stored procedures, and query performance tuning.
• Hands-on experience with relational database design and data modeling (star schema, fact and dimension tables).
• Hands-on experience building semantic models in Power BI, including DAX and Power Query (M).
• Experience cleaning and transforming messy source data, ideally from an ERP system.
• Working knowledge of Grafana or another SQL-based reporting tool.
• Advanced Excel skills.
• Clear communicator who can turn business requests into technical requirements and explain technical logic in plain terms.
• Reliable and detail oriented; comfortable working independently across time zones.
• Python or other scripting for automation is a plus.

Education and Experience:

Bachelor's degree in Data Analytics, Computer Science, Engineering, Mathematics, or a related field.

• 3 to 6 years of experience in business intelligence, data analytics, or a similar technical data role.
• Manufacturing or ERP experience is a plus, not a requirement.
• Able to work a schedule with at least 2 to 4 hours of daily overlap with U.S. Eastern Time (ET).

OIA Global is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, or disability. We offer an exciting and growth-oriented work environment, and OIA employees enjoy competitive salaries and excellent benefits.

www.oiaglobal.com