Query Optimization With Example Jobs Remote Jobs in Usa

Instructions

Must have Epicor experience from version 9 or 10 through Kinetic

Local candidates only (onsite role)

Job Description

Key Responsibilities:

Administer, maintain, and support Epicor ERP environments (Epicor 9, Epicor 10, and Kinetic).

Manage system configuration, user security, roles, permissions, and licensing.

Perform upgrades, patches, and version migrations, including support for Kinetic transition initiatives.

Monitor system performance, troubleshoot issues, and ensure high availability and reliability.

Support Epicor modules such as Manufacturing, Supply Chain, Finance, MRP, Purchasing, Inventory, and Production (as applicable).

Collaborate with business users to gather requirements and translate them into system configurations or enhancements.

Develop, maintain, and optimize BAQs, dashboards, reports, and forms.

Manage integrations between Epicor and third-party systems (EDI, MES, WMS, CRM, etc.).

Oversee data management, backups, disaster recovery planning, and system documentation.

Coordinate with Epicor vendors/partners on support tickets, upgrades, and best practices.

Provide end-user training, documentation, and Tier 2/3 support.

Ensure system security, compliance, and audit readiness.

Support continuous improvement initiatives and ERP roadmap planning.

Required Qualifications

Hands-on experience administering Epicor ERP (Epicor 9 and/or Epicor 10; Kinetic strongly preferred).

Strong understanding of Epicor architecture, application server, database, and client deployment.

Experience with SQL Server (queries, performance troubleshooting, data validation).

Proven experience with Epicor security, BAQs, BPMs, dashboards, and customizations.

Experience supporting ERP upgrades and system migrations.

Solid understanding of manufacturing and/or distribution business processes.

Strong troubleshooting, analytical, and problem-solving skills.

Excellent communication skills with both technical and non-technical stakeholders.

We are seeking a Senior Lead Developer to lead the development and deployment of our backend services. In this role, you will be the bridge between our PostgreSQL database and React frontend, responsible not only for writing high-performance Python code but also for architecting the CI/CD pipelines that bring our applications to life. You will ensure our integration layers are scalable, secure, and automatically deployed.

Key Responsibilities

• API & Backend Development: Design and maintain production-grade RESTful APIs using Python (FastAPI, Flask) with a focus on asynchronous processing.

• Database Engineering: Architect relational schemas and write optimized SQL in PostgreSQL, ensuring data integrity and query performance.

• React Integration: Partner with frontend teams to define API contracts, handle state-consistent data fetching, and implement secure authentication (JWT/OAuth2).

• CI/CD & Deployment: Build and manage automated deployment pipelines (e.g., Azure DevOps or Jenkins) to move code from local environments to staging and production.

• Containerization & Cloud: Package applications using Docker and manage deployments on cloud platforms or container orchestrators (Kubernetes/ECS).

• System Reliability: Implement automated testing (PyTest), logging, and monitoring to ensure high availability of integration services.

Technical Requirements

• Experience: 10+ years of professional backend development with a heavy emphasis on Python and API architecture.

• PostgreSQL Expert: Advanced SQL knowledge, including indexing strategies, migrations (Alembic/Flyway), and performance profiling.

• DevOps Tooling: Hands-on experience with Docker and building CI/CD pipelines for Python applications.

• Frontend Literacy: Solid understanding of React (Hooks, Context API) and how it consumes complex JSON structures.

• Infrastructure as Code (Bonus): Familiarity with Terraform or AWS CloudFormation is a significant plus.

The "Lead" Expectation

At the 10-year mark, we expect more than just "feature delivery." We are looking for a candidate who:

• Automates Everything: If a task is done twice, they write a script or a CI job for it.

• Designs for Failure: Implements proper error handling, retries, and health checks in the API layer.

• Collaborates Across the Stack: Can jump into a React component or a Postgres execution plan to find the root cause of a bottleneck.

