Query Optimization With Example Jobs in Usa

Who We Are

At Feetures, movement is our business. And we believe that a meaningful business begins with authentic values—and our values were forged by the bonds of family.

What started as a bold idea around a kitchen table has grown into a fast-moving, purpose-driven brand redefining performance. As a family-owned company in North Carolina, we’re fueled by the belief that better is always possible—and that energy drives both our products and our culture.

Movement is at the heart of everything we do. From our socks to our team and to our communities, we are always pushing forward. If you are ready to grow, challenge the status quo, and help shape the next chapter of a brand that is always in stride, come move with us. Feetures is Meant to Move. Are you?

Role Summary:

The Data Analytics Manager is responsible for owning and optimizing the organization’s end-to-end data ecosystem, ensuring that data infrastructure, governance, and analytics processes effectively support business operations. This role leads the design and management of the data stack—from source system integrations and NetSuite Analytics Warehouse to reporting and business intelligence tools—while establishing strong data governance standards, quality monitoring, and documentation practices. The manager also oversees and mentors analytics team members, prioritizes analytics requests, and coordinates cross-functional data workflows. Acting as the central authority for data reliability and insights, the role ensures consistent metric definitions, scalable data models, and accurate reporting while translating complex data into clear, actionable insights for business stakeholders.

Responsibilities:

Data Architecture & Tooling

• Own the end-to-end data stack — from source system integrations and the NetSuite Analytics Warehouse to downstream reporting layers
• Evaluate, select, and implement tools that improve data accessibility, reliability, and performance
• Ensure alignment between data infrastructure and evolving business needs across distribution operations
• Design and maintain scalable data models, SuiteQL queries, and saved searches within NetSuite

Data Governance & Quality

• Define and enforce data standards, metric definitions, and naming conventions across all business domains
• Establish data ownership, lineage documentation, and access governance policies
• Implement monitoring and alerting for data quality issues across source systems and the warehouse
• Build and maintain a data dictionary that serves as the single source of truth for the organization

Orchestration of Analysts & Systems

• Manage and mentor the Data Analyst and Business Analyst — prioritizing requests, unblocking work, and validating outputs
• Triage and prioritize the analytics request queue in alignment with business stakeholders and IT leadership
• Coordinate cross-functional data workflows and ensure handoffs between systems and analysts are clean and documented
• Serve as the escalation point for data discrepancies, report failures, and analytical questions from the business

Qualifications:

Required

• 3-5 years of experience in data analytics, business intelligence, or data engineering
• 2+ years in a lead or management role overseeing analysts or data team members
• Strong proficiency in SQL; experience with SuiteQL or similar ERP query languages
• Hands-on experience with NetSuite, including Analytics Warehouse, saved searches, and reporting
• Proven track record establishing data governance standards and documentation practices
• Experience integrating and managing multiple data sources across SaaS and ERP platforms
• Demonstrated ability to translate complex data into clear, actionable insights for non-technical stakeholders

Preferred

• Experience in distribution, wholesale, or supply chain environments
• Familiarity with SaaS BI platforms (e.g., Tableau, Power BI, Looker, or embedded analytics)
• Exposure to scripting or automation (JavaScript, Python, or similar) for data workflows
• Background working within IT-led or hybrid IT/Analytics teams

Benefits:

• Health insurance
• Dental insurance
• Vision insurance
• Life & Disability insurance
• 401(K) with company match

Company Paid holidays and PTO:

• Feetures offers 20 PTO Days which are available to you on day one of employment and are available to all employees, no matter your role. After working at Feetures for 5 years, your PTO days will increase to 25 days. Days can be used for vacations, appointments and sick days.
• We offer 10 company paid holidays and 1 floating holiday per year.

Perks:

• Parking provided (Charlotte office and onsite at Hickory office)
• Employee Engagement team
• Monthly stipend to pursue an active lifestyle

Feetures is an Equal Opportunity Employer that welcomes and encourages all applicants to apply regardless of age, race, sex, religion, color, national origin, disability, veteran status, sexual orientation, gender identity and/or expression, marital or parental status, ancestry, citizenship status, pregnancy or other reasons protected by law.

Title: Specialist I, Logistics Data

Job Summary: The Logistics Data Specialist is responsible for managing logistics master data, validating transactional accuracy, and delivering analytics that support transportation planning, customs execution, warehousing, and freight settlement. This role partners with Operations, Procurement, Trade Compliance, and Finance to ensure information reliability and actionable reporting.

Responsibilities include:

