With Query Example Sql Jobs in Usa
1,396 positions found — Page 5
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.
We have headquarteerd in Bloomfiled Hills, MI and have 16 offices spread across six countries.
We partner with Fortune 500 companies to address complex business challenges.
Our services span AI, IT staffing, cloud computing, engineering, mobility, testing, and more.
Certified with CMMI Level 3 and ISO standards, V2Soft is committed to quality and security.
Beyond our work, we actively support local communities and non-profits, reflecting our core values.
Join us to be part of a dynamic and impactful global company! Please visit us at to know more .
Must Have Skills: NICE Actimize Modules: experience with ActOne, Actimize Intelligence Server (AIS), Risk Case Manager (RCM), CDD Database Expertise: Proficiency in SQL and PL/SQL for data mapping, querying, and managing complex databases, particularly Oracle and MS SQL Server.
Development & Scripting: Strong coding skills in Java, along with experience in UNIX/Linux environments.
System Configuration: Building and customizing RCM workflows, AIS visual modeling, alert management, and UDM (Unified Data Model).
Integration & Tools: Experience using APIs (REST/SOAP), Autosys/Control-M for scheduling, and tools like JIRA or HP QC ALM.
Nice to Have Skills: Financial Crime & Compliance: Strong knowledge of Anti-Money Laundering (AML), Trade Surveillance, KYC, and Fraud Detection.
Process Analysis: Ability to translate complex business requirements into technical, automated solutions.
Education: Bachelors required.
V2Soft is an Equal Opportunity Employer ( EOE).
We welcome applicants from all backgrounds, including individuals with disabilities and veterans.
to view all of our open opportunities and to learn more about our benefits.
Must be in PST or MST time zone in the US What You ll Do Install, configure, and test healthcare applications and supporting systems Troubleshoot complex technical issues across Windows, IIS, SQL, and Active Directory Support production environments and customer implementations Perform log analysis, system monitoring, and workflow configuration Collaborate with project teams and provide customer-facing technical support Lead issue resolution and ensure high-quality documentation Must-Have Skills (Non-Negotiable) 3+ years in Tier II/III technical or application support Strong experience with Windows environment troubleshooting (Windows, IIS, SQL, ASP.NET, Active Directory) Experience supporting software applications and end users Ability to analyze logs and resolve complex technical issues Strong communication skills (client-facing role) Preferred Skills SQL (Select, Update, Delete queries) Network traffic analysis for performance troubleshooting Experience with RIS, PACS, or Diagnostic Imaging systems Knowledge of HL7 and/or DICOM
Who You Are:
The Tableau Developer is a key member of the Data & Analytics team reporting to Director of BI. This role is responsible for designing, developing, and maintaining interactive dashboards and reports using Tableau to support business decision-making. This role partners business stakeholders, data engineers, and analysts to translate complex data into intuitive visual insights while ensuring performance, data accuracy, and best visualization practices.
The role will follow Tableau best practices for visualization design, naming conventions, and documentation while also maintaining version control and promoting content across environments (Dev / Test / Prod) On Tableau Cloud.
What You'll Do:
- Design and develop interactive Tableau dashboards and reports that clearly communicate key business metrics and trends.
- Translate business requirements into effective data visualizations using best practices in visual analytics.
- Optimize dashboards for performance, scalability, and usability.
- Connect Tableau to multiple data sources (e.g., SQL databases, data warehouses, cloud platforms, Excel, APIs).
- Create and maintain data models, joins, calculations, parameters, and filters.
- Perform data validation and reconciliation to ensure accuracy and consistency.
- Work closely with stakeholders to gather requirements and understand reporting needs.
- Provide data-driven insights and recommendations to support strategic and operational decisions.
- Conduct user training and enablement sessions when needed.
- Monitor dashboard usage and performance.
- Troubleshoot data issues, refresh failures, and user access problems.
- Enhance and maintain existing dashboards as business needs evolve.
You'll Need To Have:
- Bachelor’s degree in computer science, Information Systems, Data Analytics, or related field.
- 5+ years of Tableau development experience.
- Solid understanding of SQL for data querying and validation.
- Experience working with relational databases and data warehouses (e.g., Snowflake, Redshift, SQL Server, Oracle).
- Strong knowledge of calculated fields, LOD expressions, table calculations, and parameters.
- Strong analytical mindset with attention to detail.
- Ability to interpret data and explain insights clearly to non-technical audiences.
- Understanding data modeling concepts (facts, dimensions, star schema).
- Excellent communication and stakeholder management skills.
- Ability to gather requirements and translate them into technical solutions.
- Strong problem-solving and time management skills.
We'd Love To See:
- Experience with Tableau Cloud administration.
- Knowledge of ETL tools like Talend or AWS Glue.
- Experience with Python or R for advanced analytics.
- Familiarity with Agile / Scrum methodologies.
- Tableau certification (Desktop Specialist, Certified Data Analyst, etc.).
Capri Perks:
- Generous Holiday Schedule & Vacation Days
- Internal mobility across Capri Brands (Michael Kors, Jimmy Choo, Versace)
- Cross-brand Discount
- Exclusive Employee Sales
- Fav 5 Cards (MK Discount for friends and family)
- 401k Match
- Paid Parental Leave
- Thrive Wellness Program (seasonal in-office massages and more!)
- Commuter Benefits
- Gym Discounts
CAPRI HOLDINGS is a global fashion luxury group consisting of iconic, founder-led brands Jimmy Choo and Michael Kors. Our commitment to glamorous style and craftsmanship is at the heart of each brand, as we design innovative products across the full spectrum of fashion luxury categories. The unique DNA and heritage of each brand, combined with the diversity and passion of our people, and our dedication to clients and communities, define our success.
The Company is an equal employment opportunity employer. The Company’s policy is not to unlawfully discriminate against any applicant or employee on the basis of race, color, sex, sexual orientation, gender identity, religion, national origin, age, military status, disability, genetic information or any other consideration made unlawful by applicable federal, state, or local laws. The Company also prohibits harassment of applicants and employees based on any of these protected categories.
At Capri Holdings Limited, we are committed to providing a fair and accessible recruitment process. If you require a reasonable accommodation for the interview or application process, please contact our Talent Acquisition team at
In compliance with certain Pay Transparency laws, employers are required to disclose a salary range. The salary for this position will vary based on role requirements, skill set and years of experience.
General Summary
The Supply Chain Analyst plays a critical role in supporting inventory and replenishment operations through data-driven insights. This role is responsible for extracting, analyzing, and visualizing data from the company’s main data warehouse and other systems using SQL and reporting tools. The analyst will collaborate with cross-functional teams to identify trends, optimize supply chain performance, and support strategic initiatives.
This position is also responsible for managing the JDA allocation system by creating/updating system components, allocation variables, allocation methods, reviewing system accuracy and operational effectiveness. They support the Inventory Management team, with creative solutions to allocation issues, research, training, and allocation statistics.
Key Responsibilities
· Manage flow optimization tools and analysis to identify inventory opportunities through the supply chain network for new and existing products.
· Prioritize the flow of products into and through the supply chain network including import orders, domestic orders, and on yard at the distribution centers.
· Analyze pre-season and in season holiday product flow changes within the network.
· Extract and manipulate large datasets using SQL, enterprise data warehouses and other systems.
· Design and build reports and dashboards to support inventory, replenishment, and supply chain operations.
· Perform root cause analysis on supply chain issues and recommend actionable solutions.
· Collaborate with IT, business stakeholders, and external partners to ensure data accuracy and system alignment.
· Support ad hoc analysis requests and present findings to leadership and cross-functional teams.
· Monitor key performance indicators (KPIs) and develop automated reporting solutions.
· Participate in system testing, upgrades, and enhancements related to supply chain tools.
· Participate and lead ad hoc projects for requests that involve supply chain coordination.
· Document processes, data flows, and reporting standards to ensure consistency and scalability.
· Manages the JDA Auto Allocations Schedule to meet promotional and daily needs.
· Maintain allocation system by creating and updating store views, need variables and methods.
· Monitor/maintain the system interfaces to/from the allocation system.
· Assist in training new and current allocation team members.
· Participate in development and testing of system enhancements.
· Provide allocation solutions to changing merchandise strategies.
Qualifications
Education:
• Bachelor’s degree in Supply Chain, Business Analytics, Information Systems, or related field.
Experience:
• 3+ years of experience in supply chain analytics or a related field.
• Strong experience writing complex SQL queries and working with relational databases.
• Advanced proficiency in MS Excel; proficiency in MS PowerPoint and Word (MS Access a plus)
• Experience with reporting and visualization tools (e.g., Power BI, Tableau).
• Familiarity with ERP systems and supply chain platforms (e.g., Relex, SAP, Oracle).
• JDA Allocation experience (1 or more years preferred)
Skills:
• Strong analytical and problem-solving skills.
• High attention to detail and data accuracy.
• Excellent communication and presentation abilities.
• Ability to work independently and manage multiple priorities.
• Knowledge of Python, R, or other scripting languages is a plus.
Work Environment & Expectations
• Office-based with flexible hybrid schedule (40+ hours/week).
Java Developer
Must have Java + Spring Boot
DESCRIPTION:
Job Responsibilities:
● Develop applications using Java 8/JEE (and higher), Angular 2+, React.js, SQL, Spring, HTML5, CSS, JavaScript and TypeScript among other tools.
● Write scalable, secure, maintainable code that powers our clients' platforms. ● Create, deploy and maintain automated system tests.
● Works with Testers to understand defects opened and resolves them in a timely manner ● Support continuous improvement by investigating alternatives and technologies and presenting these for architectural review
● Collaborates effectively with other team members to accomplish shared user story and sprint goals
Requirement:
● Experience in a programming language Java and JavaScript
● Decent understanding of the software development life cycle
● Basic programming skills using object-oriented programming (OOP) languages with in-depth knowledge of common APIs and data structures like Collections, Maps, lists, Sets etc.
● Knowledge of relational databases (e.g. SQL Server, Oracle) basic SQL query language skills
Preferred Qualifications:
● Master's Degree in Computer Science (CS)
● 0-1 year of practical experience in Java coding
● Experience using Spring, Maven and Angular frameworks, HTML, CSS ● Knowledge with other contemporary Java technologies (e.g. Weblogic, RabbitMQ, Tomcat, etc.) · Knowledge of JSP, J2EE, and JDBC
Overall Responsibility:
This role supports the design, development, and optimization of Arora’s enterprise data and ERP systems. This role reports directly under the Data Analytics Manager to improve financial reporting, support platform integrations, and build scalable data architecture that enables informed decision-making across the organization.
The position combines technical execution (SQL, automation, system configuration) with financial reporting support and cross-platform integration work to ensure accuracy, efficiency, and long-term system sustainability.
Essential Functions:
- Execute reporting and system requests in alignment with established data governance standards and reporting frameworks under the direction of the Data Analytics Manager.
- Contribute to the design of data models and system workflows that reduce manual processes and improve cross-functional data visibility.
- Support internal dashboards by creating backend data solutions and integrating with Vision.
- Provide system-level troubleshooting and ensure data consistency and reliability across platforms.
- Collaborate with teams to streamline processes through automation and data tools.
- Maintain documentation of data procedures, workflows, and system modifications.
- Support financial reporting and analysis by developing standardized, scalable reporting solutions aligned with company-wide data architecture.
- Assist in translating financial and operational requirements into structured reporting outputs and automation workflows.
- Assist in platform integrations (ERP, CRM, BI tools, and other enterprise systems) to support long-term architectural alignment and scalability.
Needed Skills:
- Ability to program in SQL at an expert level to assist data processes. Potential need for other programming language knowledge (Java, Python, etc.).
- Ability to create and maintain productive relationships with employees, clients, and vendors.
Education/Experience Minimum:
- 3-5 years of experience
- Strong programming skills having the ability to write complex queries.
- Preferred familiarity with all Microsoft platforms, including but not limited to Excel, Power BI, SharePoint, and SQL Server.
- Preferred experience with Deltek Vision v7.6 and VantagePoint
- Experience in building automated processes and data workflows.
- Strong problem-solving and attention to detail.
Title: Senior Data Analyst
Duration: Long term
Location: Dallas , TX
Job Description:
Primary responsibilities of the Senior Data Analyst include supporting and analyzing data anomalies for multiple environments including but not limited to Data Warehouse, ODS, Data Replication/ETL Data Management initiatives. The candidate will be in a supporting role and will work closely with Business, DBA, ETL and Data Management team providing analysis and support for complex Data related initiatives. This individual will also be responsible for assisting in initial setup and on-going documentation/configuration related to Data Governance and Master Data Management solutions. This candidate must have a passion for data, along with good SQL, analytical and communication skills.
Responsibilities
- Investigate and Analyze data anomalies and data issues reported by Business
- Work with ETL, Replication and DBA teams to determine data transformations, data movement and derivations and document accordingly
- Work with support teams to ensure consistent and pro-active support methodologies are adhered to for all aspects of data movements and data transformations
- Assist in break fix and production validation as it relates to data derivations, replication and structures
- Assist in configuration and on-going setup of Data Virtualization and Master Data Management tools
- Assist in keeping documentation up to date as it relates to Data Standardization definitions, Data Dictionary and Data Lineage
- Gather information from various Sources and interpret Patterns and Trends
- Ability to work in a team-oriented, fast-paced agile environment managing multiple
- priorities
Qualifications
- 4+ years of SQL experience working in OLTP, Data Warehouse and Big Data databases
- 4+ years of experience working with Exadata and SQL Server databases
- 4+ years in a Data Analyst role
- Strong attention to Detail
- 2+ years writing medium to complex stored procedures a plus
- Ability to collaborate effectively and work as part of a team
- Extensive background in writing complex queries
- Extensive working knowledge of all aspects of Data Movement and Processing, including ETL, API, OLAP and best practices for data tracking
- Good Communication skills
- Self-Motivated
- Works well in a team environment
- Denodo Experience a plus
- Master Data Management a plus
- Big Data Experience a plus (Hadoop, MongoDB)
- Postgres and Cloud Experience a plus
Healthcare Business Intelligence & Analytics Analyst -Information Technology
Location:
620 Foster Avenue Brooklyn, NY 11230
Hours:
Full Time
Premium Health Center, a rapidly growing FQHC in Brooklyn, is seeking a detail-oriented and analytical Business Intelligence (BI) Analyst to join our growing Data & Analytics team. This role blends data analysis with light data engineering to build robust data pipelines, deliver actionable insights, and create high-quality reporting and analytics. The BI Analyst will play a key role in transforming raw data into actionable insights that will directly inform strategic, clinical, operational, and financial decisions across the organization.
Time Commitment:
Full Time, Hybrid Eligible
Responsibilities:
Analytics, Visualization & Storytelling
· Design, develop, and maintain dashboards, reports, and data visualizations in Power BI (or similar tools)
· Apply data visualization and storytelling best practices to create intuitive, user-friendly dashboards.
· Translate complex healthcare data into clear, actionable insights that support decisions for clinical, operational, finance, and executive teams.
· Develop and maintain semantic data models, KPIs, and performance metrics aligned with FQHC goals.
· Collaborate with stakeholders to gather requirements and recommend effective analytical and visual solutions.
· Analyze healthcare data from EHR systems (e.g.,eClinicalWorks, Office Practicum, etc) and other sources to identify trends, gaps, and opportunities for improvement.
· Support UDS (Uniform Data System) reporting and other regulatory compliance requirements.
· Create sustainable reporting frameworks for recurring healthcare and operational metrics.
Data Engineering &Pipeline Support
· Build and maintain light ETL and data integration tasks using SQL, APIs, and scripting tools.
· Write and optimize SQL queries to support analysis, dashboards, and data pipelines.
· Perform data wrangling, cleaning, validation, and transformation to prepare datasets for analysis and reporting.
· Ensure data integrity, accuracy, and security in all reporting and data engineering workflows.
· Perform data validation, reconciliation, and root-cause analysis for data quality issues.
Collaboration and Data Literacy
· Collaborate with clinical, operational, and executive teams to understand business needs and translate them into technical solutions.
· Provide training, documentation, and support to improve data literacy and promote appropriate self-service use of organizational dashboards.
· Collaborate with IT and data teams on architecture, governance, and data quality initiatives.
Requirements:
· Bachelor's degree in Data Science, Public Health, Health Informatics, Computer Science, ora related field.
· 4+years of experience in a BI, data analyst, or similar role, preferably in a healthcare or FQHC setting.
· Strong proficiency in SQL, including complex joins, window functions, and data transformations
· Hands-on experience with Power BI, or similar BI platform, including DAX, data modeling, and visualization design.
· Experience working with scripting languages (Python, R, etc) and APIs to support data integration and automation.
· Experience with semantic data modeling in Power BI.
· Strong analytical, critical thinking, and problem-solving skills.
· Excellent communication and data storytelling skills with the proven ability to present insights to non-technical audiences.
· Detail oriented with strong data troubleshooting and validation skills.
· Highly organized, with the ability to manage multiple tasks and deadlines.
· Self-starter who works independently and collaboratively.
· Ability to partner cross-functionally across clinical, operational, financial, IT, and data teams.
· Fast learner with adaptability to evolving tools and organizational needs.
· Strong commitment to high standards of data quality, accuracy, and confidentiality.
· Familiarity with HIPAA or other similar data privacy standards.
Preferred:
· Experience with Microsoft Azure, Fabric, Purview, or similar cloud platforms.
· Experience with Power Automate or similar tool for basic workflow automation.
· Familiarity with Git or similar version control tools.
· Experience with EHR systems (eCW, Office Practicum, etc,).
· Understanding of healthcare data, including clinical, operational, and financial metrics.
· Experience with UDS reporting or other healthcare regulatory or quality metrics.
Compensation:
$110,000 - $145,000, commensurate with experience
Benefits:
· Medical, Dental, Vision and Life coverage
· Paid Time Off and holidays
· Employee Assistance Program
· Flexible spending account
· Public Service Loan Forgiveness (PSLF), NHSC Loan Repayment Program
· 403(b) Retirement Plans with employer matching
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.