HCLTech is looking for a highly talented and self-motivated 3DExperience Developer to join it in advancing the technological world through innovation and creativity.

Job Title: 3DExperience Developer

Job ID: 59636

Position Type: Fulltime

Location: Dearborn, MI

Key Responsibilities

• Develop migration tools, validation tools, and custom utilities for ENOVIA/3DExperience platform.
• Participate in migration rehearsals, execution, and reconciliation activities.
• Perform Root Cause Analysis (RCA) for migration issues and implement effective solutions.
• Track, troubleshoot, and resolve all issues raised during migration cycles.
• Work on ENOVIA customization including triggers, policies, workflows, UI modifications, and data model changes.
• Develop and support JPOs, MQL scripts, TCL programs, and platform extensions.
• Provide customer support for day‑to‑day issues, enhancements, and upgrades.
• Collaborate with cross‑functional teams to ensure smooth end‑to‑end PLM integration.
• Ensure adherence to PLM best practices, coding standards, and performance optimization.

Required Technical Skills

• Strong hands‑on experience with Enovia V6 / 3DExperience platform
• Expertise in:
• MQL (Matrix Query Language)
• TCL scripting
• Core Java
• JPO development
• PnO framework
• Triggers development
• Solid experience in data migration, including ETL workflows, load validation, and performance tuning.
• Strong understanding of ENOVIA objects, attributes, policies, lifecycles, access rules, and configurations.
• Experience with issue debugging in complex migration environments.

Preferred Qualifications

• Experience in large-scale PLM migration projects
• Knowledge of 3DExperience platform architecture
• Familiarity with REST APIs, web services, and integrations
• Good understanding of Agile methodologies
• Excellent problem-solving and communication skills

Pay and Benefits

Pay Range Minimum: $97000 per year

Pay Range Maximum: $147000 per year

HCLTech is an equal opportunity employer, committed to providing equal employment opportunities to all applicants and employees regardless of race, religion, sex, color, age, national origin, pregnancy, sexual orientation, physical disability or genetic information, military or veteran status, or any other protected classification, in accordance with federal, state, and/or local law. Should any applicant have concerns about discrimination in the hiring process, they should provide a detailed report of those concerns to for investigation.

Compensation and Benefits

A candidate’s pay within the range will depend on their work location, skills, experience, education, and other factors permitted by law. This role may also be eligible for performance-based bonuses subject to company policies. In addition, this role is eligible for the following benefits subject to company policies: medical, dental, vision, pharmacy, life, accidental death & dismemberment, and disability insurance; employee assistance program; 401(k) retirement plan; 10 days of paid time off per year (some positions are eligible for need-based leave with no designated number of leave days per year); and 10 paid holidays per year.

How You’ll Grow

At HCLTech, we offer continuous opportunities for you to find your spark and grow with us. We want you to be happy and satisfied with your role and to really learn what type of work sparks your brilliance the best. Throughout your time with us, we offer transparent communication with senior-level employees, learning and career development programs at every level, and opportunities to experiment in different roles or even pivot industries. We believe that you should be in control of your career with unlimited opportunities to find the role that fits you best.

Role: Learning and Development Coordinator II

Location: Newport Beach CA/ Omaha NE

Duration: 06 Months

The Learning and Development Coordinator will support the end-to-end coordination of a key enterprise learning program. Maintaining training and user profile records; this role coordinates calendaring and enrollment, tracking, assessments, reporting and customer communications for virtual and in person learning events. Working as a conduit between the Pacific Life learning team and our external vendor they will serve as a subject matter expert in coordinating learning programs, maximizing the utilization of our learning system features to create and manage learning events, training modules, assessments, and reports.

Responsibilities