• Maintain carriers, lanes, rates, BOMs, HTS, and partner master data in TMS/WMS/SAP.
• Perform audits on shipments tracking milestones, POD, cost allocation, and accrual triggers.
• Identify root causes of data discrepancies and implement corrective actions.
• Build SOPs for data entry, validation logic, and exception handling
• Develop dashboards for OTIF, GIT, transit time, freight spend, accessorial, claims, and capacity utilization.
• Provide weekly/monthly KPI packs to operations leadership.
• Support budget vs. actual analysis and PR forecast modeling.
• Translate business requirements into SQL/BI outputs.
• Validate rating, fuel, and accessorial charges.
• Support three-way match among PO, shipment, and invoice.
• Prepare accrual and variance reports.
• Assist audit requests from Finance
• Act as super-user for TMS/WMS modules.
• Drive automation to reduce manual work
• Work with transportation, warehouse, procurement, and customs teams to improve data transparency.
• Provide data analysis for RFPs, network optimization, and vendor reviews
• All other duties as assigned

Qualifications:

• Bachelor’s degree in supply chain, Logistics, Business Analytics, or related discipline
• 2+ years in logistics, transportation analytics, or supply chain systems.
• Experience working with freight invoices, carrier data, or brokerage information is highly valued
• Advanced Excel (pivot tables, power query, xlookups).
• SQL or similar database querying.
• BI tools such as Power BI, Tableau, or Looker.
• Familiarity with SAP/TMS/WMS environments (e.g., SAP, Oracle, MercuryGate, etc.).
• Strong analytical reasoning.
• High attention to detail.
• Comfortable in fast-moving, build-phase environments.

Physical Requirements and Working Conditions

• Ability to sit for extended periods while working at a computer
• Frequent use of hands and fingers for typing, filing, and operating office equipment
• Occasional standing, walking, bending, and reaching
• Ability to lift and carry light office materials (up to 10–15 lbs.), such as files or office supplies
• Visual acuity to read screens, documents, and reports
• Ability to attend meetings and interact with employees, clients, and vendors

Impact Confections is a high-growth confectionery company producing the fastest growing sour candy brand in the U.S. The company offers a balanced mix of everyday and seasonal products through its two leading brands, WARHEADS® and Melster® Candies. With strong momentum across major U.S. and international retailers and key distribution channels, Impact Confections is positioned for substantial near-term growth. We are seeking a dynamic and analytical Purchasing Specialist / Buyer to join our team.

SUMMARY

The Purchasing Specialist supports and coordinates purchasing, acquisition, and demand planning activities for ingredients, packaging, co-manufacturing and bought in finished goods. The role manages both domestic and international suppliers and contributes to cost optimization, risk mitigation, and operational continuity. The ideal candidate brings solid procurement experience across Direct Materials, Indirect Materials, and Services, with strong analytical capabilities, a customer centric mindset, and a process improvement orientation.

CORE RESPONSIBILITIES & COMPETENCIES

• Source to Contract (S2C): Prepare sourcing events (RFI/RFQ/RFP), validate requirements and specifications with stakeholders, apply TCO criteria, negotiate and recommend awards, support contract review/execution with Legal, and manage supplier onboarding.
• Procure to Pay (P2P): Evaluate purchase requisitions, generate accurate POs, send POs to suppliers, confirm acknowledgments, track deliveries/ETAs and expedite, resolve GR/IR and invoice discrepancies with AP, and close orders.
• Category Coverage: Manage end to end procurement for Direct Materials, Indirect Materials, and Services, aligning with demand, quality, and cost targets.
• Planning & Inventory: Build demand plans integrating production schedules, supplier capacity, lead times, and on hand inventory; maintain Kanban/min max/safety stock to minimize obsolescence.
• Inbound Logistics: Plan/manage inbound flows (including imports) to ensure on time availability at optimal cost.
• Supplier Management (SRM): Qualify, evaluate, and monitor suppliers; participate, when necessary, in Business Reviews, corrective actions, and continuous improvement initiatives.
• Risk Management: Identify supply risks (capacity, quality, geopolitical, single source); implement mitigation frameworks and dual sourcing when appropriate.
• Negotiation & Contracts: Lead negotiations for pricing, commercial terms, service levels, and long-term agreements; support contract and performance management.
• NPD & Changes: Support domestic/international new product development (NPD); coordinate material changes and ramp up/ramp down plans to protect service and cost.
• Artwork & Packaging: Ensure timely release of approved artwork/graphic files to packaging suppliers and printers.
• Cost & Working Capital: Drive cost reduction initiatives (should cost, value engineering, consolidation) and optimize inventory to improve cash and reduce write-offs.
• Analytics & Automation: Build reports/dashboards with advanced Excel and Power BI; leverage SQL/Python/VBA to improve data quality and streamline processes.
• Stakeholder & Customer Focus: Provide timely, solutions-oriented support to Operations, Engineering, Quality, Finance, and Planning; communicate tradeoffs clearly.
• Digital Fluency & Process Discipline: Work effectively within ERP/MRP; maintain clean supplier and material master data and adhere to procurement policies and ESG/responsible sourcing practices.

