With Query Example Sql Jobs in Usa

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.

Software Engineer (Backend/APIs)

Software Engineers- bring your experience to work for you where people love to shop! Boscov's is a chain of full service department stores serving the total family needs of our customers. For over 100 years, Boscov's has been known for its great values and famous brands, and for offering a broad selection of quality merchandise in its stores and online.

We're looking for a backend engineer with a few years of experience who's ready to grow. This role will maintain and improve the systems that power a 100+ year old retail company — writing clean code, learning from senior engineers, and shipping features that matter. The ideal candidate is prepared to contribute meaningfully, receive constructive feedback, and develop professionally.

Job Responsibilities:

• Build and maintain backend systems and APIs in C# / .NET with SQL
• Implement features across our applications
• Collaborate with the team to uphold engineering standards, including testing, code reviews, and clean architecture
• Learn from senior engineers and team members
• Contribute to frontend work as needed (this is not a full-stack role, though comfort with HTML/CSS/JS is expected)
• Actively seek feedback and pursue continuous professional development

Qualifications:

• Approximately 3 years of software development experience
• C# / .NET expertise as a primary development platform
• SQL basics, including writing queries, understanding joins, and troubleshooting data issues
• Demonstrated desire for feedback and a commitment to continuous improvement
• Intellectual curiosity and a propensity to question and understand underlying systems

Preferred Qualifications

• Experience with REST API design
• Familiarity with testing (unit tests, integration tests)
• Exposure to CI/CD
• Any experience with retail or enterprise systems

Benefits

At Boscov's, we value our employees, and that's why we provide a competitive compensation and benefits package. As a Full-Time member of our team, you will be eligible to receive:

• Comprehensive benefits package, including medical/dental/vision
• Short term disability/ Long term disability- voluntary
• Life Insurance (company paid)
• 401(k) w/ company match
• Weekly Pay
• Paid vacation
• Liberal employee discount

Work where people love to shop!

Equal Opportunity Employer

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.

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.

Overview

We are looking for a technically strong, business-minded developer to design, build, and maintain internal applications and automations that improve how our team’s work. This role supports business processes, data, and technology and plays a key role in modernizing workflows across the organization. This role is suited for a strong mid-level to senior developer who can work independently while collaborating closely with team members and stakeholders.

While Microsoft Power Apps and Power Automate are core tools today, this role goes beyond low-code development. The ideal candidate brings strong fundamentals in application design, data flow, and user experience, with the ability to build scalable, secure, and well-documented solutions that can grow with business.

Key Responsibilities

• Design, build, and maintain end-to-end internal business applications using Microsoft Power Apps and related technologies.
• Develop business logic and workflow automation using Power Automate, integrating with internal and external data sources including Dataverse, SharePoint, SQL databases, and third-party APIs.
• Partner with stakeholders and leadership across multiple departments to understand business processes, gather requirements, and translate needs into practical, scalable technical solutions.
• Design secure, role-based solutions with appropriate permissions, governance controls, and environmental strategies following Power Platform ALM best practices.
• Ensure applications are well-structured with clean data flow, clear separation of logic, and thoughtful handling of edge cases and exceptions.
• Monitor, enhance, and support existing applications and automations to improve reliability, performance, and user adoption over time.
• Produce clear and thorough documentation covering business requirements, technical design, data structures, workflows, and known constraints.
• Contribute to and follow established development standards, templates, and best practices to ensure solutions are consistent, maintainable, and easy for other developers to support or extend.
• Provide technical guidance and information sharing with the team and collaborate on problem-solving with less-experienced developers.

Technical Requirements (Must Have)

• Hands-on experience building and maintaining custom, end-to-end applications using Power Apps.
• Strong experience developing business logic and workflows using Power Automate.
• Experience integrating multiple data sources, including Dataverse, SharePoint, SQL databases, and external APIs.
• Ability to design secure, role-based solutions with an understanding of Power Platform governance, environments, and ALM practices.
• Strong understanding of user-centered design principles and how they influence application structure, usability, and adoption.
• Proven ability to design solutions with well-organized data flow and clear movement of information between systems.
• Strong written communication skills, with the ability to create detailed technical and functional documentation.

Preferred Skills

• Power BI development experience using existing datasets and data models.
• Strong working knowledge of DAX and Power Query (M language).
• Experience building reports or dashboards that support operational or financial decision-making.

Experience Requirements

• Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related technical field
• 3-5 years of experience designing and delivering business applications or workflow automation solutions.
• Demonstrated experience delivering end-to-end solutions.
• Experience partnering directly with business stakeholders to translate operational needs into scalable technical solutions.

UI & Front-End Development Foundations

Even when working within low-code platforms, developers in this role are expected to understand core UI and front-end concepts, including:

• HTML, CSS, and JavaScript fundamentals
• Component-based design and reusable UI patterns
• Responsive design principles
• Basic state management concepts
• Accessibility and usability best practices

Our recruiting process is centralized and is handled by our HR Department. If we are sent unsolicited resumes from recruiters, we will not pay any recruiting fees. Unsolicited resumes are any resumes sent to us by a recruiter who has not been pre-approved by HR, has not signed our contract, and has not been requested by our HR Department to search for a specific position.

About Us:

Loloi Rugs is a leading textile brand that designs and crafts rugs, pillows, and throws for the thoughtfully layered home. Family-owned and led since 2004, Loloi is growing more quickly than ever. To date, we’ve expanded our diverse team to hundreds of employees, invested in multiple distribution facilities, introduced thousands of products, and earned the respect and business of retailers and designers worldwide. A testament to our products and our team, Loloi has earned the ARTS Award for “Best Rug Manufacturer” in 2010, 2011, 2015, 2016, 2018, 2023, and 2025.

Security Advisory: Beware of Frauds

Protect yourself from potential fraud and verify the authenticity of any job offer you receive from Loloi. Rest assured that we never request payment or demand any sensitive personal information, such as bank details or social security numbers, at any stage of the recruiting process. To ensure genuine communication, our recruiters will solely reach out to applicants using an @ email address. Your security is of paramount importance to us at Loloi, and we are committed to maintaining a safe and trustworthy hiring experience for all candidates.

As the Data Analyst, Strategic Insights & Visualization you will play a dual role within our data organization: you will be the primary storyteller for our business performance, but you will also be a hands-on technical practitioner responsible for the integrity of our reporting suite. You won’t just build dashboards; you will define the metrics that drive our strategy. Whether it’s untangling a complex business logic request, auditing data quality in our Power BI apps, or partnering with business leaders to prioritize their roadmaps, you will lead with data. If you are a proactive problem-solver who loves to turn raw numbers into actionable business narratives, this is the role for you.

Responsibilities

Technical Execution

• Reporting & Visualization: Act as the primary resource for building and maintaining Power BI reports and dashboards. Personally manage the end-to-end deployment of Power BI Apps, ensuring high performance and intuitive user experiences.
• Metric Logic: Write and optimize the SQL and DAX required for complex business logic. Work with the data engineering team to pull the necessary data across source systems. Take ownership of metric definitions to ensure consistency across all departments, from ERP inventory tracking to Ecommerce sales performance.
• Support & Triage: Manage the support queue for reporting incidents. Investigate data discrepancies, perform root cause analysis on quality issues, and ensure that our "source of truth" remains accurate and trusted by the organization.

Leadership & Operations

• Data Governance: Lead the development and maintenance of the enterprise data dictionary and business glossary. Ensure that all technical terms are translated into clear business language for non-technical stakeholders.
• Quality Control: Define and implement data quality rules and readiness scoring. Monitor data freshness and completeness, proactively alerting the engineering team when pipelines impact reporting SLAs.
• Security & Access: Help define access control and data security within the reporting environment, ensuring that users have the appropriate permissions and that sensitive data is protected according to company standards.

Stakeholder Collaboration

• Business Liaison: Act as the primary bridge between the data team and business leaders. Translate vague requests ("we need better inventory insights") into clear technical requirements and prioritized project milestones.
• Domain Prioritization: Participate in quarterly planning to sequence requests for Ecommerce, ERP, and Operations. Collaborate with the AI/ML team to prioritize use cases and define KPIs for advanced analytics initiatives.
• Self-Service Enablement: Conduct work sessions with business users to promote BI tool adoption and empower departments to perform their own ad-hoc analysis.

Experience, Skills, & Ability Requirements

• Bachelor’s degree in Business Analytics, Statistics, Information Systems, or equivalent professional experience
• 3+ years of hands-on experience in a Data Analyst or Business Intelligence role, preferably supporting Ecommerce or Retail operations.
• Proven track record of translating complex business requirements into robust, automated analytic reports and dashboards.
• Strong SQL skills and the ability to write complex queries to extract and transform data
• Proven proficiency in Power BI and DAX; experience managing Power BI service, workspaces, and app deployments.
• Strong understanding of data modeling concepts, specifically Star Schema and dimensional design.
• Experience with Microsoft Fabric or the Azure data stack.
• Proactive attitude toward data quality and a "details-matter" mindset when auditing reports.
• Excellent communication skills with the ability to explain complex data trends to executive stakeholders.
• Familiarity with Tableau.
• Microsoft Certified: Power BI Data Analyst Associate (PL-300).
• Experience modeling datasets (such as inventory, sales, or web performance) to identify trends, correlations, and performance gaps.
• Knowledge of basic Python for advanced forecasting or data manipulation.

What We Offer