• Coordinate learning & development program logistics for Talent development programs, to include but not limited to Learning Management System (LMS) setup, calendar scheduling, ordering materials, assigning pre-work, recording attendance, sending evaluations, issuing certificates and other support needed to support the learning experience for participants in partnership with the Talent Development team.
• Raise issues with the senior learning team members that may impact the program of delivery in project meetings
• Manage first line queries from learners in a timely manner via shared mailboxes
• Maintain repository of learning & development document organization and structure in SharePoint Cloud or other collaboration sites as needed
• Work with the Cornerstone Administrative Lead to ensure that the system remains optimized for the roll out of the global programmes
• Support as required with other enterprise programs to cover periods of vacation in the team
• Produce consistent attendance and evaluation reports

Support

• Receives instruction, guidance, and direction from the T&D team

Qualifications/experience

• 3-5 years of experience
• 4-year degree or equivalent work experience
• LMS experience desirable
• Cornerstone
• Outlook
• Excel
• Experience of working in a global or multi located team

Job Title: Senior Resource Planner (Manufacturing & Power Gen)

Location: Alpharetta, GA (On-site/Hybrid)

ROLE SUMMARY

We are seeking a highly analytical Senior Resource Planner to lead the optimization of our project lifecycle, from planning through commissioning. This is not a traditional scheduling role; you will act as a strategic advisor, auditing our current "Excel-centric" workflows to identify inefficiencies and architecting data-driven solutions. You will bridge the gap between complex power generation manufacturing and modern project management methodology, leveraging Power BI and AI tools to transform raw data into actionable executive insights for people and materials planning.

STRATEGIC RESPONSIBILITIES

• Resource Planning: Review existing MS Excel plans and develop an all-encompassing resource and material view to ensure each project is properly staffed with acceptable levels of utilization
• Operational Audit: Analyze existing project management and manufacturing workflows currently managed in MS Excel. Identify "single points of failure," data silos, and opportunities for automation.
• Systems Architecture: Lead the transition from manual spreadsheet tracking to integrated project controls. Develop logically linked master schedules that account for manufacturing lead times and on-site commissioning variables.
• Advanced Data Visualization: Design and implement Power BI dashboards to provide real-time visibility into project health, cost control, and resource needs and utilization across the portfolio.
• Critical Path & Risk Modeling: Perform advanced critical path analysis and "what-if" scenarios for high-stakes power generation and automation projects.
• Cross-Functional Advisory: Serve as the lead technical advisor to Project Managers and Engineers, resolving complex scheduling bottlenecks and resource conflicts.
• Automation & AI Integration: Explore and implement AI-driven tools to enhance forecasting accuracy and automate repetitive data entry tasks within the project lifecycle.
• Commissioning Oversight: Integrate site-specific commissioning phases into the master manufacturing schedule to ensure seamless handoffs and contract compliance.

KNOWLEDGE, SKILLS & EDUCATION

• Education: Bachelor’s Degree in Engineering, Construction Management, or Business Analytics.
• Experience: 7+ years of experience in forecasting, project planning/scheduling within Manufacturing, Power Generation, or Industrial Automation.
• Excel Mastery: Expert-level MS Excel skills (VBA, Power Query, Macros, complex modeling) are required, as you will be "deconstructing" the current business logic built into spreadsheets.
• Modern Stack: Proficiency in Power BI is highly desirable. Experience with AI-assisted project management tools is a significant plus.
• Technical Tools: MS Project or Primavera P6 is a plus but not required.
• Analytical Mindset: Proven ability to translate technical manufacturing constraints into clear, high-level business reports for stakeholders.

Head of Business Operations

Brief Summary

The Head of Business Operations owns the configuration, integrity, and scalability of the company's business operations systems, serving as the bridge between business strategy and technical execution reporting directly to the CEO/Co-Founder. This role is responsible for translating institutional knowledge into scalable business processes,

ensuring data integrity, and enabling the transition from ad-hoc decision making to data-driven workflows. This is a senior management role with individual-contributor responsibilities, broad cross-functional authority, and high executive visibility.