PROBLEM SOLVING

• Initiative & Ownership: Proactively identifies issues and opportunities and drives actions without waiting for direction.
• Autonomy with Alignment: Works independently and self-manages priorities while keeping the manager informed with clear, concise updates.
• Structured Problem Solving: Breaks down problems, identifies root causes, and implements sustainable countermeasures.
• Effective Escalation: Escalates risks or blockers at the right time, providing context, options, and a recommended path forward.
• Decision Making Under Uncertainty: Makes sound, timely decisions with incomplete information, balancing risk, cost, service, and quality.
• Comfort with Ambiguity: Operates effectively amid changing requirements, adjusting plans and communicating impacts and tradeoffs.
• Continuous Improvement Mindset: Standardizes, documents, and optimize processes to improve reliability, speed, and compliance.

QUALIFICATIONS

• Bachelor’s degree in supply chain management, Logistics, Business, Industrial Engineering, or related field; 2+ years of relevant procurement experience (manufacturing/FMCG/food preferred).
• Proven experience purchasing Direct Materials, Indirect Materials, and Services.
• Strong command of TCO, sourcing strategy, supplier lifecycle management, and basic contract/commercial terms.
• Demonstrated experience in supplier negotiations, performance management, and issue resolution.
• Experience with ERP/MRP systems (e.g., SAP, Oracle; Microsoft Business Central a plus).
• Advanced Excel (pivot tables, complex formulas, Power Query; macros preferred) and experience with Power BI or similar BI tools.
• Data management skills and a structured, process driven approach.
• Basic knowledge of SQL, Python, or VBA to support reporting and automation.
• Strong communication skills in English and ability to collaborate across teams in a fast-paced environment.

PREFERRED QUALIFICATIONS

• Experience in confectionery, food & beverage, or consumer packaged goods.
• Exposure to category strategy, spend analysis, cost modeling, and supplier risk assessment tools.
• Experience with continuous improvement methodologies (e.g., Lean, Six Sigma).
• Familiarity with ESG/responsible sourcing considerations.

COMPUTER SKILLS

Proficiency in Microsoft Office (Word, Excel, PowerPoint). Ability to learn additional applications essential for job tasks.

WHAT WE OFFER

• Collaborative, high-energy environment with opportunities for growth.
• Involvement in procurement and data driven initiatives.
• Active interaction with cross functional stakeholders.
• Multicultural environment.
• Exposure to domestic and international supply base.

Job Title: Supply Chain Manager

Job Location: Towson, MD

Salary: Up to $145k depending on experience.

Job Summary:

• Come join our team! We currently have an exciting Permanent (Direct Hire) opportunity in Towson, MD for a Supply Chain Manager with a minimum of 5–10 years of experience in supply chain, logistics, or manufacturing operations and a strong understanding of supply chain planning processes (forecasting, MRP, S&OP).

Job Description:

• The Supply Chain Manager is responsible for planning, coordinating, and optimizing all supply chain activities to ensure on-time delivery, cost efficiency, inventory optimization, and high customer satisfaction.
• This role works cross‑functionally with Operations, Purchasing, Logistics, Sales, and Quality to align supply chain execution with business strategy and production requirements.

Key Responsibilities:

• Develop, implement, and continuously improve the end‑to‑end supply chain strategy, including planning, procurement, inventory management, production planning, and logistics.
• Lead and manage Sales & Operations Planning (S&OP) forecasts and production capacity.
• Ensure material availability to support production schedules while maintaining optimal inventory levels.
• Collaborate with buyers and suppliers to improve cost, delivery performance, and supply continuity.
• Coordinate logistics and transportation activities, including domestic and international shipments, customs, and carriers.
• Enhance the use of data within the supply chain team to improve performance within the department.
• Monitor and analyze key supply chain KPIs (OTIF, inventory turns, service level, lead time, cost) and implement corrective actions as needed.
• Identify risks within the supply chain and develop mitigation plans to minimize disruptions.
• Drive continuous improvement initiatives related to processes, systems, and organizational efficiency.
• Lead continuous improvement activities with suppliers to improve on time delivery and quality level of products provided.
• Coach suppliers through problem solving / root cause and corrective action implementation to improve performance.
• Lead, coach, and develop the supply chain team to ensure strong performance and engagement.
• Act as a key contributor to site or business leadership discussions related to operations performance and strategy.

Key Interfaces:

• Internal: Operations, Production, Purchasing, Sales, Quality, Engineering, Finance
• External: Suppliers, logistics providers, transporters, customers, customs authorities

Required:

• Bachelor’s degree in Supply Chain Management, Industrial Engineering, Business, or a related field.
• Must have government procurement experience in the defense or space industry.
• Minimum of 5–10 years of experience in supply chain, logistics, or manufacturing operations (depending on seniority level).
• Proven experience in production planning, inventory control, and supplier coordination.
• Experience leading teams and managing cross‑functional initiatives.
• Strong analytical, problem‑solving, and decision‑making skills.
• Excellent data analysis skills, familiarity with SQL data, Power Query, MS Excel, MS Navision.
• Excellent supplier negotiation skills and supplier development skills.
• Strong understanding of supply chain planning processes (forecasting, MRP, S&OP).
• Excellent communication and stakeholder management skills.
• Ability to work effectively in a fast‑paced manufacturing environment.
• Proficiency with ERP/MRP systems and supply chain analytics tools.
• Continuous improvement mindset (Lean, Six Sigma experience preferred).

Success Metrics:

• On‑time delivery and customer service performance.
• Inventory accuracy and turnover.
• Supply chain cost optimization.
• Production schedule adherence.
• Team performance and engagement.

Note:

• Must be U.S. Citizen - "Must be able to meet ITAR requirements, including US citizenship to be considered for this role."

The Operations Data Analyst will play a crucial role in applying data analysis and reporting to support operational performance, production scheduling, and process improvements. This position will work closely with operations teams to assist in scheduling tasks as needed, while also owning analytics processes, reporting, and data-driven insights that improve productivity, quality, and throughput.

***This is 100% on-site, full-time position in Madison, IN. Hybrid or remote work is NOT available.

Qualifications

Technical Skills

• Strong SQL skills: ability to write complex queries, join large datasets, optimize performance, and produce reliable analytical outputs.
• Advanced Excel expertise: pivot tables, VLOOKUP/XLOOKUP, Power Query, macros/VBA a strong plus.
• Experience with data visualization tools (Power BI, Tableau, or similar) preferred.
• Comfortable working with large datasets and generating meaningful insights.

Production Experience

• Understanding of production planning, operations workflows, and scheduling concepts — ideally in a manufacturing/industrial environment.
• Prior work in supporting production operations with analytical tools or capacity planning.

Education

• Bachelor’s Degree preferred — Analytics, Industrial Engineering, Supply Chain, Data Science, Business Analytics, Mathematics, or related field.
• Equivalent experience with strong technical skills considered.

Preferred Qualifications

• Experience with manufacturing ERP/MRP systems.
• SQL Server, MySQL, PostgreSQL, or similar database experience.
• Familiarity with scheduling tools or production modules within ERP systems.
• Knowledge of Lean Manufacturing or Continuous Improvement methodologies.

***FOR IMMEDIATE CONSIDERATION, PLEASE SEND A COPY OF YOUR UPDATED RESUME.

The Senior Reporting Analyst will lead the design, development, and maintenance of high-performance Power BI dashboards and scalable Snowflake-based semantic models using DAX and Power Query. This role bridges the gap between technical data engineering and business strategy by gathering requirements from stakeholders, translating them into intuitive BI solutions, and presenting actionable insights to leadership. Beyond technical development, you will champion a self-service analytics ecosystem by establishing data governance standards, curating certified datasets, and delivering comprehensive "train-the-trainer" programs to empower business users. You will also partner closely with data architects to ensure data quality, optimize performance for cost efficiency, and mentor internal teams on data-driven decision-making.

Required Qualifications

• 10+ years of professional experience in Business Intelligence (BI), analytics, or data modeling roles.
• 5+ years of advanced proficiency with Power BI, specifically including DAX, Power Query (M), and complex data modeling.
• 5+ years of experience designing, implementing, or supporting self-service analytics environments.
• 5+ years of experience with Microsoft Office tools (Word, Excel, PowerPoint, Visio, and SharePoint).
• 3+ years of strong SQL skills with hands-on experience in Snowflake, Databricks, or a similar cloud data platform.
• 2+ years of experience in fast-paced environments, demonstrating the ability to meet project deliverables, exercise sound judgment, and address complex issues.
• 2+ years of experience with enterprise information management processes, relational database management systems (RDBMS), and metadata management.
• 2+ years of demonstrated skill in interpersonal relationships, including the ability to work under pressure, negotiate among multiple parties, and resolve conflicts.

Preferred Qualifications

• 2+ years of experience in data-focused projects, specifically involving migrations from legacy systems to modern cloud platforms.
• 2+ years of knowledge regarding local, state, and federal laws and regulations (such as PII) relevant to data management and governance.
• 2+ years of theoretical and practical knowledge of database structures and advanced data theories.
• Graduation from an accredited four-year college or university with major coursework in Data Processing, Computer Science, Business Administration, or a related field.
• Prior experience working within a Texas State Agency or similar public sector environment.