• Health, dental, and vision benefits
• Paid parental leave
• 401(k) with employer match
• A culture of meritocracy that fosters ongoing growth opportunities
• A stable, growing family-owned company that looks after its employees

Loloi Rugs does not discriminate on the basis of race, sex, color, religion, age, national origin, marital status, disability, veteran status, genetic information, sexual orientation, gender identity or any other reason prohibited by law in provision of employment opportunities and benefits. We seek a diverse pool of applicants and consider all qualified candidates regardless of race, ancestry, color, gender identity or expression, sexual orientation, religion, national origin, citizenship, disability, Veteran status, marital status, or any other protected status. If you have a special need or disability that requires accommodation, please let us know.

Why USAA?

At USAA, our mission is to empower our members to achieve financial security through highly competitive products, exceptional service and trusted advice. We seek to be the #1 choice for the military community and their families.

Embrace a fulfilling career at USAA, where our core values – honesty, integrity, loyalty and service – define how we treat each other and our members. Be part of what truly makes us special and impactful.

The Opportunity

We are seeking a credentialed actuary to join our Property Loss Reserving and Reserving Development team.  This Actuary will leverage advanced knowledge of Loss Reserving techniques and Claims Analytics insights to explain drivers of loss trends.

We offer a flexible work environment that requires an individual to be in the office 4 days per week. This position is based in San Antonio, TX.  Relocation assistance is available for this position.

What you'll do:

• Applies advanced actuarial knowledge to complete broad and complex projects (e.g., evaluates and selects methodology to price new discount/endorsement for countrywide rollout; develops alternative methodologies to comply with complex regulatory requirements; selects metrics and designs processes to monitor model performance; translates business problems into technical requirements and performs required analysis to develop solutions; independently runs catastrophe models and interprets and communicates results to support critical business activities, while enhancing the control environment as needed.
• Utilizes advanced actuarial, mathematical, or statistical techniques to augment actuarial work product.
• Leads special actuarial projects, such as the development of new methodologies or reporting tools.
• Trains new team members on the theory and mechanics of relevant actuarial methodologies.
• Applies deep understanding of products supported, stakeholders’ needs, and industry trends to solve unstructured business problems.
• Identifies and anticipates compliance gaps and process improvements; recommends and develops solutions to mitigate risk.
• Represents Actuary in cross-functional efforts.
• Develops written communication and presentations that effectively convey data-driven solutions to broad audiences, including cross-functional executive leadership. 
• Ensures risks associated with business activities are effectively identified, measured, monitored, and controlled in accordance with risk and compliance policies and procedures.

What you have:

• Bachelor’s degree; OR 4 years of related Actuarial/business/analytical experience (in addition to the minimum years of experience required) may be substituted in lieu of degree.
• 4 years of Actuarial or analytical business experience.
• Associate of the Casualty Actuarial Society (ACAS) Credential.
• Demonstrated advanced skills with relevant actuarial, mathematical, and statistical techniques and approaches used to support fact-based decision-making.
• Advanced knowledge of data analysis tools, data visualization, developing analysis queries and procedures in Python, R, SQL, SAS, BI tools or other analysis software, and relevant industry data & methods and ability to connect external insights to business problems.
• Demonstrated experience communicating complex solutions and analysis to both technical and nontechnical audiences, including executive leadership.

What sets you apart:

• Experience performing Loss Reserve analysis and working in Loss Reserving software (i.e. ResQ, Arius etc.).
• US military experience through military service or a military spouse/domestic partner

Compensation range: The salary range for this position is: $127,310 - $229,160.

USAA does not provide visa sponsorship for this role. Please do not apply for this role if at any time (now or in the future) you will need immigration support (i.e., H-1B, TN, STEM OPT Training Plans, etc.).

Compensation: USAA has an effective process for assessing market data and establishing ranges to ensure we remain competitive. You are paid within the salary range based on your experience and market data of the position. The actual salary for this role may vary by location.

Employees may be eligible for pay incentives based on overall corporate and individual performance and at the discretion of the USAA Board of Directors.

The above description reflects the details considered necessary to describe the principal functions of the job and should not be construed as a detailed description of all the work requirements that may be performed in the job.

Benefits: At USAA our employees enjoy best-in-class benefits to support their physical, financial, and emotional wellness. These benefits include comprehensive medical, dental and vision plans, 401(k), pension, life insurance, parental benefits, adoption assistance, paid time off program with paid holidays plus 16 paid volunteer hours, and various wellness programs. Additionally, our career path planning and continuing education assists employees with their professional goals.

For more details on our outstanding benefits, visit our benefits page on .

Applications for this position are accepted on an ongoing basis, this posting will remain open until the position is filled. Thus, interested candidates are encouraged to apply the same day they view this posting.

USAA 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, disability, or status as a protected veteran.