The Head of Business Operations will take a lead role in defining the data architecture, implementing process guardrails, and analyzing operational data to drive strategy. This person acts as the cross-functional orchestrator of the business operations system, collaborating with Sales, Production, and Leadership to extract & refine business logic and codify it into streamlined processes. Success in this role requires a strong backbone to enforce higher standards, and an analytical and systems-thinking mindset to visualize downstream effects.

What Success Looks Like

● All core workflows are analyzable, have entrance/exit criteria, and are governed by continuously improving SOPs

● Leadership can answer key operational questions without ad-hoc data pulls

● Administrative overhead for sales and production staff is measurably reduced through intuitive, user-centric workflow design and automation.

● Data integrity is proactively enforced through automated validation gates, ensuring all transactions reaching Production meet technical completeness standards

● Schema changes follow a formal change process without disruptive production breakage

● Cross-team handoffs show measurable reductions in rework or delays

● Operational reporting has shifted from reactive status checks to predictive insights, providing automated triggers for churn risks and production bottlenecks

Duties & Responsibilities

Requirements Engineering (Internal Product Owner)

● Conduct structured interviews with stakeholders (Sales, Production) to extract complex business logic, transforming qualitative requirements into workflow pipelines, binary system gates, and automation triggers.

● Treat internal tools as a "Product" and internal staff as "Users," conducting user research to ensure workflows are intuitive and reduce friction.

● Act as the liaison between business stakeholders and technical teams to ensure alignment.

● Define, mandate, and manage the company's "Data Dictionary" and Standard Operating

Procedures (SOPs), ensuring a unified language and common framework is adopted across all functional teams.

System Ownership & Platform Governance

● Own the configuration and architecture of the company’s operating platform (currently ), defining object relationships and preventing schema drift.

● Translate strategic business objectives into system logic, automation rules, and workflows to create a scalable operating platform that generates measurable, actionable data.

● Define and enforce strict "Entrance and Exit Criteria" for all business process stages to prevent data errors (the enforcement aspect).

● Manage the change control process for system updates to prevent disruption to active workflows.

Business Intelligence

● Responsible for building decision-grade operational reporting and analysis (but not exploratory data science/research or data engineering).

● Query and analyze cross-functional data to drive strategic business decisions, identify performance gaps, and uncover opportunities for revenue optimization and growth (e.g., ROAS, marketing attribution, churn risks, customer LTV).

● Own and facilitate the weekly business review, working with management and leads to refine reporting and insights across the organization.

● Design and maintain management reporting dashboards to track key performance indicators and operational health.

Decision Authority

This role has final decision authority over the following areas:

● Operating system structure and data definitions

● Workflow stage definitions and gating logic

● Approval or rejection of system changes that affect data integrity

Desired Qualifications & Traits

● Systems Thinker: Possesses strong systems thinking capabilities, naturally visualizing the downstream effects of upstream changes (e.g., how a change in the Sales form affects the Production floor). They prioritize long-term scalability over short-term "hacks."

● Pragmatic Architect: Maintains a pragmatic approach to architecture, balancing "perfection with business utility." They know when to implement a rigid constraint and when to allow manual flexibility, always focused on delivering high-utility features.

● Operational Excellence Steward: Demonstrates operational discipline and the ability to define, promote, and enforce process compliance among diverse teams. They value consistency and predictability and are willing to say "No" when requests threaten system integrity and guide the team to the right trade-off.

● Analytical & Problem-Solving Mindset: Possesses an investigative nature, focusing on finding root causes and proactively hunting for "process leaks" and undefined variables. They validate assumptions with data rather than anecdotes.

● Coach & Change Leader: Possesses high emotional intelligence and the teaching ability to re-program legacy habits. They can explain why a new system is better to resistant teams and guide them through the transition with patience and clarity.

● Ambiguity Simplifier: Has the ability to simplify ambiguity, taking chaotic business inputs and structuring the information into linear, standardized processes.

● Translator & Data-Centric Communicator: Has strong communication skills to fluently bridge the gap, explaining technical constraints to non-technical stakeholders in plain English.

● Detail-Oriented: Is highly detail-oriented, obsessed with consistent naming conventions and data definitions. They notice misalignment in data definitions immediately, ensuring organizational clarity and data integrity.

Experience & Educational Requirements & Preferences

Experience & Educational Background

● 7+ years of experience in Business Operations, Systems Administration, or Data Analysis.

● Bachelor’s degree in Business, Information Systems, or related field required, Master's degree preferred.

● People Management and Team Building

Platform Expertise & Architecture

● Low-Code/No-Code Mastery: Advanced proficiency with Low-Code/No-Code platforms ( , Airtable, Salesforce) is required, including the management of complex automation rules, dependencies, and integration webhooks.

● Business Object Modeling / Relational Database Design: Proven experience designing relational database schemas (One-to-Many, Many-to-Many), specifically including the ability to translate flat spreadsheets into relational objects (e.g., separating "Orders" from "Line Items").

● API & Integration Knowledge: Ability to read API documentation to understand system

capabilities/limitations.

● Lightweight Scripting & Automation (Preferred): Proficiency with basic data-related scripting (Python, SQL) or advanced spreadsheet macros (VBA) to independently manipulate datasets or prototype logic is a strong plus.

Process, Intelligence, & Change Management

● Business Process Modeling (BPM): Experience with Business Process Modeling (BPM), including creating detailed swimlane diagrams to visualize hand-offs and defining strict "Entrance and Exit Criteria" for process stages.

● Business Intelligence (BI) & Reporting: Proficiency in designing Business Intelligence (BI) dashboards and reports, with an understanding of how to structure data for customer segmentation and cohort analysis.

● Change Management & Training: Experience managing change, designing rollout plans, and creating training materials and SOPs for users in a fast-paced environment.

About the Company

FCSLA Life is committed to providing exceptional service and support to our members. Our mission is to ensure that every member feels valued and understood, fostering a culture of inclusivity and respect.

About the Role

Experienced Microsoft Developer designs, develops, maintains and supports web-based and Windows applications. Strong expertise in C#, VB6, and Microsoft SQL Server, and a solid understanding of both modern and legacy systems. This role involves working closely with business stakeholders to enhance existing applications and build new solutions that meet evolving organizational needs.

Essential Functions

• Design, develop, and maintain Windows and web applications using Microsoft technologies
• Write clean, efficient, and well-documented code in C# and VB6
• Develop and optimize SQL Server databases, stored procedures, views and queries
• Maintain and modernize legacy VB6 Applications, including integration with newer systems
• Crystal Reports 10 experience and MS Access
• Collaborate with analysts, QA, and end users to gather requirements and deliver solutions
• Troubleshoot, debug, and resolve application and database issues
• Participate in code reviews and ensure adherence to development standards and best practices
• Support deployments, upgrades, and ongoing production maintenance
• Create technical documentation for applications and processes
• Resolving Help Desk issues
• All other duties as assigned

Education & Experience

• Four year degree or equivalent experience in computer science or related field
• Strong experience with C# (.NET Framework / .NET Core)
• Proven experience supporting and enhancing VB6 Applications
• Advanced knowledge of Microsoft SQL Server, including:
• T-SQL
• Stored procedures
• Performance turning and indexing
• Experience with web development (ASP.NET, MVC, Web APLs, or similar)
• Experience developing Windows applications (WinForms and/or WPF)
• Understanding of software development lifecycle (SDLC)
• Strong problem-solving and analytical skills
• Ability to work independently and collaboratively in a team environment
• Strong software development background and system management experience
• Proficiency with Microsoft Office Suite, Desktop PC and Calculator, Policy Management System (proprietary software for the main database), FormDocs and Fortis

Preferred Qualifications

• Experience migrating VB6 applications to .NET
• Familiarity with HTML, CSS, JavaScript
• Experience with Visual Studio, source control (Git, TFS, or similar)
• Knowledge of RESTful services and API integrations
• Experience in Agile or Scrum environments

Work Environment

This job is performed in a professional office environment. This is a full-time position with business hours Monday through Friday. Hours of work are typically 8:00 a.m. to 4:30 p.m. Additional hours may be worked as appropriate. Work is routinely performed using standard office equipment such as computers, phones and copiers, in a fast-paced environment.

Physical Demands

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. While performing duties of this job, the employee is regularly required to talk, hear, sit for long period of time, use of hands and fingers to keyboard, use of standard office equipment such as computers, phones and copiers, navigating about the office and viewing materials and equipment needed to perform required tasks. This position requires the ability to occasionally lift office products and supplies, up to 30 pounds. Work also requires ability to reach into top filing cabinet drawers and bend or stoop to reach into bottom filing cabinet drawers.

Travel

This position requires no travel.

Equal Opportunity Statement

FCSLA Life is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.

Summary

Our client, a Fortune 500 Medical Device company, has engaged GForce Life Sciences to source a skilled Clinical Site Lead (CSL). The CSL will oversee clinical study site maintenance, data collection, and field monitoring to ensure compliance with protocols, regulations, and Good Clinical Practices. Responsibilities include managing essential documents, resolving data discrepancies, reviewing adverse events, and coordinating site initiation. The role requires analytical problem-solving, process optimization, and continuous quality improvement. The CSL will monitor site performance, identify areas for improvement, and provide solutions to management.

Job Duties

• Monitors clinical studies at sites in an assigned territory (and others as requested) to ensure compliance with applicable regulatory requirements, Good Clinical Practice, and accuracy standards inclusive of site initiation, periodic, and close-out visits.
• Ensures both regulatory and clinical protocol compliance is maintained for all assigned clinical projects.
• Reviewing data and source documentation from investigational sites for accuracy and completeness
• Ensuring adverse events and protocol deviations are reported in an efficient manner
• Ensuring that device complaints and malfunctions are reported according to the client’s Policies and Procedures
• Resolving and/or facilitating resolution of problems including identification of cause and actions to prevent reoccurrence
• Coordinates with study teams, field clinical engineers or designee and specialists.
• Enroll sites into new and ongoing clinical studies
• Facilitate enrollment of study subjects via site coordinators
• Facilitate resolution of data queries and action items at clinical sites
• Promptly reports the findings of monitoring visits according to the client’s processes.
• Collaborates with in-house teams to ensure complete submission of study documents.
• Trains site personnel to ensure compliance with the study protocol and local regulations.

Requirements

• Bachelor’s Degree - Preferably with an academic focus in natural science, pre-medicine, nursing, bioengineering, or a related academic field.
• 10+ years of clinical trial monitoring experience required.
• Familiarity with cardiac, vascular, and/or neuromodulation technologies.
• Previous related experience in a medical device/pharmaceutical company or relevant clinical experience in a clinical/hospital environment.

Preferred Qualifications

• A general familiarity with cardiac, vascular, and/or neuromodulation technologies.
• Certification by an industry-recognized professional society (i.e. Society of Clinical Research Associates (SoCRA) or Association of Clinical Research Professionals (ACRP) or accredited institution

Term & Start

• Remote with travel to sites in SoCal
• 50-75% travel (depending on clinical trials)
• 12-month contract (extension probable)
• Benefits available (Medical, Dental, Vision, 401k)

Company Overview:

Fire-Dex is a family-owned, global manufacturer of head-to-toe personal protective equipment (PPE) for first responders and an Independent Service Provider (ISP) of PPE care and maintenance. Our mission is simple: to serve those who serve. We live by our values—Fun, Integrity, Respect, and Excellence (FIRE)—and take pride in being recognized as a multi award-winning organization, including Top Workplace by NorthCoast 99 and Weatherhead 100.

Role Summary

We are seeking an IT Web Developer to help support and enhance our custom web applications. This role is ideal for a developer who has a solid foundation in modern web development and is looking to grow their skills while working on real-world business systems.

The developer will work with tools such as React & JavaScript for frontend development. PHP backend using an MVC framework, and a MySQL database, all hosted in a Linux-based VPS environment. This role will collaborate closely with experienced IT team members, business stakeholders, and third-party developers contributing to new features, improvements, and ongoing application support. This will be a hybrid role located at our headquarters in Medina, OH.

Key Responsibilities

Application Development & Support

• Assist in maintaining and enhancing custom web applications
• Implement new features, UI improvements, and administrative tools under guidance from senior IT staff
• Troubleshoot and resolve application issues across frontend, backend, and database layers
• Learn and follow established coding standards and best practices

Backend & Database Contributions

• Write and maintain database queries and assist with schema updates
• Support backend development, including APIs and admin functionality
• Help ensure data accuracy, performance, and reliability

Required Skills & Experience

Experience and Education

• 1–3 years of experience supporting or building web applications
• Bachelor’s degree in Computer Science, Software Engineering, Information Systems, or IT is preferred
• Equivalent experience accepted (Associate’s degree, bootcamp, or self-taught) with demonstrable project work and ability to work in an existing codebase

Technical Foundation

• Working knowledge of JavaScript and React (components, hooks, API integration)
• Experience with PHP in a web application context
• Intermediate experience with relational database management systems, such as MySQL, Microsoft SQL Server, etc.
• Familiarity with Git and collaborative development workflows

General Competencies

• Ability to debug issues across frontend, backend, and database layer
• Willingness to learn existing systems and improve them incrementally
• Comfort working with established codebases
• Ability to cooperate effectively across teams while demonstrating strong self-accountability and leadership
• Ability to understand and interpret technical specifications to business stakeholders
• Strong attention to detail and eagerness to grow technical skills

Preferred / Nice-to-Have Skills

• Exposure to PHP frameworks (e.g. Laravel, Symfony, or similar)
• Experience with Microsoft Power Platform
• Basic familiarity with Linux environments
• Familiarity with NoSQL Databases, such as MongoDB
• Hands-on experience developing and deploying solutions in Azure and/or AWS cloud environments
• Production experience with large codes bases
• History of maintenance with business-critical systems
• Performance optimization skills (application and database-level) with large data applications

More Benefits Include:

• Competitive salary
• Employee Assistance Program
• Health, dental, and vision insurance
• Paid time off and parental leave
• 401(k) with matching, life insurance, EAP, discount programs and other perks
• Fulfillment about your work and this industry because it is impactful

More About Us:

• Our values include fun, integrity, respect, and excellence = FIRE!
• Our dedicated team of associates have helped pave the path of innovation for new products and services that are focused on the health and safety of first responders
• Temperature-controlled production floor with nice break rooms, fresh food market, and outdoor patios
• 40+ years in business
• Multi award-winning organization – including multiple repeat recognition as a Top Workplace by NorthCoast 99 eight times over, Family Business Achievement Awards, Smart Culture Awards, Cascade Business Growth Awards and Weatherhead 100!

Be part of making the highest quality personal protective equipment in the USA and keeping first responders safe!

Learn more about our culture and team!

• Find purposeful work making firefighter PPE: your work passion with the Fire-Dex family: It's Made: Turnout Gear: Opportunity Employer (EOE)

  Fire- Dex is an equal opportunity employer to all, regardless of age (40 and over), ancestry, color, disability (physical and mental, including HIV and AIDS), genetic information, gender identity and expression, marital status, medical condition, military or veteran status, national origin, race (includes traits historically associated with race, including, but not limited to, hair texture and protective hairstyles), religion (includes religious dress and grooming practices), sex (includes pregnancy, childbirth, breastfeeding, and related medical conditions), sexual orientation, or any other basis protected by law. We are committed to a diverse and inclusive workforce and actively seek to ensure that our hiring and employment practices reflect this commitment.

  
  

  Interview Process & Consent

  Fire‑Dex may use AI‑assisted tools to record and transcribe interviews for evaluation purposes, with candidate notice and consent. These tools support, but do not replace, human decision‑making. Interview data is handled in accordance with applicable privacy laws, including CCPA and GDPR.

  
  

  Please note: We are only considering direct applicants for this position. Third‑party agencies will not be considered.

The pay range for this role is $150,000 - $200,000/yr USD.

WHO WE ARE:

Headquartered in Southern California, Skechers—the Comfort Technology Company®—has spent over 30 years helping men, women, and kids everywhere look and feel good. Comfort innovation is at the core of everything we do, driving the development of stylish, high-quality products at a great value. From our diverse footwear collections to our expanding range of apparel and accessories, Skechers is a complete lifestyle brand.

ABOUT THE ROLE:

Skechers Digital Team is seeking a Digital Data Architect reporting to the Director, Digital Architecture, Consumer Domain. This role is responsible for designing and governing Skechers’ Consumer Data 360 ecosystem, enabling identity resolution, high-quality data foundations, personalization, loyalty intelligence, and machine learning capabilities across digital and retail channels.

The ideal candidate will be a strong technical leader, have hands-on full-stack technical knowledge in enterprise technologies related to Skecher’s consumer domain, and have the ability to work in a fast-paced agile environment. You should have knowledge of consumer programs from an architecture/industry perspective, and you should have strong hands-on experience designing solutions on the Salesforce Core Platform (including configuration, integration, and data model best practices).

You will work cross-functionally with Digital Engineering, Data Engineering, Data Science, Loyalty, and Marketing teams to architect scalable, secure, and high-performance data platforms that support advanced personalization and recommender systems.

WHAT YOU’LL DO:

• Responsible for the full technical life cycle of consumer platform capabilities which includes:
• Capability roadmap and technical architecture in alignment to consumer experience
• Technical planning, design, and execution
• Operations, analytics/reporting, and adoption
• Define and evolve Skechers’ Consumer Data 360 architecture, including identity resolution (deterministic and probabilistic matching) and unified customer profiles.
• Architect scalable data models and pipelines across CDP, CRM, e-commerce, marketing automation, data lake, and warehouse platforms.
• Establish enterprise data quality frameworks including validation, deduplication, anomaly detection, and observability.
• Optimize SQL workloads and large-scale distributed queries through performance tuning, partitioning, indexing, and workload management strategies.
• Design and oversee ML pipelines supporting personalization, churn modeling, and recommender systems.
• Partner with Data Science teams to productionize models using distributed platforms such as Databricks (Spark, Delta Lake, MLflow preferred).
• Ensure secure data governance, access control (RBAC/ABAC), and compliance with GDPR, CCPA, and related privacy regulations.
• Provide architectural oversight ensuring performance, scalability, resilience, and maintainability.
• Collaborate with stakeholders to translate business objectives (LTV growth, personalization lift, engagement) into scalable data solutions.

REQUIREMENTS:

• Computer Science, Data Engineering, or related degree or equivalent experience.
• 12+ years experience architecting enterprise data platforms in cloud environments.
• 9+ years experience with data engineering with a focus on consumer data.
• 6+ years experience working with Salesforce platforms, including data models and enterprise integrations.
• Strong experience with Data 360 and identity resolution architectures.
• Proven expertise in SQL performance tuning and large-scale data modeling.
• Hands-on experience implementing ML pipelines and recommender systems in production environments.
• Experience with cloud technologies (AWS, GCP, or Azure).
• Experience with integration patterns (API, ETL, event streaming).
• Experience providing technical leadership and guidance across multiple projects and development teams.
• Experience translating business requirements into detailed technical specifications and working with development teams through implementation, including issue resolution and stakeholder communication.
• Strong project management skills including scope assessment, estimation, and clear technical communication with both business users and technical teams.
• Must hold at least one of the following Salesforce Certifications (Platform App Builder, Platform Developer 1, JavaScript Developer 1).
• Experience with Databricks or similar distributed data/ML platforms preferred.